xlsx

Name: xlsx
Availability: InStock
Author: vinayakg

Create and edit Excel files with formulas, formatting, and pandas analysis.

Updated Jan 26, 2026

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

Ready to run

npx skills add https://github.com/vinayakg/claude-dotfiles --skill xlsx-vinayakg

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/vinayakg/claude-dotfiles/tree/main/skills/xlsx
Command: npx skills add https://github.com/vinayakg/claude-dotfiles --skill xlsx-vinayakg

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, handling complex formulas, formatting, and data manipulation efficiently.

Core Features & Use Cases

Spreadsheet Creation: Generate new .xlsx files with data, formulas, and custom formatting.
Data Analysis: Read, analyze, and visualize data from existing spreadsheets using pandas.
Formula Management: Ensure formula integrity, recalculate values, and identify errors using LibreOffice.
Use Case: Automatically generate a financial projection model in Excel, including complex formulas and industry-standard formatting, based on provided assumptions.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue'.

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 file with formulas and custom formatting?▼

To create an Excel file with formulas and custom formatting, you can generate new `.xlsx` files programmatically. This approach supports writing data, inserting complex formulas, and applying industry-standard formatting directly to the spreadsheet.

Can I use pandas to analyze data from existing Excel spreadsheets?▼

Yes, you can use pandas to read, analyze, and visualize data from existing `.xlsx`, `.xlsm`, `.csv`, and `.tsv` spreadsheets. This allows for efficient data manipulation and reporting directly from your stored files.

How do I recalculate formulas in an Excel file without opening Excel?▼

To recalculate formulas in an Excel file without opening the application, you can use a dedicated script that leverages LibreOffice. This ensures formula integrity, recalculates values, and identifies errors automatically.

What is the best way to automate financial modeling in Excel?▼

The best way to automate financial modeling in Excel is to dynamically generate spreadsheets based on provided assumptions. You can automatically create projection models that include complex formulas and custom formatting.

Does openpyxl support editing .xlsm files with complex formulas?▼

Yes, openpyxl supports editing `.xlsm` files and managing complex formulas. It enables comprehensive spreadsheet management by allowing you to edit existing files while maintaining formula integrity and data structures.