Read, edit, and generate .xlsx, .xlsm, .csv, and .tsv spreadsheets with pandas and openpyxl.
npx skills add https://github.com/SALDAPAL/microclaw --skill xlsx-saldapal
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/SALDAPAL/microclaw/tree/main/skills/built-in/xlsx Command: npx skills add https://github.com/SALDAPAL/microclaw --skill xlsx-saldapal
This skill automates the end-to-end handling of spreadsheet data, allowing you to open, read, edit, and generate .xlsx, .xlsm, .csv, and .tsv files with consistent formatting and reliable results.
Provide the source spreadsheet path and desired formatting rules to produce a cleaned, ready-to-use workbook.
High-intent search queries and answers about installing and using this skill.
Automate spreadsheet data cleaning by providing the source file path and formatting rules to normalize columns, apply business logic, and export a ready-to-use .xlsx workbook. The process leverages pandas and openpyxl to read, edit, and generate files with consistent formatting.
Preserve Excel formulas during CSV to xlsx conversion by maintaining formula compatibility through openpyxl. The workflow requires LibreOffice for formula recalculation via a provided recalc script to ensure error-free, reproducible results across the generated workbooks.
Spreadsheet automation works with .xlsx, .xlsm, .csv, and .tsv formats. You can read, edit, and generate files across these formats while applying clean-up rules, managing formulas, and maintaining consistent formatting for business reports and data pipelines.
The best way to normalize columns in a customer data spreadsheet is applying automated clean-up rules to the source file. The process normalizes columns, applies business rules, and exports the cleaned data to .xlsx for reporting.
You need LibreOffice to recalculate formulas in generated xlsx workbooks. The skill leverages a provided recalc script that uses LibreOffice to ensure formulas are recalculated accurately, producing error-free and reproducible spreadsheet results.
Excel formulas may not calculate after automated data processing if the recalc script is skipped. Running the provided LibreOffice recalculation step ensures all formulas in the generated .xlsx or .xlsm workbooks are evaluated correctly for reproducible results.
liujiayi3703Create and edit Excel files with openpyxl and pandas.
wuyyyyyouExport a Google Sheets spreadsheet to a CSV file for local backup.
yangqiongGenerate HTML data reports from pandas DataFrames with summaries and analyses.
KaranKathur06Build scheduled ETL workflows that extract, transform, and load data into analytics destinations.
