public void aa(DataSet ds)
{
string strFileName = Server.MapPath(@"Nomarl.xls");
string strSaveFileName = Server.MapPath(@"excel.xls");
Excel.Application ThisApplication = new Excel.ApplicationClass();
Excel.Workbook ThisWorkBook = null;
Excel.Worksheet ThisSheet = null;
object missing = System.Reflection.Missing.Value;
try
{
ThisWorkBook = ThisApplication.Workbooks.Open(strFileName, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
ThisApplication.Visible = false;
int count = ThisApplication.Application.Worksheets.Count;
DataRow dr = null;
System.Data.DataTable dt = ds.Tables["customers"];
for (int i =1; i < count+1; i++)
{
ThisSheet = (Excel.Worksheet)ThisWorkBook.Sheets[i];
for (int k = 0; k < dt.Rows.Count; k++)
{
dr = dt.Rows[k];
for (int j = 0; j < dt.Columns.Count; j++)
{
ThisSheet.Cells[1+k, j + 4] = dr[j].ToString();
}
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
ThisWorkBook.SaveCopyAs(HttpContext.Current.Server.MapPath(".") + "//" + "aa" + ".xls");
ThisWorkBook.Close(false, null, null);
ThisApplication.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(ThisWorkBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(ThisApplication);
ThisWorkBook = null;
ThisApplication = null;
GC.Collect();
string path = HttpContext.Current.Server.MapPath("aa" + ".xls");
System.IO.FileInfo file = new System.IO.FileInfo(path);
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Charset = "utf-8";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpContext.Current.Server.UrlEncode(file.Name));
HttpContext.Current.Response.AddHeader("Content-Length", file.Length.ToString());
HttpContext.Current.Response.ContentType = "application/ms-excel";
HttpContext.Current.Response.WriteFile(file.FullName);
HttpContext.Current.Response.End();
}