IWAdvWebGridExcelIO fail to export html chars to excel correctly

IW TMS IntraWeb Component Pack
1

Hi

I am using the IWAdvWebGridExcelIO to export data from a IWAdvWebGrid.

It works fine when I export strings to excel except when the strings includes chars like < or >. They are presented ok on the grid itself, but when exported are the shown as < and > in excel.

I have set the ExportCellAsString to true in the OnExportColumnFormat
I have also experimented with different Cell formats in the OnCellFormat without much luck.

Can you guide me in the right direction to get it to work.

I am using the latest version og the Intraweb packages.

Regards Peter

2

Hi,

Please note that text between < and > characters will be treated as html tags in the grid.
Unfortunately this will be displayed literally in Excel as it will not display html in cells.

3

Hi,
Is there a way to solve this?
Can the strings be converted before it is send to Excel?

Regards
Peter

4

You can set the option ExportToHTMLTags to False to remove HTML tags.

TIWAdvWebGridExcelIO1.Options.ExportHTMLTags := False;