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

Export via ExcelML workbook is empty of data...

2 Answers 50 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Wired_Nerve
Top achievements
Rank 2
Wired_Nerve asked on 10 Jul 2012, 05:23 PM
The Setup:
1. I have a page with a radgrid that is visible for the user to filter sort and etc.
2. I have another that is not visible (thus no data binding has occurred yet)  that has very specific fields that are for exporting to excel.
3. The user filters the top grid.  Then select a report to be generated in excel from this selection.  This report has extra data we don't want in the primary grid.
4. The user hits a action button (GO) and the invisible grid's rebind() event is called.
4.  I am currently using the grid_ExcelExportCellFormatting to make the grid look nice (works great) 
5.  I would like to use the ExcelML events instead so I can gain access to worksheet formatting like freeze panes and etc...

But then I change the grids export type to excelML and excel opens.. The workbook is empty.  I do no want to load the grid on the primary page load or during the page_init.. Only when the user selects GO (generate the selected report).

Any ideas on how I can get the grid to export data besides loading it with data when the page loads for the first time?

2 Answers, 1 is accepted

Sort by
0
Wired_Nerve
Top achievements
Rank 2
answered on 10 Jul 2012, 05:35 PM
As soon as I put in the code - it breaks...
<ExportSettings>
                <Excel Format="ExcelML" />
</ExportSettings>
0
Daniel
Telerik team
answered on 12 Jul 2012, 07:17 AM
Hi Warren,

Please try setting the UseAllDataFields (on MasterTableView object) property to true.

Regards,
Daniel
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
Wired_Nerve
Top achievements
Rank 2
Answers by
Wired_Nerve
Top achievements
Rank 2
Daniel
Telerik team
Share this question
or