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

Excel Export Problem

25 Answers 253 Views

Grid

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

Robert asked on 21 Nov 2009, 02:13 PM

xls-problem.jpg

I am having a problem exporting from my grid to Excel. When issuing the export it creates the file for export and I can save the excel file to disc and open from disc fine. However when I try to open the document directly from the server response I get an error as shown in the file attached to this forum post.

I am not sure whats going on because this used to work fine. And it's happening across the application, not specific to 1 grid. I know that there have been 2 updates to the telerik controls since these were implemented... the most recent version prior to Q3. and Q3.

I have a link button on the commanditem bar and use the ItemCommand event for the export as:

Protected Sub RadGrid1_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGrid1.ItemCommand
COMMAND_NAME = e.CommandName

Select Case COMMAND_NAME

Case "RemoveFilters"
bResetSelections = True
Case RadGrid.ExportToExcelCommandName
Dim t As DateTime = Now()
bExport = True
Dim sHTML As String = ""
sHTML += "<div align='left' style='font-weight:bold;color:Blue;font-size:large'>Regulation Tracking System</div>"
sHTML += "<div align='left' style='font-weight:bold;color:Blue'>Regulation Records Data Dump</div>"
sHTML += "<div align='left' style='font-weight:bold;color:Blue'>" + t.ToLongDateString() + "</div>"
sHTML += "<div> </div>"
RadGrid1.MasterTableView.Caption = sHTML
RadGrid1.ExportSettings.FileName = RTS.GetFileName("RegulationRecords")
RadGrid1.ExportSettings.IgnorePaging = True
RadGrid1.ExportSettings.ExportOnlyData = True
RadGrid1.ExportSettings.OpenInNewWindow = True
RadGrid1.MasterTableView.ExportToExcel()

End Select

End Sub

25 Answers, 1 is accepted

answered on 01 Dec 2009, 09:59 PM

Hello guys,

@Mark: The so-called "dev" build is intended for our licensed customers. And the contrariwise, the "trial" build is for the trial users.
We are not ready with the depicted hotfix yet, but it will be released in the next few days as I promised.

@Nicolai: I believe I understand the situation very well and I'm glad that you found a way to overcome the limitation. Keep up the good work.

@Robert: We are constrantly trying to avoid the limitations but in some cases it is not in our power to sidestep the unwanted behavior.

Regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

answered on 02 Dec 2009, 03:53 PM

Hi, Daniel and the Telrik team. I am having trouble with exporting too. I am using a 2009 Q3 radgrid with an ajax manager. I am using the new export features in the commanditemsettings:

    
                        <CommandItemSettings 
        
                                ShowExportToWordButton="true" 
        
                                ShowExportToExcelButton="true"  
        
                                ShowExportToCsvButton="true" 
        
                                ShowExportToPdfButton="true" 
        
                                />

This worked until I put in the ajax manager. Now it's broken. The buttons look like they are there, and the alt tags pop up. However, when I click on any of the buttons, nothing happens. I tried using the information provided at this link: http://www.telerik.com/community/code-library/aspnet-ajax/general/export-radgrid-content-to-excel-word-csv-pdf-with-ajax-enabled.aspx, but it's not working. Am I naming the buttons wrong? Is there more code that I am missing?

Here's the two snippets of code I tried:
ASP attempt:

    
            <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> 
        
                    <script type="text/javascript">  
        
                        function mngRequestStarted(ajaxManager, eventArgs)  
        
                        { 
        
                            if (eventArgs.get_eventTarget().indexOf("ExportToExcelButton") != -1)  
        
                                eventArgs.set_enableAjax(false);  
        
                        }  
        
                    </script>  
        
                </telerik:RadCodeBlock> 
        
            <%--further down the line I have this code:--%> 
        
                <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" ClientEvents-OnRequestStart="mngRequestStarted"> 
        
                    <AjaxSettings> 
        
                        <telerik:AjaxSetting AjaxControlID="Button1"> 
        
                            <UpdatedControls> 
        
                                <telerik:AjaxUpdatedControl ControlID="RadGrid1"  
        
                                    LoadingPanelID="RadAjaxLoadingPanel1" /> 
        
                            </UpdatedControls> 
        
                        </telerik:AjaxSetting> 
        
                            <telerik:AjaxSetting AjaxControlID="ExportToExcelButton"> 
        
                                <UpdatedControls> 
        
                                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> 
        
                                    <telerik:AjaxUpdatedControl ControlID="ExportToExcelButton" /> 
        
                                </UpdatedControls> 
        
                            </telerik:AjaxSetting> 
        
                    </AjaxSettings> 
        
                    <ClientEvents OnRequestStart="mngRequestStarted" />

VB attempt - This happens after I bind the data to the grid:

    
                    Dim cmdItem As GridCommandItem 
        
                    cmdItem = RadGrid1.MasterTableView.GetItems(GridItemType.CommandItem)(0) 
        
                    Dim btncmd As New Button 
        
                    btncmd = cmdItem.FindControl("ExportToExcelButton") 
        
                    RadScriptManager1.RegisterPostBackControl(btncmd) 
        
                    btncmd = cmdItem.FindControl("ExportToWordButton") 
        
                    RadScriptManager1.RegisterPostBackControl(btncmd) 
        
                    btncmd = cmdItem.FindControl("ExportToCSVButton") 
        
                    RadScriptManager1.RegisterPostBackControl(btncmd) 
        
                    btncmd = cmdItem.FindControl("ExportToPDFButton") 
        
                    RadScriptManager1.RegisterPostBackControl(btncmd)

Thank you for your help in this matter. I hope you have a terrific day.

answered on 02 Dec 2009, 04:05 PM

I am not sure about the "New" method of exorting you are referring to but... You need to give your command item links the CommandName property either in the designer or as so:

<asp:LinkButton Font-Underline="true" CssClass="clink" ID="lnkExcel" runat="server" CommandName="ExportToExcel" ToolTip="Export Analyst / Author List To Excel">XLS</asp:LinkButton>

Then you need to handle the RadGrid1_ItemCommand() event and initiate the export:

Protected Sub RadGrid1_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGrid1.ItemCommand
COMMAND_NAME = e.CommandName

Select Case COMMAND_NAME

    Case RadGrid.ExportToExcelCommandName
         RadGrid1.MasterTableView.Caption = sHTML
         RadGrid1.ExportSettings.FileName = RTS.GetFileName("RegulationRecords")
         RadGrid1.ExportSettings.IgnorePaging = True
         RadGrid1.ExportSettings.ExportOnlyData = True
         RadGrid1.ExportSettings.OpenInNewWindow = True
         RadGrid1.MasterTableView.ExportToExcel()

End Select

End Sub

Accepted

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

Excel Export Problem

25 Answers, 1 is accepted