libreoffice-calc

You can automate LibreOffice Calc via the UNO API to create, edit, format, and export spreadsheets programmatically. It supports session-based workflows, managing sheets, named ranges, validations, and charts.

Patch-driven batch processing applies complex modifications across multiple Calc documents simultaneously. It uses a patch DSL to define and execute repetitive editing, formatting, and extraction tasks automatically without manual intervention.

Yes, scripting with the UNO API allows you to generate and modify charts in LibreOffice Calc. You can programmatically add, update, and control chart elements across multiple sheets within a managed session.

Yes, this UNO-based document control approach fully supports batch processing across multiple sheets. It handles complex modifications, validations, and data extraction across entire workbooks in a single automated workflow.

Using UNO for document control in Calc requires a session-based workflow and understanding of the patch DSL. It is designed for structured batch operations, so highly interactive or ad-hoc manual editing tasks may not be the best fit.

You need an environment that supports the UNO API and can manage active LibreOffice Calc sessions. The automation runs scripts that handle document control, so a compatible runtime or scripting host is required to execute the batch processing.