skills.rest
boshi-xixixi
boshi-xixixiCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create and edit .xlsx, .xlsm, .csv, and .tsv spreadsheets with formulas and pandas.

6|1|Updated Jan 23, 2026
Search Tags:#data analysis#pandas#openpyxl#formulas#spreadsheet#excel#libreoffice
One-click install
npx skills add https://github.com/boshi-xixixi/agenticflow-skills --skill xlsx-boshi-xixixi
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/boshi-xixixi/agenticflow-skills/tree/main/skills/06_Office_Excel
Command: npx skills add https://github.com/boshi-xixixi/agenticflow-skills --skill xlsx-boshi-xixixi

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 spreadsheet data, ensuring accuracy and dynamic updates through robust formula management and data handling.

Core Features & Use Cases

  • Dynamic Spreadsheet Creation: Generate new .xlsx files with intricate formulas, custom formatting, and data validation.
  • Data Analysis & Manipulation: Read, analyze, and modify existing spreadsheets using powerful libraries like pandas.
  • Formula Recalculation & Error Checking: Ensures all formulas are error-free and up-to-date using LibreOffice integration.
  • Use Case: Automatically generate a monthly sales report by pulling data from multiple sources, applying financial formulas, and formatting it according to industry standards, then verifying all calculations for accuracy.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Month', 'Revenue', and 'Growth Rate', and add a formula to calculate the growth rate in the 'Growth Rate' column.

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

You can create an Excel spreadsheet with formulas and custom formatting by generating new .xlsx files using openpyxl to implement intricate formulas, data validation, and dynamic layout updates.

How do I recalculate formulas and check for errors in an existing .xlsx file?▼

You recalculate formulas and check for errors in an existing .xlsx file by leveraging LibreOffice integration, which processes the spreadsheet to ensure all formulas are error-free and up-to-date.

Can I use pandas to analyze and modify data within .xlsm or .csv files?▼

Yes, you can use pandas to analyze and modify data within .xlsm, .csv, and .tsv files, reading existing spreadsheet data and manipulating it for comprehensive data reporting and analysis.

Does this approach support financial modeling and automated sales report generation?▼

Yes, this approach supports financial modeling and automated sales report generation by pulling data from multiple sources, applying financial formulas, and verifying calculations for accuracy.

What is the best way to edit .tsv files while preserving formula calculations?▼

The best way to edit .tsv files while preserving formula calculations is to use a workflow that reads and modifies data with pandas, then applies LibreOffice recalculation to verify formula accuracy.

Why do spreadsheet formulas show errors after automated data updates?▼

Spreadsheet formulas show errors after automated data updates when calculations are not dynamically refreshed, requiring LibreOffice integration to recalculate formulas and detect any errors in the updated .xlsx file.

Related Skills

Explore More Finance & Accounting Skills→
cuozgcuozg
4

spreadsheet

Automate spreadsheet creation, editing, analysis, and formatting in .xlsx, .csv, and .tsv.

Community
Intermediate
imvladikonimvladikon
3

xlsx

Automate Excel workbook editing with formulas via openpyxl and pandas.

Community
Intermediate
pchemguypchemguy

spreadsheet

Automate spreadsheet creation, editing, and analysis with openpyxl and pandas.

Community
Intermediate
wachawowachawo

xlsx

Creates, edits, and verifies Excel spreadsheets with pandas and openpyxl.

Community
Advanced