How to get sql server table data into excel using webservice

Hi Darsh,

you can put data in datatable from sql and try below method for exporting it to excel , which takes datatable as parameter:

protected void ExportToExcel(DataTable dt)

{

if (dt.Rows.Count > 0)

{

string filename = "DownloadedExcel.xls";

System.IO.StringWriter tw = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);

DataGrid dgGrid = new DataGrid();

dgGrid.DataSource = dt;

dgGrid.DataBind();

//Get the HTML for the control.

dgGrid.RenderControl(hw);

//Write the HTML back to the browser.

//Response.ContentType = application/vnd.ms-excel;

Response.ContentType = "application/vnd.ms-excel";

Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + "");

this.EnableViewState = false;

Response.Write(tw.ToString());

Response.End();

}

}

hope will help.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.