xlsx

Automate Excel workbook creation, editing, and analysis across XLSX, XLSM, CSV, and TSV formats.

Updated Aug 1, 2024
One-click install
npx skills add https://github.com/skkarki/Sanam --skill xlsx-skkarki
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/skkarki/Sanam/tree/main/skills/xlsx
Command: npx skills add https://github.com/skkarki/Sanam --skill xlsx-skkarki

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines complex Excel-driven workflows by automating creation, modification, and analysis of spreadsheets, eliminating repetitive manual tasks and reducing human error.

Core Features & Use Cases

  • Automated workbook creation: generate new spreadsheets with formulas, formatting, and templates.
  • Formula preservation and recalculation: modify existing workbooks while preserving formulas and trigger recalculation via LibreOffice.
  • Data analysis and reporting: summarize data, apply styles, and export results across common formats (XLSX, CSV, TSV).

Quick Start

To begin, request a new workbook with a predefined template and a simple revenue model, then initiate a recalculation pass to update outputs.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel workbook editing while preserving formulas and formatting?

Automate Excel workbook editing while preserving formulas and formatting by using automated spreadsheet workflows that modify existing files and trigger recalculation via LibreOffice, ensuring formula integrity is maintained across XLSX, XLSM, CSV, and TSV formats.

Can I recalculate an existing XLSX finance model without losing template styles?

You can recalculate an existing XLSX finance model without losing template styles through LibreOffice-based recalculation, which modifies workbooks while preserving formulas, formatting, and templates to update outputs accurately.

What is the best way to generate a new spreadsheet with a predefined revenue model template?

The best way to generate a new spreadsheet with a predefined revenue model template is to automate workbook creation, applying formulas and formatting while specifying the template structure to produce a ready-to-use file.

Does this spreadsheet automation approach support CSV and TSV files?

This spreadsheet automation approach supports CSV and TSV files, allowing you to analyze data, apply styles, and export results across common formats alongside standard XLSX and XLSM workbook processing.

Why do my formulas not update when I edit an Excel data dashboard automatically?

Formulas may not update when editing an Excel data dashboard automatically if a recalculation pass is not triggered; applying LibreOffice-based recalculation after modification ensures formula integrity and updates outputs correctly.