xlsx-manipulation

Programmatic Excel spreadsheet creation, editing, and manipulation using openpyxl. This skill enables programmatic creation, editing, and manipulation of Microsoft Excel (.xlsx) spreadsheets using the openpyxl library. Create professional spreadsheets with formulas, formatting, charts, and data validation without manual editing. Example prompts: - Create and modify .xlsx files with cell data, formulas, formatting, and charts without manual editing - Supports styling (fonts, fills, borders, alignment), number formatting, conditional formatting, and data validation - Build charts (bar, line, pie), manage sheets, freeze panes, set column widths, and apply auto-filters - Cannot execute VBA macros or handle complex pivot tables; some advanced chart types unavailable - Describe the spreadsheet you want to create or modify - Provide data, formulas, or formatting requirements - I'll generate openpyxl code and execute it - "Create a budget spreadsheet with monthly tracking" - "Add conditional formatting to highlight values above threshold" - "Generate a pivot-table-like summary from this data" - "Create a dashboard with charts and KPIs" - Use Templates : Start with a .xlsx template for complex formatting - Batch Operations : Minimize cell-by-cell operations for speed - Named Ranges : Use defined names for clearer formulas - Data Validation : Add validation to prevent input errors -...