Wired_Nerve
Top achievements
Rank 2
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?
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
0
Wired_Nerve
Top achievements
Rank 2
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
Hi Warren,
Please try setting the UseAllDataFields (on MasterTableView object) property to true.
Regards,
Daniel
the Telerik team
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.