xlsx

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

14|3|Updated Jan 17, 2026
One-click install
npx skills add https://github.com/kofttlcc/quant-test --skill xlsx-kofttlcc
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/kofttlcc/quant-test/tree/main/.agent/skills/xlsx
Command: npx skills add https://github.com/kofttlcc/quant-test --skill xlsx-kofttlcc

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill 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 everything from simple data entry to complex formula calculations and visualizations.

Core Features & Use Cases

  • Data Manipulation: Read, write, and modify data in various spreadsheet formats (.xlsx, .csv, .tsv).
  • Formula Management: Create, preserve, and recalculate complex Excel formulas.
  • Data Analysis & Visualization: Perform data analysis and generate visualizations directly within spreadsheets.
  • Use Case: Automatically generate a monthly sales report by reading raw sales data, applying formulas for growth calculations, and formatting the output into a professional-looking Excel file.

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 an xlsx spreadsheet and populate it with raw data?

To create an xlsx spreadsheet, you can define columns like 'Date' and 'Revenue', then populate the file with your raw data. This enables comprehensive creation and editing of spreadsheet files for tasks like automated monthly sales reports.

Can I modify an existing xlsx file while preserving complex Excel formulas?

Yes, you can modify existing xlsx files while preserving complex Excel formulas. The skill handles formula management by maintaining existing calculations and performing formula recalculation using LibreOffice.

Does this tool support data analysis and visualization for csv and tsv formats?

Yes, data analysis and visualization are supported for csv and tsv formats. You can perform data analysis directly within spreadsheets, handling .xlsx, .xlsm, .csv, and .tsv files to generate visual outputs.

What is the best way to recalculate spreadsheet formulas without opening Excel?

The best way to recalculate spreadsheet formulas without Excel is using LibreOffice. The skill performs formula recalculation directly on spreadsheet files, ensuring your calculated values are updated accurately.

How do I handle data manipulation for reporting across different spreadsheet formats?

You can handle data manipulation for reporting by reading, writing, and modifying data across various spreadsheet formats including .xlsx, .csv, and .tsv. This supports efficient data entry and complex formula calculations.

Are there limitations when using xlsm files for formula recalculation?

Formula recalculation for xlsm files is handled using LibreOffice. While it supports reading and modifying these formats, complex macro execution may have limitations depending on the specific LibreOffice implementation.