I need some help on getting text with additional html format tags into an excel file. Currently I read data out of the database into a datatable. Then I import the data into a new Worksheet with ImportDataTable…
Now i’m looking for a way to get a new column into the worksheet. The text to be imported has html tags. I already found the Cell.HtmlString but could not find a way to use this.
My program is a dynamic process which reads from different views on my database and creates excel exports.
Is there a way to run through a column and set the HtmlString on all the cells ?
Or maybe better an eventhandle i can use on the ImportDataTable ?
THX for any help!