Exporting data to Excel

[anna]

I am trying to export data from RadGrid to Excel. code is
RadGrid1.ExportSettings.ExportOnlyData = True
RadGrid1.ExportSettings.IgnorePaging = True
RadGrid1.ExportSettings.OpenInNewWindow = True
RadGrid1.MasterTableView.ExportToExcel()
I have few columns as Hyperlink in my grid. Excel file has all the data except the Hyperlink data. Its missing data in those columns. Showing those columns empty in Excel file.
What should I do to have all the data in my excel file? need help..

[Shinu]

Hi Anna,

Exporting GridButtonColumn/GridTemplateColumn/GridHyperLinkColumn data:

The GridButtonColumns in Telerik RadGrid have LinkButtons/PushButtons/ImageButtons in their cells. They are not considered as data,that is why when you select the second parameter(ExportOnlyData) of the ExportToExcel method to be true, those buttons will be stripped from the resulting Excel file.
I hope the following help article will help you to sort out the problem.
Exporting tips and tricks

Shinu.

[Ryan]

Shinu has a great explanation of why it _won't work_, but what about how to get export to work with GridButtonColumns ?

For example, how can we tell export to take the value : LinkButton.Text to export?

Thanks.

[Daniel]

Hello Ryan,

Which export format is used in your project - HTML, ExcelML or BIFF? This information will help me provide to-the-point answer.

Regards,
Daniel
Telerik

[Ryan]

Just normal excel , I believe ExcelML .

[Kostadin]

Hello Ryan,

In this case you are using Html Based export. In order to export the buttons text you have to set ExportOnlyData property to false.

Regards,
Kostadin
Telerik