ExportToExcel and ItemDataBound

[Jamey Johnston]

I have a RadGrid with ExportToExcel functionality.  This part is working correctly when simply displaying what's on the grid.  However I'm having two issues with expanding this functionality:

1) If I add a column to my grid that does not have a "DataField" property it does not get exported.  I can work around this by supplying this parameter, but it would be nice if I could just add a column to be exported.

2) When I change the data in the ItemDataBound event, the changes don't come through.  In other words, say the column contains the value 3, and in the ItemDataBound event I change it to 20 (see below for how I am doing that), in the Excel document I still see 3 as the output.  Note that the code does execute without errors, and also if I export to PDF the correct, updated data does come through, only Excel shows the "old" data.

 

protected void RadGridHardware_ItemDataBound(object sender, GridItemEventArgs e)

 

{

 

if (e.Item is GridDataItem)

 

{

 

GridDataItem dataItem = (GridDataItem)e.Item;

 

dataItem[

"Quantity"].Text = "20";

 

}

Any thoughts or ideas?

[Daniel]

Hello Jamey,

Judging by the available information, I suppose that you are using the ExcelML format.

1) when using this format RadGrid gets the data directly from the datasource - this is why it needs the DataField property.

2) due to the aforementioned reason, RadGrid will ignore the changes you made in the ItemDataBound handler. Here you can handle the ExcelMLRowCreated event and modify the data directly in the ExcelML structure.

Let me know if your scenario is different.

Best regards,
Daniel
the Telerik team

[Jamey Johnston]

That is what I went with so I'd at least have it working.  Just found it interesting that filters (from the grid) were still used even though it otherwise seemed to be "bypassing" the grid, and when exporting to PDF it does use the databound event of the grid.  I may see if I can figure out how to turn off ExcelML so I don't have to do a bunch of duplicate code work in databound and rowcreated.  Thanks!

Jamey

[Daniel]

Hello Jamey,

You can set the desired Excel format via the ExportSettings Excel-Format property:

RadGrid export overview

<ExportSettings Excel-Format="ExcelML" />

<ExportSettings Excel-Format="Html" />

Best regards,
Daniel
the Telerik team