xlsx

Manages Excel files with formulas, pandas data analysis, and verification.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/ferazfhansurie/adletic-content --skill xlsx-ferazfhansurie
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/ferazfhansurie/adletic-content/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/ferazfhansurie/adletic-content --skill xlsx-ferazfhansurie

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers users to create, edit, analyze, and manage spreadsheet files (.xlsx, .xlsm, .csv, .tsv) efficiently, handling complex formulas, formatting, and data analysis tasks.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new spreadsheets or modify existing ones, including adding data, formulas, and formatting.
  • Data Analysis & Visualization: Utilize pandas for in-depth data analysis and prepare data for visualization.
  • Formula Recalculation & Verification: Ensure all formulas are error-free and correctly calculated using a dedicated script.
  • Use Case: Automatically generate a financial projection spreadsheet with complex formulas, apply industry-standard formatting, and verify all calculations are accurate before delivery.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add a formula to sum the 'Revenue' 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 file with formulas and formatting using pandas?

To create an Excel file with formulas and formatting using pandas, you can generate spreadsheets, manipulate data, and apply industry-standard formatting. This ensures data integrity and adherence to formatting standards while adding complex formulas.

What is the best way to verify and recalculate spreadsheet formulas in an xlsx file?

The best way to verify and recalculate spreadsheet formulas in an xlsx file is by using a dedicated script. This ensures all formulas are error-free, correctly calculated, and maintain data integrity before delivery.

Can I use openpyxl to edit existing Excel spreadsheets and add complex calculations?

Yes, you can use openpyxl to edit existing Excel spreadsheets and add complex calculations. The skill manages spreadsheet operations including modifying existing files, implementing formulas, and ensuring deterministic spreadsheet tasks.

Does this approach support data analysis and visualization preparation for CSV and TSV files?

Yes, this approach supports data analysis and visualization preparation for CSV and TSV files. It utilizes pandas for in-depth data analysis and handles multiple spreadsheet formats including .xlsx, .xlsm, .csv, and .tsv.

How do I automatically generate a financial projection spreadsheet with correct calculations?

To automatically generate a financial projection spreadsheet with correct calculations, you can create spreadsheets with complex formulas, apply formatting, and verify all calculations are accurate using a dedicated recalculation script.

What are the limitations of using pandas for spreadsheet operations and data manipulation?

While pandas handles data manipulation and in-depth analysis, limitations may arise with highly complex formatting or advanced formula recalculation. A dedicated script is included to verify calculations and address deterministic spreadsheet task requirements.