We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Exporting to Excel, Word, PDF Error

Thread ID:

Created:

Updated:

Platform:

Replies:

142391 Jan 31,2019 09:58 AM UTC Feb 1,2019 07:40 AM UTC ASP.NET Web Forms 1
loading
Tags: Grid
sengdala
Asked On January 31, 2019 09:58 AM UTC

I following the document on https://help.syncfusion.com/aspnet/grid/exporting
everything seem no problem on code, but when I clicked the export button the IIS express on VS2017 show an error like below

please help me ~ ~

HTTP Error 405.0 - Method Not Allowed

The page you are looking for cannot be displayed because an invalid method (HTTP verb) is being used.

Most likely causes:

  • The request sent to the Web server used an HTTP verb that is not allowed by the module configured to handle the request.
  • A request was sent to the server that contained an invalid HTTP verb.
  • The request is for static content and contains an HTTP verb other than GET or HEAD.
  • A request was sent to a virtual directory using the HTTP verb POST and the default document is a static file that does not support HTTP verbs other than GET or HEAD.

Things you can try:

  • Verify the list of verbs enabled for the module handler this request was sent to, and ensure that this verb should be allowed for the Web site.
  • Check the IIS log file to see which verb is not allowed for the request.
  • Check the failed request tracing logs for additional information about this error. For more information, click here.

Detailed Error Information:

Module   DefaultDocumentModule
Notification   ExecuteRequestHandler
Handler   StaticFile
Error Code   0x80070001


Attachment: example_code_af96aee2.rar

Vignesh Natarajan [Syncfusion]
Replied On February 1, 2019 07:40 AM UTC

Hi sengdala, 
 
Thanks for contacting Syncfusion support.  
 
Query: Exporting to Excel, Word, PDF Error 
 
From your query, we understand that you need to export the Grid data to excel format. From the shared sample, we could see that you have not defined the Export functions in the controller page. Due to this the reported issue will occur.  
 
To export the Grid, server side must be configured using any of the available web services, since you have use webAPI controller. We suggest you to refer the below UG documentation how to configure the WebAPi controller for exporting 
 
 
For your convenience we have modified the provided sample, please refer the below code and sample link, 
 
 
var dm = ej.DataManager({ 
            url: "/api/Orders/GetOrders", 
            adaptor: new ej.UrlAdaptor(), 
            enableCaching: false, 
            cachingPageSize: 10, 
            timeTillExpiration: 120000 
        }); 
 
        $("#Grid1").ejGrid({ 
            dataSource: dm, 
              …………….. 
            toolbarSettings: { 
                showToolbar: true, toolbarItems: ['search', ej.Grid.ToolBarItems.ExcelExport, ej.Grid.ToolBarItems.WordExport, ej.Grid.ToolBarItems.PdfExport] 
            }, 
            toolbarClick: function (args) { 
                if (args.itemName == "Excel Export") { 
                    this.export("/api/Orders/ExcelExport"); 
                    args.cancel = true; 
                } 
                else if (args.itemName == "Word Export") { 
                    this.export("/api/Orders/WordExport"); 
                    args.cancel = true; 
                } 
                else if (args.itemName == "PDF Export") { 
                    this.export("/api/Orders/PdfExport"); 
                    args.cancel = true; 
                } 
            }, 
            columns: [ 
                  …………….. 
            ] 
        }); 
 
    </script> 
 
Controller Page 
 
        <ActionName("ExcelExport")> 
        <HttpPost> 
        Public Sub ExcelExport() 
            Dim exp As ExcelExport = New ExcelExport() 
            Dim gridModel As String = HttpContext.Current.Request.Params("GridModel") 
            Dim obj As GridProperties = CType(Syncfusion.JavaScript.Utils.DeserializeToModel(GetType(GridProperties), gridModel), GridProperties) 
            Dim Db As NORTHWNDEntities = New NORTHWNDEntities() 
            Dim result = Db.Orders.ToList() 
            Dim excelExp As GridExcelExport = New GridExcelExport() 
            excelExp.FileName = "Export.xlsx" 
            excelExp.Excelversion = ExcelVersion.Excel2010 
            excelExp.Theme = "flat-saffron" 
            exp.Export(obj, result, excelExp) 
        End Sub 
 
        <ActionName("WordExport")> 
        <HttpPost> 
        Public Sub WordExport() 
            Dim exp As WordExport = New WordExport() 
            Dim gridModel As String = HttpContext.Current.Request.Params("GridModel") 
            Dim obj As GridProperties = CType(Syncfusion.JavaScript.Utils.DeserializeToModel(GetType(GridProperties), gridModel), GridProperties) 
            Dim Db As NORTHWNDEntities = New NORTHWNDEntities() 
            Dim result = Db.Orders.ToList() 
            Dim WordExp As GridWordExport = New GridWordExport() 
            WordExp.FileName = "Export.docx" 
            WordExp.Theme = "flat-saffron" 
            exp.Export(obj, result, WordExp) 
        End Sub 
 
        <ActionName("PdfExport")> 
        <HttpPost> 
        Public Sub PdfExport() 
            Dim exp As PdfExport = New PdfExport() 
            Dim gridModel As String = HttpContext.Current.Request.Params("GridModel") 
            Dim obj As GridProperties = CType(Syncfusion.JavaScript.Utils.DeserializeToModel(GetType(GridProperties), gridModel), GridProperties) 
            Dim Db As NORTHWNDEntities = New NORTHWNDEntities() 
            Dim result = Db.Orders.ToList() 
            Dim PdfExp As GridPdfExport = New GridPdfExport() 
            PdfExp.FileName = "Export.pdf" 
            PdfExp.Theme = "flat-saffron" 
            exp.Export(obj, result, PdfExp) 
        End Sub 
 
 
 
For your convenience we have attached the sample which can be downloaded from below link 
 
 
Please get back to us if you have further queries. 
 
Regards, 
Manivannan Padmanaban. 
 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon