将数据表导出到Excel文件

使用此代码…

    dt = city.GetAllCity();//your datatable    string attachment = "attachment; filename=city.xls";    Response.ClearContent();    Response.AddHeader("content-disposition", attachment);    Response.ContentType = "application/vnd.ms-excel";    string tab = "";    foreach (DataColumn dc in dt.Columns)    {        Response.Write(tab + dc.ColumnName);        tab = "t";    }    Response.Write("n");    int i;    foreach (DataRow dr in dt.Rows)    {        tab = "";        for (i = 0; i < dt.Columns.Count; i++)        { Response.Write(tab + dr[i].ToString()); tab = "t";        }        Response.Write("n");    }    Response.End();