Create, edit, and analyze Excel spreadsheets with formulas, formatting, and recalculation.
npx skills add https://github.com/qfwc258/trae-skills --skill xlsx-qfwc258
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/qfwc258/trae-skills/tree/main/xlsx Command: npx skills add https://github.com/qfwc258/trae-skills --skill xlsx-qfwc258
High-intent search queries and answers about installing and using this skill.
Use openpyxl to write formula strings like '=SUM(B2:B9)' directly into cells, then save the workbook. Run the recalc.py script afterward so LibreOffice calculates the formula values and reports any errors.
Use pandas for data analysis, bulk operations, and simple exports with pd.read_excel and df.to_excel. Use openpyxl when you need formulas, cell formatting, multiple sheets, or edits to existing workbooks.
openpyxl stores formulas as strings but never evaluates them, so saved files lack computed values. Recalculate with LibreOffice using the recalc.py script, which updates values and scans all cells for errors.
Run recalc.py and inspect the JSON error_summary, which lists each error type with exact cell locations. Fix invalid references, guard divisions against zero denominators, then recalculate again until the status is success.
Yes, load the file with data_only=True to read cached calculated values instead of formula strings. Do not save in that mode, because saving replaces all formulas with static values permanently.
mxzinkeRead, clean, transform, and convert spreadsheet data across .xlsx, .csv, and .tsv formats.
aisa-groupTransform raw metrics into narrative frameworks with recommendations for stakeholder presentations.
dengzhe-houValidate EEG analysis claims across plan, stats, and report artifacts.
alexaundreProcess and produce .xlsx, .xlsm, .csv, and .tsv spreadsheet files with formulas and validation.
