skills.rest
khapn-2933
khapn-2933COMMUNITY
Explore all skills by this author →
GitHub

tkm:xlsx

Creates, edits .xlsx/.csv/.tsv files and analyzes data with pandas.

Updated May 13, 2026
Search Tags:#financial modeling#data analysis#spreadsheet#excel#formula recalculation
One-click install
npx skills add https://github.com/khapn-2933/agentic-coding-hands-on --skill tkm-xlsx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: tkm:xlsx
Source: https://github.com/khapn-2933/agentic-coding-hands-on/tree/main/.claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/khapn-2933/agentic-coding-hands-on --skill tkm-xlsx

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the process of creating, editing, and analyzing Excel spreadsheets, ensuring accurate data manipulation and formula recalculation.

Core Features & Use Cases

  • Spreadsheets Creation: Build new Excel files from scratch or load existing ones.
  • Data Analysis: Use pandas for data manipulation, analysis, and visualization.
  • Excel File Editing: Edit formulas, formatting, and data within existing Excel files.
  • Use Case: A financial analyst uses this Skill to create a comprehensive financial model, with the Skill handling formula recalculation and data analysis.

Quick Start

Use the xlsx skill to create a new workbook and calculate the total sales from the provided data file 'sales_data.xlsx'.

Frequently Asked Questions about tkm:xlsx

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

FAQPage Schema
How do I recalculate Excel formulas in an existing spreadsheet programmatically?▼

To recalculate Excel formulas in an existing spreadsheet, this Skill uses openpyxl to edit formulas and LibreOffice to execute the recalculation, ensuring accurate data updates.

Can I use pandas for data analysis directly on an Excel file?▼

Yes, you can use pandas for data analysis directly on an Excel file, as this Skill supports loading .xlsx, .csv, and .tsv formats to perform data manipulation and visualization.

Do I need LibreOffice to edit and recalculate formulas in my xlsx files?▼

Yes, you need LibreOffice to recalculate formulas in your xlsx files, while openpyxl is required for editing the spreadsheet structure and handling the underlying data manipulation.

What is the best way to build a financial model from scratch using Excel data?▼

The best way to build a financial model from scratch is using this Skill to create workbooks, input data, and apply formula recalculation combined with pandas for comprehensive data analysis.

Does this spreadsheet analysis approach support TSV and CSV files alongside Excel?▼

Yes, this spreadsheet analysis approach supports TSV and CSV files alongside Excel, allowing you to load, edit, and analyze all three formats interchangeably using pandas and openpyxl.

Why are my Excel formula recalculations not updating when I edit xlsx files?▼

Excel formula recalculations may not update if LibreOffice is not properly configured, as this Skill depends on the LibreOffice engine to compute and refresh formula results after openpyxl edits.

Related Skills

Explore More Finance & Accounting Skills→
mattmacleod16-svgmattmacleod16-svg
1

spreadsheet

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

Community
Intermediate
EnztunEnztun

xlsx

Automate Excel spreadsheet operations with Python libraries like openpyxl, pandas, and matplotlib.

Community
Advanced
pounctpounct

xlsx

Create and edit Excel spreadsheets with formulas using openpyxl and pandas.

Community
Advanced
ChatAndBuildChatAndBuild
1

xlsx

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

Official
Advanced