skills.rest
IoT-VN
IoT-VNCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheets with formulas and charts.

Updated Feb 11, 2026
Search Tags:#reporting#data analysis#pandas#formulas#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/IoT-VN/tuya-energy-dashboard --skill xlsx-iot-vn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/IoT-VN/tuya-energy-dashboard/tree/main/.claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/IoT-VN/tuya-energy-dashboard --skill xlsx-iot-vn

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the creation, editing, and analysis of spreadsheet files, streamlining data manipulation and reporting tasks.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new .xlsx files or modify existing ones with data, formulas, and formatting.
  • Data Analysis & Visualization: Utilize pandas for data manipulation and analysis, and create charts for visualization.
  • Formula Recalculation & Error Checking: Ensure formula integrity and identify errors using LibreOffice integration.
  • Use Case: Automatically generate a monthly sales report by pulling data from a database, calculating growth percentages, and formatting it into a professional .xlsx file with charts.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns 'Month' and 'Sales', and populate it with data for January and February.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation and populate it with data?▼

To automate Excel spreadsheet creation, you can generate new .xlsx files and modify existing ones by adding data, formulas, and formatting programmatically. This streamlines data manipulation and reporting tasks without manual entry.

Can I use pandas for data analysis and visualization in an xlsx file?▼

Yes, you can use pandas for data analysis and visualization in an xlsx file. The process utilizes pandas for data manipulation and creates charts directly within the spreadsheet to visualize the analyzed data.

Does spreadsheet formula recalculation work with LibreOffice integration?▼

Yes, spreadsheet formula recalculation works with LibreOffice integration. It ensures formula integrity by recalculating formulas and identifying errors within your .xlsx, .csv, and .tsv files.

What is the best way to build a monthly sales report with charts from a spreadsheet?▼

The best way to build a monthly sales report is to pull data, calculate growth percentages, and format it into a professional .xlsx file. This process automatically generates charts to visualize the report data.

Can I edit .csv and .tsv files or only .xlsx spreadsheet formats?▼

You can edit .csv and .tsv files in addition to .xlsx spreadsheet formats. The tool automates the creation, editing, and analysis of all three file types, supporting Excel formulas and data analysis across them.

Related Skills

Explore More Data & Analytics Skills→
digresik-techdigresik-tech
1

xlsx

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

Community
Advanced
EdgeHuntEdgeHunt

ck:xlsx

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheets with formulas and pivot tables.

Official
Advanced
EnztunEnztun

xlsx

Automate Excel spreadsheet operations with Python libraries like openpyxl, pandas, and matplotlib.

Community
Advanced
AIDC-AIAIDC-AI
16

xlsx

Create, edit, and analyze Excel spreadsheets with formulas and pandas.

Official
Advanced