skills.rest
digresik-tech
digresik-techCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

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

1|Updated Feb 14, 2026
Search Tags:#formatting#data analysis#pandas#formulas#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/digresik-tech/olt-monitoring-mini --skill xlsx-digresik-tech
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/digresik-tech/olt-monitoring-mini/tree/main/skills/xlsx
Command: npx skills add https://github.com/digresik-tech/olt-monitoring-mini --skill xlsx-digresik-tech

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers users to create, edit, and analyze spreadsheet data with advanced features like formulas, formatting, and data visualization, eliminating manual spreadsheet drudgery.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new .xlsx files or modify existing ones, including complex formulas and precise formatting.
  • Data Analysis & Visualization: Leverage pandas for data manipulation and create insightful charts directly within spreadsheets.
  • Formula Recalculation & Verification: Ensure accuracy with automated formula recalculation and error checking using LibreOffice.
  • Use Case: Automatically generate a monthly sales report .xlsx file, including dynamic sales forecasts, formatted tables, and charts, all while ensuring all formulas are error-free.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Sales', and 'Region'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate xlsx spreadsheet creation with formulas and formatting?▼

You can automate xlsx spreadsheet creation by generating new files or modifying existing ones with complex formulas, precise formatting, and data visualization using pandas and openpyxl.

Does this tool support data analysis and chart generation for csv files?▼

Yes, it supports comprehensive data analysis and chart generation for csv, tsv, xlsx, and xlsm files by leveraging pandas for data manipulation directly within your spreadsheets.

How do I verify Excel formulas and check for errors automatically?▼

Automated formula recalculation and error checking verify Excel formulas by utilizing LibreOffice to recalculate outputs, ensuring your spreadsheet calculations are accurate and error-free.

Can I use pandas to edit existing xlsm files without breaking formulas?▼

Editing existing xlsm files with pandas is supported, and mandatory formula recalculation using LibreOffice ensures that implemented formulas remain intact and function correctly after modifications.

What is the best way to generate a formatted monthly sales report in Excel?▼

The best way to generate a formatted monthly sales report in Excel is to automate the creation of dynamic forecasts, formatted tables, and charts while verifying formula accuracy with LibreOffice.

Related Skills

Explore More Data & Analytics Skills→
jeffpeckyjeffpecky

xlsx

Automate Excel workflows with pandas and openpyxl for data analysis and editing.

Community
Advanced
rangerrick337rangerrick337
10

xlsx

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

Community
Advanced
Wesley1600Wesley1600

Python Script Skill Template

Executes Python scripts that process CLI input and return JSON-formatted results.

Community
Basic
KYRIE66nbKYRIE66nb

spreadsheet

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

Community
Intermediate