xlsx

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

Updated Jan 23, 2026
One-click install
npx skills add https://github.com/nirukk52/visual-truth-engine --skill xlsx-nirukk52
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/nirukk52/visual-truth-engine/tree/main/.claude-skills/xlsx
Command: npx skills add https://github.com/nirukk52/visual-truth-engine --skill xlsx-nirukk52

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, ensuring accuracy and dynamic calculations without manual errors.

Core Features & Use Cases

  • Formula Creation & Management: Build and maintain complex Excel formulas, ensuring zero errors.
  • Data Analysis & Visualization: Leverage pandas for in-depth data analysis and insights.
  • Formatting & Styling: Apply industry-standard formatting for clarity and professionalism.
  • Use Case: Automatically generate a financial projection model in Excel, complete with accurate formulas, standard color-coding, and number 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 add a formula to calculate the total revenue.

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 ensure the calculations are accurate?

You can create Excel spreadsheets with formulas that are automatically recalculated using LibreOffice to detect errors and ensure calculation accuracy. This approach guarantees dynamic calculations without manual errors.

Can I use pandas for data analysis on my .xlsx and .csv files?

Yes, you can leverage pandas for in-depth data analysis on your .xlsx, .xlsm, .csv, and .tsv files. This allows you to process spreadsheet data directly to generate insights and visualizations.

What is the best way to apply industry-standard formatting to a financial projection model?

The best way to apply industry-standard formatting to a financial projection model is to use automated spreadsheet styling features that apply professional color-coding and number formatting based on your provided assumptions.

Does this spreadsheet tool support editing .xlsm files or only standard .xlsx formats?

This spreadsheet tool supports editing both standard .xlsx files and .xlsm files, as well as .csv and .tsv formats, allowing you to manage complex spreadsheets with macros across different file types.

Why do my Excel formulas show errors after I edit the file programmatically?

Excel formulas may show errors after programmatic edits if they are not recalculated. You must run mandatory formula recalculation using LibreOffice to ensure accuracy and detect any errors in the updated spreadsheet.