SharedStringTable - update of count, uniqueCount

Hi all,

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:

1. Get the SharedStringTable from  my workbookPart
2. Create a new SharedStringItem
3. Append the SharedStringItem to the SharedStringTable
4. Get the index of the new added SharedStringItem
5. Update the text property of my cell to the new index.

 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!

Hi,

You do not need to deal with the shared string table to update a cell.  See this video:

openxmldeveloper.org/.../screen-cast-write-simpler-spreadsheetml-when-generating-spreadsheets.aspx

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.

-Eric