Getting Null Exception while exporting detailstable data

[Bharat]

Hi,

I am trying to export the inner radgrid details in ExcelML format, but I am getting null exception after the process.
While I am able to export in other format.

Please refer to attached screenshot

Thanks
Bharat

[Princy]

Hi Bharat,

The error is caused by the fact that you may be using simple data binding to populate the RadGrid. In order to use export to ExcelML, you should bind the grid control through AdvancedDataBinding or declaratively by DataSourceControl, as stated in the documentation here.

Thanks,
Princy

[Bharat]

Hi Princy 

I am using HTML format, but it is showing excel sheet  as white paper not as formatted as Excel,
Can you point me how to change this behavior if it's possible in Telerik with HTML format

Thanks 
Bharat

[Bharat]

Hi Princy,

Can we export all the inner details table of multiple node in a single report.

Thanks
Bharat 

[Kostadin]

Hello Bharat,

In order to export a formatted table you have to set ExportOnlyData to true. Regards your second question you could either show the Export to excel button on each detail table or find the GridTableView into your code behind and call ExportToExcel method.
Mark-up:

<DetailTables>
    <telerik:GridTableView CommandItemDisplay="Top">
        <CommandItemSettings ShowExportToExcelButton="true" />
        <Columns>
          ............
        </Columns>
    </telerik:GridTableView>
</DetailTables>

C#:

RadGrid1.MasterTableView.DetailTables[0].ExportToExcel();

Regards,
Kostadin
Telerik