I recently encountered a problem with the Excel Cell Updater.
Per definition of how the Excel Cell Updater works, it probably nearly always contains multiple datatypes (like strings, numbers) because at the end of the day, if you fill more than just “one” column you might have more data.
However, if you write in a pre-formatted Excel template (e. g. with conditional formatting and a color shading from green to red for highest to lowest values) this all does not work anymore.
If you write the content “as is” Excel will return some strange errors.
If you convert them to e. g. string, all formatting gets lost, which in return renders the Excel cell updater useless (to use as a templating engine).
Hi @kowisoft , all I can think of at the moment is making it a “two-pass” approach. Separate off the updates for numerics, and apply these first, then apply a second Excel Cell Updater using the intermediate file as the new template file: