c#将数据导出到excel中

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();

转载于:https://www.cnblogs.com/apes-monkeys/p/4088894.html