skills.rest
take566
take566COMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create and edit Excel spreadsheets with pandas, openpyxl, and LibreOffice formula recalculation.

Updated Dec 23, 2025
Search Tags:#data analysis#finance#pandas#openpyxl#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/take566/skills --skill xlsx-take566
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/take566/skills/tree/main/document-processing/xlsx
Command: npx skills add https://github.com/take566/skills --skill xlsx-take566

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers users to create, edit, and analyze complex Excel spreadsheets, ensuring data accuracy and dynamic calculations without manual errors.

Core Features & Use Cases

  • Formula Creation & Management: Generate and maintain accurate Excel formulas for calculations, ensuring data integrity.
  • Data Analysis & Visualization: Leverage pandas for in-depth data analysis and prepare data for charting.
  • Use Case: Automatically generate a financial projection spreadsheet with dynamic formulas for revenue, costs, and profit, based on user-provided assumptions.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add a formula in the 'Revenue' column to sum the values.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel formula creation and recalculation in Python?▼

Automate Excel formula creation and recalculation in Python by generating formulas with openpyxl and triggering automated recalculation via LibreOffice to ensure calculation accuracy and data integrity.

How do I analyze spreadsheet data with pandas and export the results to xlsx?▼

Analyze spreadsheet data with pandas by loading your file, manipulating and transforming the dataframes in memory, then exporting the final analysis results back into a formatted xlsx file.

Does LibreOffice work with openpyxl for dynamic financial modeling in Excel?▼

LibreOffice works with openpyxl for dynamic financial modeling by using openpyxl to write formulas and LibreOffice to run automated recalculation, verifying formula accuracy across .xlsx and .xlsm formats.

Can I generate a financial projection spreadsheet with dynamic formulas automatically?▼

Generate a financial projection spreadsheet with dynamic formulas automatically by defining assumptions for revenue and costs, creating calculation logic, and outputting a verified .xlsx file with robust error checking.

What is the best way to transform CSV or TSV files into formatted Excel reports?▼

Transform CSV or TSV files into formatted Excel reports by reading the raw data with pandas, applying data transformation logic, and writing the structured output with formatting standards to an .xlsx file.

Why do my Excel formulas show stale values when I generate spreadsheets with openpyxl?▼

Excel formulas show stale values when generated with openpyxl because it writes formulas without calculating them, requiring an automated recalculation step via LibreOffice to verify and update formula accuracy.

Related Skills

Explore More Finance & Accounting Skills→
cas-bigdatalabcas-bigdatalab
541

missing_value_remover

Remove rows or columns with missing values from CSV, TSV, Excel, JSON, and JSONL files.

Official
Basic
tamnguyentommy-rgbtamnguyentommy-rgb
2

excel-generator

Generate and format Excel workbooks with formulas, charts, and data validation.

Community
Advanced
MooseGoose0701MooseGoose0701
1.1k

spreadsheet

Create, edit, analyze, and visualize .xlsx, .csv, and .tsv files with Python.

Community
Intermediate
vinayakgvinayakg

xlsx

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

Community
Advanced