This is a migrated thread and some comments may be shown as answers.

RadGrid Export ExcelML issue

1 Answer 61 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Prakash Jothi
Top achievements
Rank 2
Prakash Jothi asked on 17 Oct 2008, 11:20 AM
Overview of the Implementation

We are using the RadGrid extensively. And we had few common functionalities to be implemnted for each grid. That's the reason, we inherited RadGrid. We as well are overriding,
    OnInit, 
    OnItemCreated
    OnItemDataBound
    OnSortCommand

    OnRowSelect

for our own needs. But it is always ensured that the base function's for the overriden function is always called.
Also, for our purposes we have inherited, the GridBoundColumn as well as
GridHyperLinkColumn.

PROBLEM:

SCENARIO: EXCELML
The Export Format is set to ExcelML. and the code written for it is:

grid.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
grid.ExportSettings.ExportOnlyData = true;
grid.ExportSettings.IgnorePaging = true;
grid.ExportSettings.OpenInNewWindow = true;
grid.MasterTableView.ExportToExcel();


The Export functionality is able to export the Hypelink Columns but, it fails to expport the GridBound Columns. So essentially we are just getting one column exported in excel, which tends to be the Hyperlink Column.

SCENARIO: HTML

//grid.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
grid.ExportSettings.ExportOnlyData = true;
grid.ExportSettings.IgnorePaging = true;
grid.ExportSettings.OpenInNewWindow = true;
grid.MasterTableView.ExportToExcel();


Now the Export functionality is able to export all but the Hypelink Columns. So essentially we are just getting all the column exported in excel, ,other than the Hyperlink one.

When we use the trick provided in
RadGrid for ASP.NET AJAX Q2 2008
Exporting tips and tricks

We were able get all the columns exported in excel in Html Format.
But we would like to have it in pure Excel format.

Any help to resolve the issue would be greatly appreciated.
Thanks

1 Answer, 1 is accepted

Sort by
0
Rosen
Telerik team
answered on 20 Oct 2008, 12:48 PM
Hello Prakash Jothi,

I'm afraid that I was unable to recreate the described behavior with the given details. Please find attached a simple implementation of the described scenario with which I have test locally. Please take a look and let me know if I'm missing something obvious.

Kind regards,
Rosen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Tags
Grid
Asked by
Prakash Jothi
Top achievements
Rank 2
Answers by
Rosen
Telerik team
Share this question
or