skills.rest
malhashemi
malhashemiCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/malhashemi/dotfiles --skill documents-xlsx
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Finance & Accounting Skills→
Jaydpatel01Jaydpatel01

xlsx

Create, edit, and analyze spreadsheet files in .xlsx, .xlsm, .csv, and .tsv formats.

Community
Advanced
Ab0umarAb0umar

Spreadsheets

Create and modify multi-sheet .xlsx workbooks with formulas and charts.

Community
Intermediate
locdinh209locdinh209

xlsx

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

Community
Advanced
zjy-devzjy-dev
2

xlsx

Create, edit, and analyze Excel files with pandas and openpyxl.

Community
Advanced