locked
Export to Excel RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi folks,

    I have written a Restful service and consuming the service using jquery. I have written a piece of code to export to excel in the restful code but when we call this service, application is not poping up the excel dialog window. but if i add this piece of code in the aspx page its work fine. How can i make this code to work inside the service. Below is the code im using

    

                GridView gv = new GridView();
            gv.DataSource =fetch();
            gv.DataBind();
            Response.ClearContent();
            Response.Buffer = true;
            Response.AddHeader("content-disposition", "attachment; filename=test.xls");
            Response.ContentType = "application/ms-excel";
            Response.Charset = "";
            StringWriter sw = new StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);
            gv.RenderControl(htw);
            Response.Output.Write(sw.ToString());
            Response.Flush();
            Response.End();

    Sunday, March 16, 2014 5:36 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Your code is configuring the HTTP response so that the header indicates that it is an excel file and the body contains the binary content of the file. When such an HTTP response is sent to a browser, the browser responds by popping up a window enquiring what it should do with that file. However, if you write the same code in a service, the response does not go to the browser, but to whatever application is calling the service. Even if it is a javascript application running inside the browser, the Response does not go to the browser, it goes to the application. Therefore, it is the responsibility of the application to parse the headers and take appropiate action. It will not happen automatically.

    Edit: You can change your javascript code so that instead of sending an ajax query to the service, it navigates to the same url where the REST service is located. In this case, the browser will pop up the file download window.

    Tuesday, March 18, 2014 3:40 PM