I am looking to export the grid into excel using RadGrid.MasterTableView.ExportToExcel(). Here is the problem: we're using SSL and disallowing caching - this results in IE6 not being able to open or save the documents altogether.
The no caching header is set in the master page - so I'm thinking to use a page without a master page to export the file i.e. allow caching on the 'export' page, if you see what I mean. I can pass the grid reference to the export page but when I run the export method, nothing happens.
Is there anyway to get at the excel object or data so that I can stream it out to response manually? Or is there something wrong with my approach or is there a recommended workaround?
Thank you in advance.
The no caching header is set in the master page - so I'm thinking to use a page without a master page to export the file i.e. allow caching on the 'export' page, if you see what I mean. I can pass the grid reference to the export page but when I run the export method, nothing happens.
Is there anyway to get at the excel object or data so that I can stream it out to response manually? Or is there something wrong with my approach or is there a recommended workaround?
Thank you in advance.
1 Answer, 1 is accepted
0
Hi Ron,
You can use the GridExporting event handler of the Grid to get the exported data. Give it a try an let us know if you have more questions.
Sincerely yours,
Pavel
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
You can use the GridExporting event handler of the Grid to get the exported data. Give it a try an let us know if you have more questions.
Sincerely yours,
Pavel
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.