Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
string time = DateTime.Now.ToString("yyyyMMddHHmmss");
IList<order> info = Session["DataSource"] as IList<Orders>;
DataTable ds = new DataTable();
ds =ToDataTable(info);
StringBuilder sb = new StringBuilder();
sb.Append("客户姓名 \t");
sb.Append("手机号码 \t");
sb.Append("订单顺号 \t");
sb.Append("发货日期 \t");
sb.Append("发货类型 \t");
sb.Append("顾客支付快递费用 \t");
sb.Append("结算快递费用 \t");
sb.Append("订单店铺 \t");
sb.Append("接单人员 \t");
sb.Append("订货金额 \t");
sb.Append("客户等级 \t");
sb.Append("上传人 \t");
sb.Append("备注 \t");
sb.Append(Environment.NewLine);
long totalCount = ds.Rows.Count;
for (int i = 0; i < ds.Rows.Count; i++)
{
for (int j = 0; j < ds.Columns.Count - 6; j++)
{
sb.Append(ds.Rows[i][j].ToString() + "\t");
}
sb.Append(Environment.NewLine);
}
Response.Write(sb.ToString());
HttpContext.Current.Response.AppendHeader("Content-Disposition",
"attachment;filename=" + HttpUtility.UrlEncode(time + ".xls", System.Text.Encoding.GetEncoding("GB2312")).ToString());
Response.End();
DataTable导出Excel
最新推荐文章于 2022-06-17 13:59:55 发布