dfk1352/LibreOffice-skills / skills/libreoffice-calc
libreoffice-calc
VerifiedUse when creating, editing, formatting, exporting, or extracting LibreOffice Calc (.ods) spreadsheets via UNO, including session-based cell and range edits, sheets, named ranges, validation, charts, patch workflows, and snapshots.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 11.3 KB |
| references/troubleshooting.md | markdown | 3.5 KB |
| scripts/calc/__init__.py | script | 586 B |
| scripts/calc/core.py | script | 3.5 KB |
| scripts/calc/exceptions.py | script | 2.5 KB |
| scripts/calc/patch.py | script | 11.5 KB |
| scripts/calc/session.py | script | 19.5 KB |
| scripts/calc/snapshot.py | script | 7.3 KB |
| scripts/calc/targets.py | script | 12.9 KB |
| scripts/colors.py | script | 4.6 KB |
| scripts/constants.py | script | 180 B |
| scripts/exceptions.py | script | 748 B |
| scripts/patch_base.py | script | 12.1 KB |
| scripts/session.py | script | 2.6 KB |
| scripts/uno_bridge.py | script | 9.1 KB |
scripts/calc/core.py
View on GitHub"""Core document lifecycle operations for Calc."""
from pathlib import Path
from calc.exceptions import CalcSkillError, DocumentNotFoundError
from uno_bridge import uno_context
EXPORT_FILTERS = {
"pdf": "calc_pdf_Export",
"xlsx": "Calc MS Excel 2007 XML",
"csv": "Text - txt - csv (StarCalc)",
}
_IMPORT_FORMATS = {".json", ".xml"}
def create_spreadsheet(path: str, source: str | None = None) -> None:
"""Create a new Calc spreadsheet at the specified path.
When *source* is given it is treated as an input file to convert.
Supported source formats: ``.json``, ``.xml``. LibreOffice
auto-detects the structure and maps tabular data to sheets.
When *source* is ``None`` an empty spreadsheet is created.
Args:
path: Output ``.ods`` path for the new spreadsheet.
source: Optional path to a JSON or XML file to import.
Raises:
DocumentNotFoundError: If *source* does not exist.
CalcSkillError: If the source format is unsupported or
import fails.
"""
output = Path(path)
output.parent.mkdir(parents=True, exist_ok=True)
if source is not None:
_import_source(source, output)
else:
_create_blank(output)
def export_spreadsheet(path: str, output_path: str, export_format: str) -> None:
"""Export a spreadsheet to another format.
Args:
path: Path to the spreadsheet file.
output_path: Destination file path.
export_format: Export format key.
Raises:
CalcSkillError: If the export format is unsupported.
"""
if export_format not in EXPORT_FILTERS:
raise CalcSkillError(f"Unsupported export format: {export_format}")
file_path = Path(path)
if not file_path.exists():
raise DocumentNotFoundError(f"Document not found: {path}")
output = Path(output_path)
output.parent.mkdir(parents=True, exist_ok=True)
with uno_context() as desktop:
doc = desktop.loadComponentFromURL(
file_path.resolve().as_uri(),
"_blank",
0,
(),
)
try:
import uno
filter_name = EXPORT_FILTERS[export_format]
filter_prop = uno.createUnoStruct("com.sun.star.beans.PropertyValue")
filter_prop.Name = "FilterName"
filter_prop.Value = filter_name
doc.storeToURL(output.resolve().as_uri(), (filter_prop,))
finally:
doc.close(True)
def _create_blank(output: Path) -> None:
"""Create an empty Calc spreadsheet."""
with uno_context() as desktop:
doc = desktop.loadComponentFromURL("private:factory/scalc", "_blank", 0, ())
try:
doc.storeAsURL(output.resolve().as_uri(), ())
finally:
doc.close(True)
def _import_source(source: str, output: Path) -> None:
"""Import a JSON or XML file via UNO auto-detection and save as ODS."""
source_path = Path(source)
if not source_path.exists():
raise DocumentNotFoundError(f"Source file not found: {source}")
suffix = source_path.suffix.lower()
if suffix not in _IMPORT_FORMATS:
raise CalcSkillError(f"Unsupported import format: {suffix}")
with uno_context() as desktop:
doc = desktop.loadComponentFromURL(
source_path.resolve().as_uri(), "_blank", 0, ()
)
if doc is None:
raise CalcSkillError(f"Failed to import {source}: LO returned no document")
try:
doc.storeAsURL(output.resolve().as_uri(), ())
finally:
doc.close(True)
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |