xlsx

Create, edit, and analyze Excel spreadsheet files with formulas and pandas.

3|Updated Jan 24, 2026
One-click install
npx skills add https://github.com/JS-mark/super-client-r --skill xlsx-js-mark
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/JS-mark/super-client-r/tree/main/.trae/skills/xlsx
Command: npx skills add https://github.com/JS-mark/super-client-r --skill xlsx-js-mark

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 efficiently, handling complex formulas, formatting, and data manipulation tasks.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new .xlsx files or modify existing ones with data, formulas, and custom formatting.
  • Data Analysis: Read, analyze, and process data from spreadsheets using powerful libraries like pandas.
  • Formula Management: Ensure formula accuracy, prevent errors, and leverage Excel's calculation engine.
  • Use Case: Automatically generate a financial projection spreadsheet, including complex formulas and industry-standard formatting, based on provided assumptions.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and populate it with the provided sales data.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create a financial modeling spreadsheet with formulas and formatting?

To create a financial modeling spreadsheet, this tool generates .xlsx files with complex formulas, data manipulation via pandas, and industry-standard formatting. It supports macro-enabled files and enforces strict error-checking standards for accurate financial projections.

Can I analyze Excel data from .xlsx and .csv files using pandas?

Yes, you can analyze Excel data from .xlsx, .xlsm, .csv, and .tsv files using pandas. The tool reads and processes spreadsheet data directly, enabling comprehensive data analysis and manipulation without needing to manually export or convert the file formats.

Does this tool support formula recalculation for Excel files generated via openpyxl?

Yes, it supports formula recalculation for Excel files generated via openpyxl by integrating with LibreOffice. A dedicated recalc.py script triggers the calculation engine to ensure formula accuracy and update computed values automatically after data manipulation.

What is the best way to automate editing an existing .xlsx file for data analysis?

The best way to automate editing an existing .xlsx file is by using this tool to apply data manipulation with pandas while adhering to strict formatting and error-checking standards. It modifies existing spreadsheets directly, ensuring formulas and custom layouts remain intact.

Are there limitations when using spreadsheet automation for large financial projections?

When using spreadsheet automation for large financial projections, limitations may arise from openpyxl memory constraints and LibreOffice recalculation processing times. Complex formulas and heavy data manipulation tasks require strict error-checking to prevent calculation timeouts or formatting corruption.