documents-xlsx

Create, edit, and analyze Excel spreadsheets with formulas and pandas.

20|Updated Oct 13, 2025

Search Tags:#data analysis #pandas #openpyxl #formulas #spreadsheet #excel #xlsx

Ready to run

npx skills add https://github.com/malhashemi/dotfiles --skill documents-xlsx

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: documents-xlsx
Source: https://github.com/malhashemi/dotfiles/tree/main/dot_config/opencode/skill/document-skills/xlsx
Command: npx skills add https://github.com/malhashemi/dotfiles --skill documents-xlsx

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, modification, and analysis of spreadsheet files, ensuring data integrity and accurate calculations.

Core Features & Use Cases

Formula Management: Create, edit, and recalculate complex Excel formulas, ensuring zero errors.
Data Analysis & Visualization: Utilize pandas for in-depth data analysis and prepare data for visualization.
Cross-Platform Compatibility: Works seamlessly on macOS and Linux.
Use Case: Automatically generate a financial projection spreadsheet with accurate formulas and formatting, or analyze sales data from a CSV file and identify key trends.

Quick Start

Use the documents-xlsx skill to create a new Excel file named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add a formula to calculate the total revenue.

Frequently Asked Questions about documents-xlsx

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

FAQPage Schema

How do I recalculate Excel formulas in an xlsx file using Python?▼

To recalculate Excel formulas, this Skill uses LibreOffice via a recalc.py script to ensure zero formula errors and accurately compute formula values in your xlsx files. It processes spreadsheet modifications while preserving existing templates.

Can I analyze CSV data with pandas and save the results to an Excel spreadsheet?▼

Yes, you can analyze CSV data using pandas and save the results to an Excel spreadsheet. This Skill supports creating, editing, and analyzing .xlsx, .xlsm, .csv, and .tsv files while maintaining data integrity and applying necessary formatting.

Does this spreadsheet management Skill work on macOS and Linux?▼

Yes, this spreadsheet management Skill works seamlessly on macOS and Linux. It requires LibreOffice as a dependency to perform formula recalculation, ensuring accurate calculations and cross-platform compatibility for your Excel files.

What is the best way to generate a financial projection spreadsheet with formulas?▼

The best way to generate a financial projection spreadsheet is using this Skill to create an Excel file with accurate formulas and formatting. It ensures zero formula errors and preserves existing templates during modifications via openpyxl and pandas.

How do I edit an existing xlsx template without breaking its formatting?▼

To edit an existing xlsx template without breaking formatting, this Skill modifies spreadsheets while preserving the original template structure. It utilizes openpyxl to maintain formatting integrity and LibreOffice for recalculation to prevent formula errors.

Why does my spreadsheet formula return an error after editing?▼

Your spreadsheet formula may return an error after editing due to uncalculated values. This Skill prevents formula errors by utilizing LibreOffice via recalc.py to force formula recalculation, ensuring zero formula errors and accurate data output.