Excel.Application m_objExcel = new Application();
m_objExcel.Application.Workbooks.Add(true);
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
{
m_objExcel.Cells[1, j + 1] = ds.Tables[0].Columns[j].ColumnName;
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
{
m_objExcel.Cells[i+2, j+1] = ds.Tables[0].Rows[i][j].ToString();
}
}
m_objExcel.Visible = false;
objBook.SaveAs(FileName:=TempFile, FileFormat:=Excel.XlFileFormat.xlExcel9795)
Response.Write("<script language='javascript'>window.open('" & objReport & "')</script>")
