xlsx

Name: xlsx
Availability: InStock
Author: bhisoftware

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv spreadsheets with formulas and pandas.

Updated Aug 27, 2026

Search Tags:#financial modeling #data analysis #pandas #openpyxl #formulas #spreadsheet #excel

Ready to run

npx skills add https://github.com/bhisoftware/page-refresh --skill xlsx-bhisoftware

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/bhisoftware/page-refresh/tree/main/library/bhi-claude-skills/spreadsheets
Command: npx skills add https://github.com/bhisoftware/page-refresh --skill xlsx-bhisoftware

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers users to create, edit, and analyze spreadsheet files (.xlsx, .xlsm, .csv, .tsv) with advanced formula management, data manipulation, and visualization capabilities, eliminating manual errors and saving significant time.

Core Features & Use Cases

Formula Creation & Management: Generate complex formulas, ensure zero formula errors, and preserve existing templates.
Data Analysis & Visualization: Utilize pandas for data manipulation, analysis, and generating insights from spreadsheet data.
Use Case: Automatically generate a financial projection model in Excel, complete with industry-standard color coding, number formatting, and dynamic formulas that can be updated with new assumptions.

Quick Start

Use the xlsx skill to create a new spreadsheet with columns for 'Product' and 'Sales', add rows of sample data, and include a formula in the 'Total Sales' column that sums the 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 Excel financial model with dynamic formulas and color coding?▼

Excel financial modeling with dynamic formulas and strict color-coding standards is generated automatically. It creates .xlsx files with zero formula errors, utilizing pandas for data manipulation and LibreOffice for recalculation checks.

Can I use pandas to edit and analyze existing .xlsx spreadsheet files?▼

Yes, pandas is used to edit and analyze existing .xlsx spreadsheet files. It enables comprehensive data manipulation, analysis, and insight generation while preserving your existing spreadsheet templates and formulas.

Does openpyxl support generating complex formulas without manual errors?▼

Openpyxl supports generating complex formulas without manual errors by automating formula creation and management. It ensures zero formula errors and preserves existing templates during spreadsheet editing and creation tasks.

What is the best way to automate data analysis for .csv and .tsv files?▼

The best way to automate data analysis for .csv and .tsv files is using pandas for data manipulation. This approach enables comprehensive spreadsheet operations including creation, editing, and analysis across multiple file formats.

How do spreadsheet error checking and formula recalculation work in automated workflows?▼

Spreadsheet error checking and formula recalculation work by using LibreOffice to validate formulas. This ensures zero formula errors are present in the generated .xlsx and .xlsm files before finalizing data manipulation tasks.