Create and edit XLSX files with pandas and dynamic formulas.
npx skills add https://github.com/WyRainBow/Resume-Agent --skill xlsx-wyrainbow
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/WyRainBow/Resume-Agent/tree/main/backend/agent/skills/office-files/xlsx Command: npx skills add https://github.com/WyRainBow/Resume-Agent --skill xlsx-wyrainbow
This Skill streamlines the creation, editing, and analysis of Excel files, ensuring accuracy, proper formatting, and dynamic formula calculations.
recalc.py script to identify and report formula errors.Use the xlsx skill to create a new Excel file named 'financial_model.xlsx' with a 'Revenue' sheet containing columns for 'Year' and 'Projected Revenue', and populate it with data for the next 5 years using formulas.
High-intent search queries and answers about installing and using this skill.
Automating Excel financial modeling involves generating spreadsheets with dynamic formulas to ensure recalculation capabilities. This approach uses openpyxl to create files and applies industry-standard formatting for financial models.
Analyzing spreadsheet data with pandas involves reading, manipulating, and analyzing XLSX files. This allows for automated data extraction and transformation while maintaining proper spreadsheet structure and formatting.
LibreOffice recalculation verifies formula accuracy by running a script that identifies and reports formula errors. This error verification process ensures generated Excel files have zero calculation errors before final output.
Generating a revenue projection model in Excel involves creating sheets with columns for Year and Projected Revenue. The process applies industry-standard color coding and number formatting to ensure professional financial model presentation.
Pandas works with openpyxl to read, edit, and manipulate XLSX files. This combination supports dynamic formula creation and data manipulation while ensuring proper spreadsheet formatting and structure.
Formula errors in generated Excel files occur when hardcoded values replace dynamic formulas. Using a recalculation script identifies and reports these errors, ensuring formulas remain intact and recalculable for accurate financial modeling.
mkurmanAutomate spreadsheet manipulation and data cleaning with pandas and openpyxl.
jiunbaeExtract and convert text, tables, images, and metadata across PDF, DOCX, XLSX, PPTX formats.
Buntyarora97Create Excel spreadsheets with formatting, formulas, charts, and data validation.
refly-aiManage Google Sheets data, formatting, and charts via the API.