radgrid export to excel problem

[brad]

Hello,
     my problem is as follows. we have several webpages, some of them hosting radgrids. above these grids that display data we have radtoolbars. in the toolbar, we created an Export to Excel Icon, that when clicked, Excel window should open and display the data format of the grid.

the results are awckard. when the button is clicked, the Grid itself goes into an Excel type format, it removes the checkedboundfields (as expected). but stays displayed on the page itself.

no new window opens. the grid doesn't stay in its current form (instead displays like an Excel form)  we have office 2007. Code using is as follows.

                    Gridview1.ExportSettings.ExportOnlyData = true;
                    Gridview1ExportSettings.OpenInNewWindow = true;
                    Gridview1.ExportSettings.FileName = "RulesExport";
                    Gridview1.MasterTableView.ExportToExcel();

when the Export to Excel button is clicked, the grid does not expand and fill the page, it stays in its current height and width. the columns change as it would if it were going to excel, but does not. no new window opens.

any suggestions to this?

[brad]

also, to add, i have updated my telerik controls in the recent patch released at the end of August.

[Daniel]

Hello Brad,

Take a look at this blog and try to set the default behavior depending on your scenario.
Excel 2007 & Internet Explorer

Regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[brad]

i have looked at the file options and everything is set accordingly, im still achieving the same results.

[Daniel]

Hello Brad,

Could you please send us a simple working example via regular support ticket? Thus we will be able to give you more straight-to-the-point answer.

Greetings,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[brad]

Hi,

i figured out the problem. we had sections in the grid that grouped the rows preventing the export to excel to function properly

[Paul J]

We're having a similar problem in that when calling the export function, it changes the grid itself into looking like the exported contents for the excel export, however, it never asks the user to save an excel file, nor ever actually opens excel. we're using the following code:

  SearchGrid.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.None
        SearchGrid.MasterTableView.ShowFooter = False
        SearchGrid.MasterTableView.ClearEditItems()
        SearchGrid.MasterTableView.ClearSelectedItems()
        SearchGrid.MasterTableView.AllowPaging = False
        SearchGrid.Rebind()
        SearchGrid.ExportSettings.OpenInNewWindow = True
        SearchGrid.ExportSettings.ExportOnlyData = True
        SearchGrid.MasterTableView.HierarchyDefaultExpanded = False
        SearchGrid.MasterTableView.ExportToExcel()

the grid does have a details table. we're using controls version 2008.3.1314.20
as far as brad's resolution, i'm not quite sure what he meant by sections grouping rows together. as far as I can tell, our grid does not do that...

[Paul J]

Nevermind. I believe the problem is due to the fact that the grid is wrapped within an asp.net update panel via the masterpage.

[Daniel]

Hello Paul,

I recommend you examine the following links:
Export from ajaxified grid
Exclude controls from ajaxifying

Let us know if you need more information.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.