from datagrid to excel table

[Syd]

Hi all,
Is there a way to get data from a datagrid and send to an excel table?And if
it is possible how can arranged the excel table...
Thanks

[Rahul Anand]

"Syd" wrote:

Hi all,
Is there a way to get data from a datagrid and send to an excel table?And if
it is possible how can arranged the excel table...
Thanks

Exporting data to Excel file is pretty simple. You just need to add few
headers. The DataGrid can be saved and opened with MS Excel or you can
directly open it in the browser as per your requirement.

<CODE>
Response.Clear();
// Content-disposition causes force download
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.No Cache);
Response.ContentType = "application/vnd.xls";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

myDataGrid.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
</CODE>

Find more information at:
http://www.codeproject.com/aspnet/DA...ortToExcel.asp

Hope it will help.

--
Cheers,
Rahul Anand

[Rahul Anand]

"Rahul Anand" wrote:

"Syd" wrote:

Hi all,
Is there a way to get data from a datagrid and send to an excel table?And if
it is possible how can arranged the excel table...
Thanks

Exporting data to Excel file is pretty simple. You just need to add few
headers. The DataGrid can be saved and opened with MS Excel or you can
directly open it in the browser as per your requirement.

<CODE>
Response.Clear();
// Content-disposition causes force download
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.No Cache);
Response.ContentType = "application/vnd.xls";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

myDataGrid.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
</CODE>

Find more information at:
http://www.codeproject.com/aspnet/DA...ortToExcel.asp

Hope it will help.

--
Cheers,
Rahul Anand

Just to add: the solution suggested above just saves the datagrid as HTML
Table and MS Excel application is intelligent enough to render the generated
HTML Table.

--
Cheers,
Rahul Anand

[Syd]

I think it works in ASP,Is there a other way??

"Rahul Anand" wrote:

"Rahul Anand" wrote:

"Syd" wrote:

Hi all,
Is there a way to get data from a datagrid and send to an excel table?And if
it is possible how can arranged the excel table...
Thanks

Exporting data to Excel file is pretty simple. You just need to add few
headers. The DataGrid can be saved and opened with MS Excel or you can
directly open it in the browser as per your requirement.

<CODE>
Response.Clear();
// Content-disposition causes force download
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.No Cache);
Response.ContentType = "application/vnd.xls";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

myDataGrid.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
</CODE>

Find more information at:
http://www.codeproject.com/aspnet/DA...ortToExcel.asp

Hope it will help.

--
Cheers,
Rahul Anand

Just to add: the solution suggested above just saves the datagrid as HTML
Table and MS Excel application is intelligent enough to render the generated
HTML Table.

--
Cheers,
Rahul Anand