xlsx
Spreadsheet toolkit (.xlsx/.csv). Create/edit with formulas/formatting, analyze data, visualization, recalculate formulas, for spreadsheet processing and analysis.
Security Assessment
About xlsx
The 'xlsx' skill is designed to facilitate the creation, editing, and analysis of Excel spreadsheets, specifically .xlsx and .csv file formats. This skill allows users to efficiently manage data, apply formulas, format content, and generate detailed financial models and reports. It ensures that Excel files are produced with accuracy and meet stringent requirements for professional financial modeling, data analysis, and documentation purposes. The skill leverages powerful Python libraries, such as openpyxl and pandas, to handle spreadsheet processing and automate formula recalculations, making it ideal for users who need robust spreadsheet solutions in their workflow.
FAQ
What types of files can be processed using this skill?
This skill supports both .xlsx and .csv file formats for creation, editing, and analysis.
Does the skill automatically generate charts or graphs?
While the skill focuses on spreadsheet processing, it can be integrated with other skills, like scientific-schematics, to create publication-quality diagrams.
What is required to ensure no formula errors?
All formulas in the spreadsheets must be free from errors like #REF!, #DIV/0!, #VALUE!, etc. Additionally, all assumptions should be placed in separate cells and referenced correctly in formulas.
Are there any specific formatting standards to follow?
Yes, there are industry-standard color and number formatting conventions, such as blue text for hardcoded inputs, black for formulas, and yellow background for key assumptions needing attention.
Can I update an existing template with this skill?
Yes, but you must exactly match the existing format, style, and conventions. Never impose standardized formatting on files with established patterns.
Install xlsx
Quick Setup:
- Copy the skill folder to
.claude/skills/ - Claude will automatically detect and use the skill
Repository
K-Dense-AI/claude-scientific-skills