Create, edit, and analyze Excel spreadsheets with formulas and pandas.
npx skills add https://github.com/XD3an/cc-plus --skill xlsx-xd3an
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/XD3an/cc-plus/tree/main/skills/xlsx Command: npx skills add https://github.com/XD3an/cc-plus --skill xlsx-xd3an
This Skill streamlines the creation, editing, and analysis of spreadsheet files, handling complex formulas, formatting, and data manipulation efficiently.
.xlsx files with data, formulas, and custom formatting.Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns 'Product', 'Quantity', and 'Price', and add a formula to calculate the total revenue in the last column.
High-intent search queries and answers about installing and using this skill.
To create an Excel file with formulas, use openpyxl to generate .xlsx files and inject dynamic formulas programmatically. This approach allows you to build spreadsheets with calculated columns while preserving custom formatting and industry-standard templates.
Yes, you can recalculate Excel formulas by executing the recalc.py script, which requires LibreOffice to process and update formula values. This ensures formula accuracy in existing spreadsheets without manual intervention.
The best way to analyze spreadsheet data with pandas is to load your .xlsx, .csv, or .tsv files into DataFrames for manipulation. This enables robust data analysis, filtering, and visualization directly from existing spreadsheets.
Yes, this spreadsheet management approach supports financial modeling standards by generating projection models with dynamic formulas and formatting. It ensures adherence to industry conventions when creating financial reports.
You do not need LibreOffice to edit .xlsx files, as openpyxl handles file creation and manipulation. However, LibreOffice is strictly required if you need to recalculate complex formulas using recalc.py.
Yes, you can convert CSV data into a formatted Excel spreadsheet by reading the data with pandas and writing it to a new .xlsx file using openpyxl. This allows you to apply custom formatting and formulas to the converted data.
cbbkrd-techCreate, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.
ronniwheellike973Manage and analyze .xlsx files with pandas, openpyxl, and formula recalculation.
vuhuudoCreate, edit, and analyze Excel spreadsheets using pandas and openpyxl.
MooseGoose0701Create, edit, analyze, and visualize .xlsx, .csv, and .tsv files with Python.