xlsx

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

Updated Sep 4, 2022
One-click install
npx skills add https://github.com/yt3trees/dotfiles --skill xlsx-yt3trees
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/yt3trees/dotfiles/tree/main/.gemini/skills/xlsx
Command: npx skills add https://github.com/yt3trees/dotfiles --skill xlsx-yt3trees

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the heavy lifting of creating, editing, and analyzing spreadsheets by enabling reliable, formula-preserving workflows and consistent formatting across large workbooks.

Core Features & Use Cases

  • Automated workbook creation with formulas and styling to standard templates
  • Read, analyze, and transform data across multiple sheets while preserving formulas
  • Recalculate formulas using a LibreOffice-based workflow to ensure accuracy and reproducibility in analytics

Quick Start

Use the xlsx skill to create a new workbook named 'sample.xlsx' with a small dataset and a simple formula in one cell.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation with formulas and formatting?

Automate Excel spreadsheet creation by generating new workbooks complete with formulas and standard styling. It handles automated workbook creation, applying formulas and consistent formatting directly to streamline your data workflows.

Can I update existing Excel sheets while preserving formulas?

Yes, you can update existing Excel sheets while preserving formulas. It reads, analyzes, and transforms data across multiple sheets without breaking your existing formulas, ensuring your spreadsheet logic remains intact during edits.

How do I recalculate formulas in xlsx workbooks to ensure zero errors?

Recalculate formulas in xlsx workbooks by employing a LibreOffice-based recalc workflow. This mechanism recalculates formulas to ensure accuracy and reproducibility in analytics, guaranteeing zero formula errors in your spreadsheets.

Does data analysis automation work with csv and tsv files alongside xlsx?

Yes, data analysis automation works across xlsx, xlsm, csv, and tsv file formats. You can read, analyze, and transform data across these workflows, making it versatile for various spreadsheet automation needs.

Do I need Python and openpyxl to automate spreadsheet workflows?

You need Python tools like pandas and openpyxl to automate spreadsheet workflows. This solution satisfies requirements for using these Python libraries to handle workbook creation, data analysis, and formula preservation effectively.

What is the best way to read and analyze data across multiple Excel sheets?

The best way to read and analyze data across multiple Excel sheets is using a Python-based approach with pandas and openpyxl. It transforms data while preserving formulas, supported by a LibreOffice workflow for accurate recalculation.