Create, edit, and analyze Excel spreadsheet files with formulas and pandas.
npx skills add https://github.com/5kahoisaac/opencode-configs --skill xlsx-5kahoisaac
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/5kahoisaac/opencode-configs/tree/main/skills/xlsx Command: npx skills add https://github.com/5kahoisaac/opencode-configs --skill xlsx-5kahoisaac
This Skill automates the creation, editing, and analysis of spreadsheet files, handling complex formulas, formatting, and data manipulation tasks efficiently.
.xlsx files or modify existing ones with data, formulas, and custom formatting.Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and populate it with the provided sales data.
High-intent search queries and answers about installing and using this skill.
Automate Excel report generation by creating or modifying .xlsx files with custom formulas and formatting programmatically. This approach uses pandas for data manipulation and LibreOffice to recalculate formulas, ensuring zero formula errors and preserving existing templates.
Yes, you can use pandas to conduct in-depth data analysis and export the results directly to an .xlsx spreadsheet. The processed data integrates seamlessly into Excel files while maintaining proper formatting and supporting complex formula creation.
LibreOffice integration supports recalculating complex formulas in existing Excel templates to ensure accuracy. By processing the .xlsx or .xlsm files through LibreOffice, the system validates formula logic and guarantees zero calculation errors while preserving your original template structure.
The best way to edit existing .xlsx files without breaking formulas is to use a tool that leverages openpyxl for structural modifications and LibreOffice for formula recalculation. This combination preserves existing templates, applies new formatting, and ensures all formulas remain error-free.
Supported file formats for automated spreadsheet data analysis include .xlsx, .xlsm, .csv, and .tsv. These formats are fully compatible with pandas for data manipulation, allowing you to seamlessly create, edit, and analyze tabular datasets.
Spreadsheet formulas often return errors when generated programmatically due to missing recalculation steps. Utilizing LibreOffice to recalculate formulas after editing .xlsx files ensures all calculations are executed correctly, eliminating formula errors and validating your data outputs.
ChenYCLCreate, read, edit, and analyze Excel spreadsheet files with openpyxl and pandas.
novoleiClean and transform CSV, TSV, and XLSX data into formatted XLSX workbooks.
garethdaineCreate, edit, and analyze .xlsx, .csv, and .tsv spreadsheet files.
refly-aiManage Google Sheets data, formatting, and charts via the API.