Create and edit Excel files with formulas, formatting, and pandas analysis.
npx skills add https://github.com/guangtouwangba/weaver --skill xlsx-guangtouwangba
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/guangtouwangba/weaver/tree/main/.claude/skills/xlsx Command: npx skills add https://github.com/guangtouwangba/weaver --skill xlsx-guangtouwangba
This Skill empowers users to create, edit, and analyze spreadsheet data with advanced formula support, formatting, and data analysis capabilities, eliminating manual calculation errors and ensuring data integrity.
.xlsx files or modify existing ones, including adding data, formulas, and complex formatting.recalc.py to ensure all formulas are correctly calculated and to identify and report errors like #REF!, #DIV/0!, etc.pandas library for powerful data manipulation, analysis, and visualization directly from Excel files.Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add a formula in the 'Total Revenue' cell to sum the 'Revenue' column.
High-intent search queries and answers about installing and using this skill.
To create an Excel file with formulas, you can generate a new .xlsx spreadsheet, add your formulas, and then run a recalculation script using LibreOffice to verify calculations and detect errors like #DIV/0! or #REF!, ensuring accurate dynamic results.
Yes, you can use pandas for data analysis directly on an existing xlsx spreadsheet by loading the file into a DataFrame, enabling powerful data manipulation, trend analysis, and visualization without manual data extraction.
The best way to automate recalculating Excel formulas and checking for errors is utilizing LibreOffice integration, which processes the spreadsheet to recalculate all formulas dynamically and reports specific formula errors to guarantee data integrity.
Yes, this spreadsheet tool supports editing csv files alongside xlsx, xlsm, and tsv formats, allowing you to apply complex formatting, populate data, and insert formulas across multiple supported spreadsheet file types.
Prioritizing Excel formulas over hardcoded values in generated spreadsheets ensures data integrity and dynamic calculations, meaning that when source data changes, all dependent values update automatically without requiring manual recalculation.
You can build a financial projection spreadsheet by populating it with data and formulas, verifying calculations via LibreOffice, and then leveraging pandas to analyze the projected revenue trends directly from the final Excel file.
pacphiCreate, edit, and analyze Excel workbooks with formulas and pandas.
MooseGoose0701Create, edit, analyze, and visualize .xlsx, .csv, and .tsv files with Python.
treasure-dataExecute SQL queries against Treasure Data using the Trino CLI.
take566Create and edit Excel spreadsheets with pandas, openpyxl, and LibreOffice formula recalculation.