libreoffice-calc

Solid

Use 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.

Data & Documents 6 stars 1 forks Updated 4 days ago MIT

Install

View on GitHub

Quality Score: 78/100

Stars 20%
28
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
80
License 10%
100
Description 5%
100

Skill Content

# LibreOffice Calc Use the bundled `calc` modules for UNO-backed Calc spreadsheet work. All paths must be **absolute**. Bundled modules live under `scripts/` in this skill directory, so set `PYTHONPATH=<skill_base_dir>/scripts`. If setup or runtime issues appear, check `references/troubleshooting.md`. ## API Surface ```python # Non-session utilities create_spreadsheet(path, source=None) # source: path to .json or .xml file to import export_spreadsheet(path, output_path, export_format) # formats: "pdf", "xlsx", "csv" snapshot_area(doc_path, output_path, sheet="Sheet1", row=0, col=0, width=None, height=None, dpi=150) # Session (primary editing API) CalcSession(path) -> context manager CalcSession methods: read_cell(target: CalcTarget) -> dict[str, object] write_cell(target: CalcTarget, value, value_type="auto") read_range(target: CalcTarget) -> list[list[dict[str, object]]] write_range(target: CalcTarget, data) format_range(target: CalcTarget, formatting: CellFormatting) list_sheets() -> list[dict[str, object]] add_sheet(name, index=None) rename_sheet(target: CalcTarget, new_name) delete_sheet(target: CalcTarget) define_named_range(name, target: CalcTarget) get_named_range(target: CalcTarget) -> dict[str, object] delete_named_range(target: CalcTarget) set_validation(target: CalcTarget, rule: ValidationRule) clear_validation(target: CalcTarget) create_chart(target: CalcTarget, spec: ChartSpec) update_chart(target: CalcTarget, s...

Details

Author
dfk1352
Repository
dfk1352/LibreOffice-skills
Created
4 months ago
Last Updated
4 days ago
Language
Python
License
MIT

Similar Skills

Semantically similar based on skill content — not just same category