skills.rest
Qwen-Applications
Qwen-ApplicationsOFFICIAL
Explore all skills by this author →
GitHub

xlsx

Create and edit Excel workbooks with formulas and formatting using openpyxl.

234|15|Updated Apr 27, 2026
Search Tags:#automation#openpyxl#spreadsheet#data-analysis#xlsx#formula#recalc
One-click install
npx skills add https://github.com/Qwen-Applications/Trace2Skill --skill xlsx-qwen-applications
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Qwen-Applications/Trace2Skill/tree/main/spreadsheet_agent/skills/xlsx
Command: npx skills add https://github.com/Qwen-Applications/Trace2Skill --skill xlsx-qwen-applications

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

Creating, editing, and analyzing spreadsheets while preserving formulas and templates to save time and reduce errors.

Core Features & Use Cases

  • Create new spreadsheets with formulas and formatting
  • Read and analyze data from .xlsx, .xlsm, .csv, and other spreadsheet formats
  • Modify existing spreadsheets while preserving formulas and templates
  • Recalculate formulas and visualize results within spreadsheets

Quick Start

Create a new spreadsheet named Budget.xlsx with a formatted header and a simple SUM formula that totals expenses.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate spreadsheet creation and analysis in Excel?▼

You can automate spreadsheet creation and analysis by using this Skill to generate new workbooks, apply formulas, and visualize data while preserving template formatting.

Does openpyxl preserve existing formulas when modifying an xlsx file?▼

Yes, the Skill uses openpyxl to modify existing spreadsheets while maintaining exact formula integrity, ensuring templates and calculated fields remain intact during edits.

What is the best way to recalculate formulas in an xlsx file using Python?▼

The best way to recalculate xlsx formulas is using this Skill's LibreOffice-based recalculation workflow, which processes formulas and updates cell values accurately.

Can I read and analyze data from both CSV and xlsm files?▼

Yes, you can read and analyze data across .xlsx, .xlsm, and CSV formats, extracting values and processing spreadsheet information for data analysis workflows.

Why do my spreadsheet formulas break when I edit xlsx files with Python?▼

Formulas often break during edits due to improper library usage, but this Skill prevents this by preserving formula integrity and utilizing a dedicated recalculation workflow.

Do I need LibreOffice to recalculate formulas in openpyxl spreadsheets?▼

Yes, the Skill relies on a LibreOffice-based recalculation workflow to properly evaluate and recalculate formulas within your generated or modified openpyxl spreadsheets.

Related Skills

Explore More Data & Analytics Skills→
alanharrryy-wqalanharrryy-wq
2

xlsx

Automate spreadsheet workflows to clean, format, and convert tabular data.

Community
Advanced
rafazshrafazsh

XLSX Processor

Extract and convert XLSX spreadsheet data into Markdown, CSV, or JSON.

Community
Intermediate
lawvablelawvable
630

xlsx-processing-openai

Automates spreadsheet processing using Python libraries and AI-guided prompts.

Official
Advanced
gerquinn1978gerquinn1978
5

gvm-analysis

Execute privacy-preserving exploratory data analysis on structured data files.

Community
Advanced