skills.rest
kunhai-88
kunhai-88COMMUNITY
Explore all skills by this author →
Website𝕏@KunhaiYGitHub

xlsx

Create, edit, and analyze spreadsheet files with formulas and charts.

Updated Jan 25, 2026
Search Tags:#reporting#data analysis#formulas#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/kunhai-88/skills --skill xlsx-kunhai-88
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/kunhai-88/skills/tree/main/xlsx
Command: npx skills add https://github.com/kunhai-88/skills --skill xlsx-kunhai-88

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet files, including support for formulas, formatting, data analysis, and chart generation.

Core Features & Use Cases

  • File Handling: Supports .xlsx, .xlsm, .csv, and .tsv formats.
  • Formula Support: Enables the use of Excel formulas for calculations and data manipulation.
  • Data Analysis & Visualization: Facilitates data analysis and the creation of charts within spreadsheets.
  • Formula Recalculation: Can recalculate formulas, potentially requiring LibreOffice.
  • Use Case: Generate a financial model with specific formatting and color-coding, or analyze sales data from a CSV file and create a summary report with charts.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' and add a column for 'Total Sales' with a formula to sum the values from another 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 charts from a CSV file?▼

To create an Excel spreadsheet with formulas and charts, this Skill processes CSV data using pandas and openpyxl to generate formatted .xlsx files with calculated columns and visualizations.

What file formats are supported for spreadsheet data analysis and editing?▼

Supported file formats for spreadsheet data analysis and editing include .xlsx, .xlsm, .csv, and .tsv, allowing you to read, write, and manipulate various tabular data structures.

Can I recalculate Excel formulas in generated .xlsx files without opening Excel?▼

You can recalculate Excel formulas in generated .xlsx files without opening Excel by utilizing LibreOffice, which handles the formula recalculation process for updated values.

Does openpyxl support creating financial models with specific formatting and color-coding?▼

Openpyxl supports creating financial models with specific formatting and color-coding by enabling programmatic styling, cell formatting, and formula injection directly within .xlsx files.

What is the best way to analyze sales data and generate a summary report with charts?▼

The best way to analyze sales data and generate a summary report with charts is to load the dataset into pandas, perform aggregations, and output a formatted spreadsheet with visualizations.

Do I need to install LibreOffice to use this Skill for spreadsheet creation?▼

You do not need to install LibreOffice for basic spreadsheet creation, editing, and formatting; however, it is required if you need to recalculate formulas outside of native Excel environments.

Related Skills

Explore More Finance & Accounting Skills→
mattmacleod16-svgmattmacleod16-svg
1

spreadsheet

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

Community
Intermediate
rangerrick337rangerrick337
10

xlsx

Automate Excel spreadsheet creation, editing, and analysis with formula integrity across .xlsx, .xlsm, .csv, and .tsv.

Community
Advanced
20YN0420YN04

tushare

Retrieve financial market data into pandas DataFrames via a standardized API.

Community
Intermediate
BishopCodesBishopCodes
1

Xlsx

Create and edit Excel workbooks with formulas and data analysis.

Community
Advanced