Create, read, edit, and analyze Excel spreadsheet files with openpyxl and pandas.
npx skills add https://github.com/ChenYCL/claude-skills-collection --skill xlsx-chenycl
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/ChenYCL/claude-skills-collection/tree/main/xlsx Command: npx skills add https://github.com/ChenYCL/claude-skills-collection --skill xlsx-chenycl
This Skill automates the creation, editing, and analysis of Excel spreadsheets, streamlining data management and visualization tasks.
Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns 'Product', 'Quantity', and 'Price'.
High-intent search queries and answers about installing and using this skill.
You can automate creating an Excel spreadsheet with formulas and charts by using openpyxl and pandas to generate workbooks, compute formulas, apply formatting, and visualize tabular data programmatically.
Yes, you can convert CSV or TSV files into a formatted Excel workbook by reading the tabular data with pandas and writing it into an .xlsx or .xlsm file using openpyxl.
Yes, openpyxl supports adding pivot tables and formatting, while pandas handles cleaning messy spreadsheet data, allowing you to process and structure tabular data efficiently.
The best way to read and edit an existing .xlsm file is to use pandas for data extraction and openpyxl for modifying the workbook structure, formulas, and formatting.
Yes, you can use pandas to clean tabular data and export it to Excel, then use openpyxl to add charts and formatting to the generated spreadsheet file.
When using openpyxl for spreadsheet analysis on large datasets, performance may be limited by memory constraints, so pandas is recommended for heavy data processing before writing final results to Excel.
dp-archiveAutomate spreadsheet creation, editing, analysis, and formatting for .xlsx, .csv, and .tsv files.
IsKenKenYaAnalyze Excel spreadsheets by importing data, cleaning it, and generating pivot tables and charts.
kk580kkAnalyze Excel spreadsheet data with pivot tables and charts.
mkurmanAutomate spreadsheet manipulation and data cleaning with pandas and openpyxl.
