Create, edit, and analyze Excel spreadsheets with formulas and formatting.
npx skills add https://github.com/bloknayrb/claudestuff --skill xlsx-bloknayrb
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/bloknayrb/claudestuff/tree/main/plugins/ms-office-suite/skills/xlsx Command: npx skills add https://github.com/bloknayrb/claudestuff --skill xlsx-bloknayrb
This Skill empowers users to create, edit, and analyze complex spreadsheet files, ensuring data integrity and dynamic calculations.
.xlsx files with intricate formulas, custom formatting, and data validation.Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add a formula in the 'Revenue' column to sum the values.
High-intent search queries and answers about installing and using this skill.
To create an Excel spreadsheet with formulas and formatting, this tool uses openpyxl to generate new .xlsx files with custom data validation and dynamic calculations. It automates building intricate financial models while ensuring formula accuracy and applying industry-standard formatting.
Yes, you can modify existing Excel files without losing formulas. This tool reads and edits .xlsx or .xlsm files while preserving the original formulas, allowing you to update spreadsheet data and formatting without breaking the existing dynamic calculations.
Spreadsheet data analysis with pandas involves reading .xlsx, .csv, or .tsv files into dataframes for processing. This tool leverages pandas to manipulate and analyze the extracted data, enabling you to perform complex data analysis and visualization directly from existing spreadsheets.
Yes, LibreOffice is required to recalculate formulas in Excel files. This tool uses a recalc.py script to integrate LibreOffice for formula recalculation and error checking, ensuring that all spreadsheet calculations are accurate and error-free after modifications.
The best way to analyze CSV and TSV files for financial reporting is using pandas for data manipulation. This tool reads delimited text files, processes the data, and can export the analyzed results into a formatted Excel spreadsheet with recalculated formulas.
Excel formulas may not calculate after editing with openpyxl because it does not natively evaluate formula results. This tool resolves this limitation by invoking LibreOffice via recalc.py to recalculate formulas and perform error checking on the modified spreadsheet.
ronniwheellike973Manage and analyze .xlsx files with pandas, openpyxl, and formula recalculation.
rangerrick337Automate Excel spreadsheet creation, editing, and analysis with formula integrity across .xlsx, .xlsm, .csv, and .tsv.
alongor666Develop Vue 3 components with Pinia stores and ECharts charts.
Jaydpatel01Create, edit, and analyze spreadsheet files in .xlsx, .xlsm, .csv, and .tsv formats.