ck:xlsx

Create and manipulate .xlsx files with openpyxl and pandas.

1|Updated Jun 16, 2026
One-click install
npx skills add https://github.com/TNHoang2708/Gym_Ver2 --skill ck-xlsx-tnhoang2708
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: ck:xlsx
Source: https://github.com/TNHoang2708/Gym_Ver2/tree/main/.claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/TNHoang2708/Gym_Ver2 --skill ck-xlsx-tnhoang2708

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines Excel spreadsheet creation, editing, and analysis, allowing you to automate tasks, ensure data integrity, and produce professional-quality work without manual calculations.

Core Features & Use Cases

  • Spreadsheets on Demand: Generate, edit, and analyze .xlsx files with ease.
  • Automated Formulas: Avoid manual errors and speed up calculations with automated formulas.
  • Data Analysis: Utilize pandas for powerful data manipulation, visualization, and analysis.
  • Use Case: Suppose you have a financial model that requires monthly recalculations. Use this Skill to automatically update and recalculate the model with the latest data.

Quick Start

Generate a new Excel spreadsheet with a financial model by running the xlsx skill with the input data file 'financial_model.xlsx'.

Frequently Asked Questions about ck:xlsx

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

FAQPage Schema
How do I automate financial modeling and recalculate Excel spreadsheets programmatically?

Automate Excel spreadsheet creation and formula recalculation by programmatically generating .xlsx files with pandas and openpyxl, then using LibreOffice to update calculated values.

What is the best way to manipulate spreadsheet data for analysis using pandas?

Manipulate spreadsheet data for analysis by loading .xlsx files into pandas DataFrames, enabling automated data manipulation, visualization, and analysis without manual calculations.

Does openpyxl support automated formulas for .xlsx files?

Yes, openpyxl supports writing automated formulas into .xlsx files, allowing you to inject calculations programmatically to avoid manual errors and speed up data processing workflows.

Why do I need LibreOffice to recalculate formulas in an Excel spreadsheet?

You need LibreOffice to recalculate formulas because Python libraries like openpyxl and pandas handle data structure but lack a built-in calculation engine to evaluate and update formula results.

Can I use Python to edit existing .xlsx files for data analysis?

Yes, you can use Python to edit existing .xlsx files for data analysis by leveraging openpyxl to modify spreadsheet structures and pandas to process the underlying data programmatically.