IWAdvWebGridExcelIO fail to export html chars to excel correctly

[Sondergaard_Peter (Søndergaard Peter)]

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

[Bart]

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.

[Sondergaard_Peter (Søndergaard Peter)]

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

Regards
Peter

[Bart]

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

TIWAdvWebGridExcelIO1.Options.ExportHTMLTags := False;