1.導出到Excel

導出到Excel
?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();

?

轉載于:https://www.cnblogs.com/yuiely/archive/2009/11/06/1597221.html

總結

以上是生活随笔為你收集整理的导出到Excel的操作的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。