Automate spreadsheet operations on .xlsx, .xlsm, .csv, and .tsv files using Python.
npx skills add https://github.com/lidge-jun/cli-jaw-skills --skill xlsx-lidge-jun
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/lidge-jun/cli-jaw-skills/tree/main/xlsx Command: npx skills add https://github.com/lidge-jun/cli-jaw-skills --skill xlsx-lidge-jun
This Skill empowers you to create, read, edit, analyze, and format spreadsheet files (.xlsx, .xlsm, .csv, .tsv) with precision and efficiency, handling everything from basic data entry to complex financial modeling.
openpyxl and pandas..xlsx file.Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns 'Date', 'Product', and 'Revenue', then add three rows of sample data.
High-intent search queries and answers about installing and using this skill.
To automate Excel formula recalculation and formatting in xlsx files, use Python scripts with openpyxl and pandas to implement formulas, apply conditional formatting, and ensure data integrity for professional deliverables.
Yes, you can use pandas and openpyxl to read and edit csv and tsv files, automating spreadsheet operations like data manipulation, complex edits, and advanced formatting for .xlsx, .xlsm, .csv, and .tsv formats.
The best way to handle CJK text and accessibility standards in spreadsheet creation is adhering to financial modeling conventions while using Python libraries to ensure professional deliverables meet required formatting and structural compliance.
Direct OOXML editing works for advanced customization of Excel files by manipulating the underlying XML structure, allowing precise modifications beyond standard spreadsheet formatting and data manipulation capabilities.
To create a monthly sales report with charts from raw spreadsheet data, read the data with pandas, apply financial formulas for calculations, generate bar charts of regional performance, and save the output as a formatted .xlsx file.
Use pandas for reading and analyzing raw spreadsheet data, and openpyxl for creating, editing, and formatting spreadsheets with formulas, charts, and conditional formatting to generate professional reports.
mattmacleod16-svgAutomate spreadsheet creation, editing, analysis, and formatting with openpyxl and pandas.
marktantongcoProcess, edit, and generate XLSX spreadsheets with formula-safe integrity checks.
haojing8312Read, create, edit, and validate Excel files via Office Open XML.
rezosndGenerate styled Excel workbooks with formulas, charts, and data validation.