Create and edit .xlsx spreadsheets with formulas and formatting.
npx skills add https://github.com/opensesh/BOS-2.0 --skill xlsx-opensesh
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/opensesh/BOS-2.0/tree/main/.claude/skills/public/xlsx Command: npx skills add https://github.com/opensesh/BOS-2.0 --skill xlsx-opensesh
This Skill empowers users to create, edit, and analyze spreadsheet data with advanced features, ensuring accuracy and efficiency in financial modeling and data management.
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 Skill utilizes openpyxl to build new .xlsx files, populate them with financial formulas, and apply industry-standard color-coding and number formatting for accurate financial modeling.
Yes, you can modify an existing .xlsx file without breaking formulas, as this Skill preserves the original structure and calculations while allowing you to update data, apply new formatting, and perform data analysis using pandas.
Yes, this approach supports data analysis and visualization for CSV files, as it relies on pandas to read, analyze, and identify trends in .csv, .tsv, and .xlsx formats, enabling comprehensive spreadsheet data management.
The best way to recalculate formulas in an edited spreadsheet is by using the recalc.py script, which requires LibreOffice to execute formula recalculation and ensure all calculations remain accurate after modifications.
Yes, you need LibreOffice installed if you want to recalculate formulas, as the recalc.py script relies on it to execute formula recalculation and verify calculation accuracy in your spreadsheet files.
To analyze sales data from a CSV file and identify trends, this Skill uses pandas for data manipulation to read the .csv file, process the spreadsheet data, and perform in-depth data analysis.
cbbkrd-techCreate, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.
imvladikonAutomate Excel workbook editing with formulas via openpyxl and pandas.
vuhuudoCreate, edit, and analyze Excel spreadsheets using pandas and openpyxl.
rongxinzyCreate, modify, and analyze Excel files with pandas and openpyxl.
