c#將資料匯出到excel中

標籤：http   io   ar   os   sp   for   資料   on   bs   

DataTable   dt = new BLL.T_Expiry().GetAllList().Tables[0];//查詢資料

string FileName = "T_Users.xls";

HttpResponse response = Page.Response;

response.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);
Response.ContentType = "application/ms-excel";
response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");

foreach (DataColumn dc in dt.Columns)
{
response.Write(dc.ColumnName + "\t");
}

response.Write("\n");

foreach (DataRow dr in dt.Rows)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
response.Write(dr[i].ToString() + "\t");
}

response.Write("\n");
}

response.End();

c#將資料匯出到excel中