skills.rest
okwinds
okwindsCOMMUNITY
Explore all skills by this author →
GitHub

xlsx-offline

Recalculate Excel formulas offline and validate workbook integrity with LibreOffice and openpyxl.

50|3|Updated Jan 30, 2026
Search Tags:#offline#openpyxl#formulas#xlsx#LibreOffice#recalculation
One-click install
npx skills add https://github.com/okwinds/miscellany --skill xlsx-offline
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx-offline
Source: https://github.com/okwinds/miscellany/tree/main/agent/skills/xlsx-offline
Command: npx skills add https://github.com/okwinds/miscellany --skill xlsx-offline

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

This Skill enables offline Excel (.xlsx) creation, editing, and formula recalculation, ensuring that formulas recompute correctly and that worksheets remain error-free.

Core Features & Use Cases

  • Offline read/write of Excel files using Python (openpyxl) with preservation of formulas during edits.
  • LibreOffice-based formula recalculation via a local, isolated profile to avoid macros persisting in your user environment.
  • Automated error scanning for common Excel formula issues (#REF!, #DIV/0!, #NAME?, etc.) and reporting so you can quickly fix data.

Quick Start

Use the xlsx-offline skill to recalculate formulas in input.xlsx and output the validated workbook as output.xlsx: python recalc.py input.xlsx 60

Frequently Asked Questions about xlsx-offline

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

FAQPage Schema
How do I recalculate Excel formulas offline without opening the file?▼

You can recalculate Excel formulas offline by running the recalc.py utility with an input .xlsx file, which uses LibreOffice to recompute formulas and outputs a validated workbook.

Can I use openpyxl to edit and preserve Excel formulas during offline recalculation?▼

Yes, openpyxl is used to read and write Excel files offline while preserving formulas, and LibreOffice handles the actual offline recalculation to ensure correct results.

Does offline Excel recalculation detect formula errors like #REF! or #DIV/0!?▼

Offline Excel recalculation includes automated error scanning that detects common formula issues like #REF!, #DIV/0!, and #NAME?, providing reports to help you quickly fix data.

What is the best way to run LibreOffice recalculation without macros persisting?▼

Run recalc.py in isolated mode with the profile preservation option, which uses a local isolated LibreOffice profile to prevent macros from persisting in your user environment.

Do I need LibreOffice installed to recalculate xlsx formulas offline?▼

Yes, LibreOffice is required for the formula recalculation engine, while openpyxl handles the offline inspection of Excel formulas and workbook structure.

Why does my Excel workbook show formula errors after offline editing?▼

Formula errors after offline editing occur when formulas are not properly recalculated; running recalc.py forces a full LibreOffice recalculation and scans for issues to ensure error-free worksheets.

Related Skills

Explore More Data & Analytics Skills→
crossxwillcrossxwill
5

xlsx

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

Community
Intermediate
OpenCoworkAIOpenCoworkAI
2.0k

xlsx

Create and edit Excel workbooks with formulas across .xlsx, .xlsm, .csv, and .tsv formats.

Official
Advanced
dachentdachent
18

xlsx

Create and modify Excel workbooks with pandas and openpyxl.

Community
Advanced
RonaldJENRonaldJEN
5

xlsx

Automate Excel workbook creation, editing, and analysis with Python.

Community
Advanced