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

EXCEL Export Problem - RegisterRequiresViewStateEncryption()

6 Answers 158 Views

Grid

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

Shawn asked on 12 Mar 2009, 06:23 PM

I am not sure why this is happening, but it ONLY happens when exporting to Excel. I have this same export functionality on other pages that work fine, for some reason this page doesn't like it and I am not sure why.

I specify the file name and format on the grid itself and then simply have these buttons:

    
            <asp:ImageButton ID="btn_ExportCSV" runat="server" 
        
                            OnClick="btn_ExportCSV_Click" BorderColor="#F0A54E"  
        
                            BorderStyle="Ridge"  
        
                            ImageUrl="~/images/export_csv.jpg" />&nbsp;&nbsp;&nbsp;&nbsp; 
        
                        <asp:ImageButton ID="btn_ExportEXCEL" runat="server" 
        
                            OnClick="btn_ExportEXCEL_Click" BorderColor="#F0A54E"  
        
                            BorderStyle="Ridge"  
        
                            ImageUrl="~/images/export_excel.jpg" />&nbsp;&nbsp;&nbsp;&nbsp; 
        
                        <asp:ImageButton ID="btn_ExportWORD" runat="server" 
        
                            OnClick="btn_ExportWORD_Click" BorderColor="#F0A54E"  
        
                            BorderStyle="Ridge"  
        
                            ImageUrl="~/images/export_word.jpg" />

    
             Protected Sub btn_ExportEXCEL_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_ExportEXCEL.Click 
        
                    ConfigureExport() 
        
                    grid_applications.MasterTableView.ExportToExcel() 
        
                End Sub 
        
                Protected Sub btn_ExportWORD_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_ExportWORD.Click 
        
                    ConfigureExport() 
        
                    grid_applications.MasterTableView.ExportToWord() 
        
                End Sub 
        
                Protected Sub btn_ExportCSV_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_ExportCSV.Click 
        
                    ConfigureExport() 
        
                    grid_applications.MasterTableView.ExportToCSV() 
        
                End Sub 
        
                Public Sub ConfigureExport() 
        
                    For x = 2 To 22 'display only columns I want 
        
                        grid_applications.MasterTableView.Columns(x).Visible = True 
        
                    Next 
        
                End Sub

When I click CSV or WORD it works fine. When i click Excel Export I get:

The RegisterRequiresViewStateEncryption() method needs to be called before or during Page_PreRender.

Line 131: BorderStyle="Ridge" Line 132: ImageUrl="~/images/export_word.jpg" /> Line 133:<telerik:RadGrid ID="grid_applications" runat="server" DataSourceID="sqlds_Applications" Line 134: GridLines="None" Width="1100px" AllowFilteringByColumn="True" Line 135: AllowPaging="True" AllowSorting="True" PageSize="30" ShowGroupPanel="True">

6 Answers, 1 is accepted

Accepted

answered on 16 Mar 2009, 01:41 PM

example.zip

Hi Shawn,

Attached to this message is a small runnable application with the implementation request by you.
Give it a try and see if it works for you.

For additional information about The RegisterRequiresViewStateEncryption() method needs to be called before or during Page_PreRender error, please refer to this forum.

Best wishes,
Yavor
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.

answered on 16 Apr 2010, 04:37 AM

i exactly have the same problem (just for csv - not word or excel)
but the upper answer did not help to get a solution...
i have many radgrids in my pages and they are working perfectly , but i do not know what's the matter about this one ->
i really really do not want to replace it beacause of many works on it
how can i fix this problem?
i am using vs 2008 asp.net web app with c#
thanks a lot

my codes(for export) and my radgrid configuration are correct ...i test them and i finally found the reason of this pro ...
in my radgrid i have three TabStribs (in NestedTemplateView) and in one of them i have a little default vs gridview...
when i remove this gridview problem disappears...
how cani fix this?