python-xlsx
Create and edit Excel spreadsheets (.xlsx) in Python with openpyxl/xlsxwriter. WHEN: Creating Excel files with formulas/formatting, reading .xlsx/.xlsm files, modifying spreadsheets while preserving formulas, adding charts/visualizations to Excel. WHEN NOT: Simple CSV reading (use pandas), Word documents (use python-docx), PDF files (use python-pdf).
Installation and usage
Create and edit Excel spreadsheets (.xlsx) in Python with openpyxl/xlsxwriter. WHEN: Creating Excel files with formulas/formatting, reading .xlsx/.xlsm files, modifying spreadsheets while preserving formulas, adding charts/visualizations to Excel. WHEN NOT: Simple CSV reading (use pandas), Word documents (use python-docx), PDF files (use python-pdf).
Once installed, you can use this skill by running the following command in your terminal:
skills use python-xlsx