1

2

DataTable dt = wad.GetToExcel(lblcode.Text);
3

StringWriter sw = new StringWriter();
4

5

sw.WriteLine("代号,货品编码,货品名称,单位,净需求量,采购量,供应商,下单日期,到货日期,采购员,报关,状态,采购订单号");
6

foreach (DataRow item in dt.Rows)
7

{
8

//string state = (OPSState)Convert.ToInt32(item["imgstate"]);
9

sw.WriteLine(item["code"] + "," + item["goodscode"] + "," +
10

item["goodsname"] + "," + item["unit"] + "," +
11

item["netdemand"] + "," + item["shoppingnum"] + "," +
12

item["tradername"] + "," + item["orderdate"] + "," +
13

item["arrivaldate"] + "," + item["buyername"] + "," +
14

item["ifcustoms"] + "," + (OPSState)Convert.ToInt32(item["imgstate"]) + "," +
15

item["ordercode"] );
16

}
17

Response.AddHeader("Content-Disposition", "attachment; filename=test.csv");
18

Response.ContentType = "application/ms-excel";
19

Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
20

Response.Write(sw);
21

sw.Close();
22

Response.End();

ITPub博客

导出到Excel的操作