Excel doesn't open when data contains HTML tags

[Twistur]

Hi guys,

I noticed that when using ExportFormat.ExcelML with columns containg tags, the generated file cannot be opened. I have a column which contains "<" and ">" and this basically breaks the format. I tried intercepting the value in the ElementExporting event but it doesn't look like it's helping me. A sample event log file froom Excel looks like this:

XML PARSE ERROR:  Missing end-tag
  Error occurs at or below this element stack:
    <ss:Workbook>
     <ss:Worksheet>
      <ss:Table>
       <ss:Row>
        <ss:Cell>
         <ss:Data>
          <ss:CompanyName>

The value for column CompanyName would be something like "<Acme Inc>"

How do I go about this? I

[Pavel Pavlov]

Hi Gio ,
Please use
e.ShouldEncodeValue = true;
in the ElementExporting  event handler of RadGridView.

Greetings,
Pavel Pavlov
the Telerik team

[Twistur]

Thanks for the reply Pavel.

Problem is still there unfortunately.

[Oliver]

Hi,

I have the same problem, sometimes, we have the following string "<???>" in our columns and my users cannot export their grids content, what is the solution?

Thank's

[Nayaz]

Hello,
I had the same problem and it was due to Encoding, I was using Encoding.Default to write in ExcelML stream and when I try with UTF8 it worked !