Save an Excel file, created from a DataGrid, programmatically..

Hi,

I need to Save my Excel File which I created from a DataGrid to my Hard Drive(C:\) using the C#.NET codes. It can be saved by the dialog box but I don't need that....I need the prior..

SomeOne Please Help Me....

Thanks

Tapas Mahata

Code Sample :

public void ExportToSpreadsheet(DataGrid dg, string name)
{

Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=" + name);
Response.ContentType = "application/excel";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
dg.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();


}

tapasmahata