dhatim / fastexcel

Generate and read big Excel files quickly
Other
647 stars 116 forks source link

Xlsx file modification #301

Closed rrp-cnf closed 1 year ago

rrp-cnf commented 1 year ago

After reading the documentation I have the feeling that you can efficiently read or write excel files. My question is, can I read a sheet from an existing xlsx file, update/create a bunch of cells and then write the xlsx file back to disk?

ochedru commented 1 year ago

You could achieve that by reading all cells into memory (or stream them), modify the cells you want to modify, and write the result to another workbook. But Fastexcel is not suitable for in-place modifications of an Excel workbook.