I want to update the value of a cell in an Excel file. In order to change the cell's value I do the following:
Do I also have to manually update the count and uniqueCount properties of the SharedStringTable ?
I have noticed that it is not automatically updated, but maybe there is a method call I'm missing.
Thanks for your help!
You do not need to deal with the shared string table to update a cell. See this video:
The concern might be that performance might suffer. I have created spreadsheets with 20 million cells using this approach, and the performance is just fine. In my particular case, spreadsheet size was fine also.