TextReplacer for spreadsheet
This topic contains 1 reply, has 2 voices, and was last updated by 
Viewing 2 posts - 1 through 2 (of 2 total)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic.
Home › Forums › SpreadsheetML › TextReplacer for spreadsheet
This topic contains 1 reply, has 2 voices, and was last updated by
Hi Eric,
do you have a TextReplacer class that works with Excel files?
If you don’t, could you shine some light on how to do it? Given the cells may have custom formatting…
Thanks!
Hi,
No, I don’t have a TextReplacer for Excel files. It is a great idea, though.
Doing a TextReplacer for SpreadsheetML is fairly complicated. Text can be stored in the shared string table, or it can be directly in cells. If text were in the shared string table, then depending on the behavior you want, the modification of the shared string table could be a bit complex.
One pretty big complication – if text is in a cell that is a column heading for a table, and if there are formulas elsewhere that refer to that table and column, then those formulas would need to be modified. Without doing this, you would end up with an invalid spreadsheet. You could disallow changing column headings, but even doing this check isn’t so simple.
-Eric
You must be logged in to reply to this topic.