Create and edit Excel workbooks with pandas and openpyxl, recalculating formulas via LibreOffice.
npx skills add https://github.com/favouritehu/call_tracking --skill xlsx-favouritehu
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/favouritehu/call_tracking/tree/main/skills/xlsx Command: npx skills add https://github.com/favouritehu/call_tracking --skill xlsx-favouritehu
This Skill eliminates the tedious manual work of creating, editing, and recalculating complex Excel workbooks, ensuring formula integrity and consistent formatting across sheets.
Create a new workbook, populate a small dataset, add simple formulas referencing the data, and run the recalc.py script to refresh all formulas.
High-intent search queries and answers about installing and using this skill.
Automate Excel workbook creation and formula recalculation by using Python libraries pandas and openpyxl to build or update XLSX files, then running the recalc.py script with LibreOffice to refresh all formulas and verify outputs.
The best way to update XLSX files while preserving formulas is to programmatically edit the workbook with openpyxl, which maintains template structure and formula integrity across multiple sheets without manual intervention.
You can use pandas to read and write data for automated Excel reporting, enabling efficient data handling and analysis across multiple sheets to generate dashboards and financial models within XLSX workbooks.
You need LibreOffice to recalculate formulas in Excel workbooks because the recalc.py script relies on it to refresh all formulas and verify outputs, ensuring formula integrity without opening Excel manually.
openpyxl does not calculate formula values when you edit an Excel file because it only writes the formula strings, requiring the separate recalc.py script with LibreOffice to execute full formula recalculation and produce cached values.
This approach to Excel automation works for financial models and dashboards by programmatically building, updating, and recalculating complex spreadsheet-heavy workbooks across multiple sheets while ensuring consistent formatting and formula integrity.
cbbkrd-techCreate, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.
haidonglethqbCreate, validate, and recalculate Excel workbooks in .xlsx, .csv, and .tsv formats.
vuminhieuCreate, edit, and analyze spreadsheet files with formulas and formatting.
Ikram-AlamCreate and edit Excel .xlsx files with formulas, formatting, and color-coding using openpyxl and pandas.
