skills.rest
Ced3-han
Ced3-hanCOMMUNITY
Explore all skills by this author →
Website𝕏@JiahanCedGitHub

xlsx

Automates Excel file operations and data analysis using pandas and LibreFormula.

Updated Apr 30, 2026
Search Tags:#financial modeling#data analysis#spreadsheet#excel#formula validation
One-click install
npx skills add https://github.com/Ced3-han/Harness-Settings --skill xlsx-ced3-han
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Ced3-han/Harness-Settings/tree/main/skills/xlsx
Command: npx skills add https://github.com/Ced3-han/Harness-Settings --skill xlsx-ced3-han

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of Excel files, making it easy to manage data efficiently and accurately.

Core Features & Use Cases

  • Spreadsheets Creation: Generate new spreadsheets or convert tabular data into .xlsx format.
  • Data Analysis: Perform data analysis, visualization, and basic operations using pandas.
  • Formula Validation: Ensure all formulas are correct and recalculate dynamically.
  • Formatting Standards: Apply professional formatting and color coding standards for financial models.
  • Use Case: Suppose you need to analyze sales data and create a financial model. This Skill can help you automate data entry, perform calculations, and format the output as per professional standards.

Quick Start

Use the xlsx skill to open the file 'sales-data.xlsx' and calculate the average of the 'Sales' column.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel file operations and data analysis for financial modeling?▼

Automate Excel file operations and data analysis by using this Skill to handle .xlsx, .xlsm, .csv, and .tsv files. It leverages pandas for data manipulation and LibreOffice for dynamic formula recalculation, streamlining financial modeling workflows.

Can I validate and recalculate formulas in an .xlsx spreadsheet dynamically?▼

Yes, you can validate and recalculate formulas in an .xlsx spreadsheet dynamically. The Skill utilizes LibreOffice specifically to ensure all formulas are correct and recalculated accurately during data analysis and financial modeling tasks.

Does this Excel automation Skill support .csv and .tsv file formats?▼

Yes, this Excel automation Skill fully supports .csv and .tsv file formats alongside .xlsx and .xlsm. It utilizes pandas and openpyxl to handle these various tabular data formats for efficient creation, editing, and analysis.

What's the best way to apply professional formatting standards to financial models in Excel?▼

The best way to apply professional formatting standards to financial models is using this Skill. It automates professional formatting and color coding standards while performing data analysis and calculations within your spreadsheets.

Do I need pandas and openpyxl to create and edit spreadsheets with this tool?▼

Yes, you need pandas and openpyxl installed to create and edit spreadsheets with this tool. These dependencies are required for data manipulation and handling various Excel file types during your data analysis workflows.

Why are my Excel formulas not recalculating when I edit the spreadsheet data?▼

Excel formulas may not recalculate if LibreOffice is not properly configured. This Skill requires LibreOffice for formula recalculation, ensuring that all formulas are validated and dynamically updated when you edit spreadsheet data.

Related Skills

Explore More Data & Analytics Skills→
zjy-devzjy-dev
2

xlsx

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

Community
Advanced
eesha000009-deveesha000009-dev
1

xlsx

Create and edit .xlsx spreadsheets with preserved formulas and formatting.

Community
Advanced
treasure-datatreasure-data
21

trino-cli

Execute SQL queries against Treasure Data using the Trino CLI.

Official
Intermediate
ChatAndBuildChatAndBuild
1

xlsx

Automate Excel spreadsheet creation, editing, and analysis with pandas and openpyxl.

Official
Advanced