Create, edit, and analyze .xlsx, .xlsm, and .csv files with pandas and LibreOffice.
npx skills add https://github.com/northseadl/skillwisp --skill xlsx-northseadl
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/northseadl/skillwisp/tree/main/skills/%40anthropic/xlsx Command: npx skills add https://github.com/northseadl/skillwisp --skill xlsx-northseadl
This Skill empowers you to create, edit, and analyze complex spreadsheet files, handling everything from data manipulation and formula creation to advanced financial modeling and visualization.
Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add a formula to calculate the total revenue.
High-intent search queries and answers about installing and using this skill.
Yes, you can edit existing spreadsheets while meticulously maintaining their original formatting and conventions. This Skill supports modifying .xlsx and .xlsm files, handling data manipulation via pandas without disrupting established templates or layout structures.
Pandas and openpyxl can be used together for Excel data analysis to manipulate datasets and preserve file formatting. This Skill leverages pandas for in-depth data manipulation and openpyxl for managing spreadsheet structures, ensuring comprehensive analysis alongside strict formatting adherence.
LibreOffice integration works for recalculating Excel formulas by processing generated formulas to verify accuracy. This Skill uses LibreOffice integration specifically for formula recalculation, ensuring that complex projections and dynamic formula calculations yield correct results within your spreadsheets.
The best way to automate financial modeling and report generation in Excel is by pulling data from multiple sources and applying complex formulas for projections. This Skill facilitates advanced financial modeling, dynamic formula creation, and data visualization to automatically generate formatted reports.
A limitation of using openpyxl for spreadsheet management is potential formula recalculation errors, which is why this Skill integrates LibreOffice to recalculate formulas. It handles .xlsx, .xlsm, and .csv files but requires strict formatting and error-checking standards to prevent data corruption.
mattmacleod16-svgAutomate spreadsheet creation, editing, analysis, and formatting with openpyxl and pandas.
doubleG7Parse cash flow forecast reports and create charts with Python.
pchemguyAutomate spreadsheet creation, editing, and analysis with openpyxl and pandas.
hgxszhj-pixelOpen, create, edit, analyze, and validate Excel files with Python.
