I am binding data of table to grid. Now data is showing perfectly in the datagrid. I want to export this data in excel file. Is it possible to export grid data into excel file or word file?

yes the following code wil helps you

private void Page_Load(object sender, System.EventArgs e)

{

// Put user code to initialize the page here

//Bind the DataGrid to DataSet

DataGridToExcel (DataGrid1, Response);

}

protected void DataGridToExcel(DataGrid dGridExport , HttpResponse httpResp)

{

httpResp.Clear();

httpResp.Charset = "";

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

StringWriter stringWrite = new StringWriter();

HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

DataGrid dGrid = new DataGrid();

dGrid = dGridExport;

dGrid.HeaderStyle.Font.Bold = true;

dGrid.DataBind();

dGrid.RenderControl(htmlWrite);

httpResp.Write(stringWrite.ToString());

httpResp.End();

}


Allah Bless on you

I have got the code but can you explain what for this is?

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

I am sorry to bother you but will it work on hosting server too?

http is protocole httpResp.ContentType define the page content type.

httpResp.ContentType

ok

ALLAH bless on you

Hello
I used this procedure to generate an Excel file since three different functions. For two of these functions, the result is right. But for one of these functions each line of data is duplicated (two lines for each record).
Is there somebody who had this problem?
Do you have the idea of what could have involved this error?
How can I correct this?
Many thinks.