osaurus-xlsx

What problem does it solve?

This plugin addresses the need to programmatically read, create, and modify Excel (.xlsx) workbooks without manual spreadsheet editing, reducing repetitive tasks and human error.

Core Features & Use Cases

• Reading & Loading: read and load workbooks to obtain a workbook_id and structured data.
• Mutations & Transformation: modify cells, add sheets, and batch operations, then save to disk.
• Conversion: export sheets to CSV/TSV and import CSV/TSV data into a new workbook.
• Use Case: automate monthly data consolidation by reading multiple files, applying transformations, and saving a final workbook.

Quick Start

Create a new workbook with a sheet named 'Summary', add headers 'Name' and 'Value', insert a few example rows, and save as summary.xlsx.