Create and edit Excel files with formulas, formatting, and pandas analysis.
npx skills add https://github.com/heyflouai/ikf-central-dashboard --skill xlsx-heyflouai
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/heyflouai/ikf-central-dashboard/tree/main/.claude/skills/xlsx Command: npx skills add https://github.com/heyflouai/ikf-central-dashboard --skill xlsx-heyflouai
This Skill empowers users to create, edit, and analyze complex spreadsheet files (.xlsx, .xlsm, .csv, .tsv) with advanced features like formulas, formatting, and data analysis, eliminating manual spreadsheet drudgery.
recalc.py.recalc.py script to verify all calculations and identify any potential errors before delivery.Use the xlsx skill to create a new Excel file named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add a formula in cell D2 to sum the 'Revenue' column.
High-intent search queries and answers about installing and using this skill.
To create an Excel file with formulas and formatting, you can generate new .xlsx spreadsheets while preserving complex formulas and applying advanced formatting. This approach eliminates manual spreadsheet drudgery by automating the creation of structured financial reports.
Yes, pandas can be used for data analysis directly within an existing xlsx spreadsheet. This functionality allows you to leverage pandas for in-depth data manipulation and analysis, facilitating dynamic spreadsheet updates and comprehensive data reporting.
LibreOffice integration helps check Excel formulas for errors by performing integrated formula recalculation. This ensures formula integrity and accuracy by verifying all calculations and identifying any potential errors before you deliver the final spreadsheet.
The best way to build a financial projection model in Excel is to automate the generation of complex formulas and specific formatting. You can then use formula recalculation scripts to verify all calculations and identify potential errors before delivery.
You can edit .xlsm, .csv, and .tsv files in addition to standard .xlsx files. This comprehensive spreadsheet management capability supports modifying existing files while preserving formulas, formatting, and data structures across multiple formats.
To verify formula integrity when modifying complex spreadsheets, use integrated formula recalculation via LibreOffice. This process recalculates formulas and runs error detection to ensure calculation accuracy and identify any potential errors in your spreadsheet.
shalevaminCreate, edit, analyze, and format .xlsx, .csv, and .tsv spreadsheet files.
benyichanGenerate and format Excel reports from DataFrames using openpyxl.
CHNISamAutomate spreadsheet manipulation with openpyxl and pandas for data cleaning and reporting.
vinayakgCreate and edit Excel files with formulas, formatting, and pandas analysis.