dhatim / fastexcel

Generate and read big Excel files quickly
Other
677 stars 122 forks source link

Excel update operation #284

Closed dskumar101 closed 1 year ago

dskumar101 commented 1 year ago

I see we can read and write using fastexcel-reader and fastexcel-writer respectively. However, I have a scenario where I need to update existing excel with data. Can you suggest how I can achieve this? Thanks

ochedru commented 1 year ago

Indeed, fastexcel-writer is not able to update an existing workbook. For this scenario, you could use Apache POI. If you have many updates, however, it may be beneficial to read the existing workbook with fastexcel-reader and create a new workbook using fastexcel-writer.