skills.rest
tajo9128
tajo9128COMMUNITY
Explore all skills by this author →
Website𝕏@hosting_hydGitHub

xlsx

Automate Excel (.xlsx, .xlsm) and delimited (.csv, .tsv) spreadsheet creation, editing, and analysis using Python with openpyxl and LibreOffice recalc.py for formula preservation and regeneration of summaries and charts.

Updated Aug 23, 2026
Search Tags:#templates#visualization#formulas#spreadsheet#data-analysis#xlsx#csv
One-click install
npx skills add https://github.com/tajo9128/BioDockify-pharma-research-ai --skill xlsx-tajo9128
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/tajo9128/BioDockify-pharma-research-ai/tree/main/ui/src/skills/xlsx
Command: npx skills add https://github.com/tajo9128/BioDockify-pharma-research-ai --skill xlsx-tajo9128

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheets across multiple formats, preserving formulas and templates while enabling rapid data exploration.

Core Features & Use Cases

  • Formula-preserving editing: Modify existing workbooks (.xlsx, .xlsm) without breaking calculations.
  • Multi-format support: Create and read data from Excel and delimited files like CSV/TSV.
  • Data analysis & visualization: Quick generation of summaries and charts from your data.

Quick Start

Use the xlsx skill to create a new budget workbook, import data from a CSV, apply formulas, and generate a summary sheet.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I edit an Excel workbook without breaking existing formulas?▼

To edit an Excel workbook without breaking formulas, use a formula-preserving approach that modifies .xlsx and .xlsm files while maintaining calculations intact. This skill leverages openpyxl for file I/O and a recalc script to ensure formula continuity during data updates.

What is the best way to automate spreadsheet creation from CSV data?▼

The best way to automate spreadsheet creation from CSV data is using a multi-format support tool. This skill reads delimited files like CSV and TSV, applies formulas to the dataset, and generates formatted Excel workbooks, reducing manual workbook work through Python automation.

Does openpyxl support formula recalculation for Excel files?▼

openpyxl handles file I/O for Excel files, but formula recalculation requires a separate engine. This skill uses a recalc.py script powered by LibreOffice to recalculate formulas, ensuring that calculations in .xlsx and .xlsm workbooks are accurately updated after editing.

Can I generate charts and summaries directly from a spreadsheet?▼

Yes, you can generate charts and summaries directly from a spreadsheet. This skill supports data analysis and visualization, allowing you to quickly create summary sheets and visual charts from existing Excel workbook or delimited data files.

Why does my spreadsheet formula return stale data after editing?▼

A spreadsheet formula returns stale data after editing when the workbook is not recalculated. This skill addresses this limitation by using a recalc.py script with LibreOffice to force formula recalculation, ensuring that values in your .xlsx files reflect the latest changes.

Related Skills

Explore More Data & Analytics Skills→
cbbkrd-techcbbkrd-tech

xlsx

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.

Community
Advanced
47network47network
5

xlsx-generator

Generate Excel-compatible XLSX workbooks from structured data and CSV exports.

Community
Intermediate
DevHive1DevHive1
18

excel-generator

Generate Excel workbooks with formatting, formulas, and charts using openpyxl and xlsxwriter.

Community
Intermediate
zakarooozakarooo

xlsx

Create, edit, and analyze spreadsheets while preserving formulas and formatting.

Community
Advanced