← ClaudeAtlas

libreoffice-calclisted

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.
aiskillstore/marketplace · ★ 329 · Data & Documents · score 79
Install: claude install-skill aiskillstore/marketplace
# 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) export_spreadsheet(path, output_path, 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) open_calc_session(path) -> CalcSession 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, spec: ChartSpec) delete_chart(target: CalcTarget) recalculate() patch(pat