Create, edit, and analyze Excel files with formulas and pandas.
npx skills add https://github.com/vinhnx/VTCode --skill xlsx-vinhnx
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/vinhnx/VTCode/tree/main/.agents/skills/xlsx Command: npx skills add https://github.com/vinhnx/VTCode --skill xlsx-vinhnx
This Skill streamlines the creation, editing, and analysis of spreadsheet files, handling everything from basic data entry to complex formula management and visualization.
.xlsx files or modify existing ones with data, formulas, and formatting.Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns 'Date', 'Product', and 'Revenue', and add a formula to calculate the total revenue in cell D1.
High-intent search queries and answers about installing and using this skill.
You can create and edit Excel files by generating new .xlsx workbooks or modifying existing ones, applying data, formulas, and standard formatting to build financial models and reports.
Yes, you can leverage pandas for in-depth data analysis and visualization directly from spreadsheet data, processing .xlsx, .xlsm, .csv, and .tsv files for analytical insights.
You can recalculate formulas in Excel files automatically using LibreOffice via a recalculation script, ensuring formula accuracy and preserving existing templates without manual intervention.
The best way to build a financial projection spreadsheet is to generate the file, populate it with assumptions, apply industry-standard color coding and number formatting, and verify formula accuracy.
Yes, LibreOffice is required as a dependency to execute formula recalculation via the recalculation script, ensuring all formulas within your .xlsx or .xlsm files are computed accurately.
Spreadsheet formulas may not update because the file was edited programmatically without triggering a recalculation; running the recalculation script via LibreOffice resolves this by computing the formulas.
cbbkrd-techCreate, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.
MooseGoose0701Create, edit, analyze, and visualize .xlsx, .csv, and .tsv files with Python.
XinyuYao98Create, edit, validate, and recalculate Excel workbooks with pandas and openpyxl.
ronniwheellike973Manage and analyze .xlsx files with pandas, openpyxl, and formula recalculation.