xlsx

Create, edit, and analyze spreadsheets while preserving formulas across .xlsx and .xlsm formats.

Updated Jan 29, 2026
One-click install
npx skills add https://github.com/TIAN0517/iosboss --skill xlsx-tian0517
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/TIAN0517/iosboss/tree/main/temp_extract/99999999/skills/xlsx
Command: npx skills add https://github.com/TIAN0517/iosboss --skill xlsx-tian0517

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill simplifies the repetitive and error-prone work of creating, editing, and analyzing spreadsheets while preserving formulas and formatting. It enables automated data workflows, consistent calculations, and quick insights from tabular data.

Core Features & Use Cases

  • Programmatic spreadsheet creation with formulas and formatting
  • Read, analyze, and summarize data across sheets
  • Modify existing workbooks while preserving formulas and structure
  • Data analysis and visualization within spreadsheets
  • Recalculate formulas automatically (via a LibreOffice-based workflow)
  • Use Case: Finance or operations teams automatically generate monthly reports by importing datasets, applying formulas, and exporting a polished workbook.

Quick Start

Create a new spreadsheet named sales_report.xlsx with a 3-column table (Month, Revenue, Growth) and a formula to compute Growth as (Revenue - Previous Revenue)/Previous Revenue, then apply basic formatting.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate editing an existing spreadsheet while preserving formulas?

Automating spreadsheet editing while preserving formulas involves modifying existing workbooks across .xlsx and .xlsm formats using openpyxl. This skill updates worksheets and automatically recalculates formulas via a LibreOffice-based workflow to ensure accurate outputs without losing existing structures.

Does openpyxl recalculate formulas automatically when modifying xlsx files?

Standard openpyxl manipulation does not automatically recalculate formulas, but this skill applies a LibreOffice-based recalculation workflow. This ensures that formulas in your .xlsx and .xlsm workbooks compute correctly and display updated values after programmatic modifications.

Can I generate a new xlsx file with formulas and formatting programmatically?

Generating a new xlsx file with formulas and formatting programmatically is fully supported. You can create spreadsheets from scratch, inject datasets, apply mathematical formulas, and format the output to produce polished workbooks for automated reporting workflows.

What is the best way to read and analyze data across multiple spreadsheet sheets?

Reading and analyzing data across multiple spreadsheet sheets is handled by reading workbooks with openpyxl to extract tabular data. The skill summarizes datasets across sheets, enabling fast data analysis and quick insights directly from your existing .xlsx files.

How do I convert CSV data into a formatted xlsx workbook with computed formulas?

Converting CSV data into a formatted xlsx workbook involves importing tabular data into a new spreadsheet and applying formulas programmatically. The skill creates the workbook, inserts the data, computes formulas via LibreOffice, and applies formatting for a polished result.