Create, inspect, and edit Excel workbooks while preserving formulas and formatting.
npx skills add https://github.com/Glour/ai-office-v2 --skill excel-xlsx-glour
Please help me install this Agent Skill. Skill: excel-xlsx Source: https://github.com/Glour/ai-office-v2/tree/main/skills/excel-xlsx Command: npx skills add https://github.com/Glour/ai-office-v2 --skill excel-xlsx-glour
This skill helps users manage Microsoft Excel workbooks (.xlsx, .xlsm, .xls), and related formats like CSV or TSV, with reliable formulas, dates, types, formatting, recalculation, and template preservation. It addresses the challenge of maintaining data integrity and workbook structure across edits and different environments.
Open your workbook and apply the recommended workflow to update cells while preserving formulas, styles, and templates.
High-intent search queries and answers about installing and using this skill.
To edit an Excel workbook while preserving formulas, formats, and structure, apply an openpyxl-based workflow that updates cells without overwriting existing template logic. This ensures formula integrity and cross-platform consistency during modifications.
Yes, you can use pandas for data analysis while relying on openpyxl to maintain workbook structure. This separation ensures formulas, styles, and templates are preserved during analytical processing of XLSX files.
The best way to handle dates and data types in Excel automation is using openpyxl for correct type enforcement and recalculation. This ensures accurate date handling and consistent data typing across financial models.
Yes, openpyxl supports updating financial models and dashboards in XLSX by preserving formulas, styles, and workbook structure. It ensures cross-platform consistency and accurate recalculation for complex templates.
You should use CSV for data exchange in pipelines when you need lightweight, cross-platform data transfer without formulas or formatting. XLSX is recommended when preserving formulas, styles, and template structure is required.
Excel templates lose formatting when updated programmatically if the library overwrites workbook structure. Using openpyxl with template preservation ensures formulas, styles, and formats remain intact during cell updates.
TugoukezhangCreate, inspect, and edit Excel workbooks and XLSX files.
bytedanceAnalyzes Excel and CSV files with DuckDB SQL queries and exports results to CSV, JSON, or Markdown.
mattmacleod16-svgAutomate spreadsheet creation, editing, analysis, and formatting with openpyxl and pandas.
open-nekoCreate, edit, and analyze Excel files with openpyxl and LibreOffice.
