Create and modify Excel workbooks with formulas using pandas and openpyxl.
npx skills add https://github.com/ammosu/awesome-claude-skills-zh-TW --skill xlsx-ammosu
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/ammosu/awesome-claude-skills-zh-TW/tree/main/document-skills/xlsx Command: npx skills add https://github.com/ammosu/awesome-claude-skills-zh-TW --skill xlsx-ammosu
This Skill eliminates repetitive spreadsheet tasks by enabling Claude to create, edit, and analyze Excel workbooks with preserved formulas and formatting.
Use the xlsx skill to create a new workbook named 'monthly_dashboard.xlsx' with a header row, sample data, and a formula that sums a numeric column.
High-intent search queries and answers about installing and using this skill.
Automate Excel workbook creation by generating new .xlsx files with cell styles, named ranges, and dynamic formulas using pandas and openpyxl. This enables building financial models and dashboards directly from data inputs without manual formatting.
Yes, you can edit existing Excel workbooks while retaining the original formulas so recalculation stays dynamic. This ensures that modifying data or structure in an .xlsx file does not break existing formula logic or formatting.
Yes, a local LibreOffice installation is required to recalculate formulas within modified workbooks. While openpyxl handles file creation and editing, LibreOffice processes the actual formula computation to ensure accurate values in the output.
Import data from .csv or .tsv files using pandas to compute metrics and generate summaries. This approach supports dashboard generation by consolidating raw data into structured Excel workbooks with visualizations and calculated metrics.
Yes, this Excel automation approach supports .xlsm files alongside .xlsx, .csv, and .tsv formats. This allows you to manage macro-enabled workbooks, apply data analysis workflows, and maintain formulas across different spreadsheet file types.
pacphiCreate, edit, and analyze Excel workbooks with formulas and pandas.
vasilyu1983Create, edit, and analyze Excel workbooks with formulas and charts.
Wesley1600Create pivot tables and charts in Excel with pandas and openpyxl.
ammosuCreate and modify Excel workbooks with formulas using pandas and openpyxl.
