xlsx

Create, edit, and analyze XLSX and CSV spreadsheets with pandas and LibreOffice.

Updated Aug 23, 2026

Search Tags:#financial modeling #data analysis #formulas #spreadsheet #excel #xlsx #csv

Ready to run

npx skills add https://github.com/Zehong-Wang/Kosmos --skill xlsx-zehong-wang

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Zehong-Wang/Kosmos/tree/main/kosmos-reference/kosmos-claude-scientific-writer/.claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/Zehong-Wang/Kosmos --skill xlsx-zehong-wang

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, libreoffice, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet files (.xlsx, .csv), ensuring data integrity and professional formatting.

Core Features & Use Cases

Create/Edit Spreadsheets: Generate new Excel files or modify existing ones with formulas and formatting.
Data Analysis: Utilize pandas for powerful data manipulation and insights.
Formula Recalculation & Validation: Ensure all formulas are error-free using LibreOffice.
Use Case: Automatically generate a financial projection model in Excel, including complex formulas and industry-standard formatting, then validate all calculations to prevent errors.

Quick Start

Use the xlsx skill to create a new Excel file named 'financial_model.xlsx' with sales projections and a growth rate formula.

Frequently Asked Questions about xlsx

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I create an Excel financial model with formulas and ensure the calculations are correct?▼

To create an Excel financial model with formulas, you generate a new .xlsx file, apply formulas, and use LibreOffice validation to recalculate and check for errors. This ensures deterministic outputs and professional formatting.

Can I use pandas for data analysis on an existing CSV file and export the results to XLSX?▼

Yes, you can utilize pandas for data analysis and manipulation on an existing CSV file, then export the transformed data to a new XLSX file. The process supports advanced formatting and robust error checking.

Does openpyxl support advanced formatting and formula recalculation for spreadsheet editing?▼

openpyxl supports advanced formatting and formula creation during spreadsheet editing. For formula recalculation and validation, the process relies on LibreOffice to ensure deterministic outputs.

What is the best way to automate spreadsheet generation and prevent formula errors in Excel?▼

The best way to automate spreadsheet generation and prevent formula errors is to programmatically create the Excel file with formulas, then validate all calculations using LibreOffice. This ensures data integrity and professional formatting.

Why does my spreadsheet formula return an error after editing an XLSX file with openpyxl?▼

Your spreadsheet formula may return an error because openpyxl writes formulas but does not recalculate them. To prevent this, LibreOffice is used as a validation step to recalculate formulas and ensure deterministic outputs.

When do I need LibreOffice for XLSX spreadsheet operations and data manipulation?▼

You need LibreOffice for XLSX spreadsheet operations when validating complex formulas and recalculating values to prevent errors. While pandas handles data manipulation, LibreOffice ensures deterministic outputs.