.net下载excel

[wxl19900320]

string FileName = string.Format("批量发货单{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"), new Random().Next(9999));
string modelPath = httpContext.Server.MapPath("/") + ConfigurationManager.AppSettings["BatchDeliveryPath"].ToString();//批量发货模版
FileStream file = new FileStream(modelPath, FileMode.Open, FileAccess.Read);
HSSFWorkbook book = new HSSFWorkbook(file);
var sheet1 = book.GetSheet("Sheet1");
MemoryStream ms = new MemoryStream();//

for (var i = 0; i < Dt.Rows.Count; i++)
{
var row = sheet1.GetRow(i + 2);
row.CreateCell(0).SetCellValue(Dt.Rows[i]["NO"].ToString());
row.CreateCell(3).SetCellValue(Dt.Rows[i]["logistics_no"].ToString());
row.CreateCell(4).SetCellValue(Dt.Rows[i]["NAME"].ToString());
row.CreateCell(5).SetCellValue(Dt.Rows[i]["spec"].ToString());
row.CreateCell(6).SetCellValue(Dt.Rows[i]["create_time"].ToString());
row.CreateCell(7).SetCellValue(Dt.Rows[i]["email"].ToString() == Dt.Rows[i]["mobile"].ToString();
row.CreateCell(8).SetCellValue(Dt.Rows[i]["recipient"].ToString());
row.CreateCell(9).SetCellValue(Dt.Rows[i]["address"].ToString());
row.CreateCell(10).SetCellValue(Dt.Rows[i]["zip_code"].ToString());
row.CreateCell(11).SetCellValue(Dt.Rows[i]["phone"].ToString());
row.CreateCell(12).SetCellValue(Dt.Rows[i]["ID"].ToString());
row.CreateCell(13).SetCellValue(Dt.Rows[i]["product_id"].ToString());
}

book.Write(ms);

　　　 Response.AddHeader("Content-Disposition", string.Format("attachment; filename=" + FileName + ".xls"));
Response.BinaryWrite(ms.ToArray());

[於黾]

看看这个,完整例子 不要根据网上的只言片语拼凑代码

[i疾风]

什么情况都不说，就甩段代码，再看看结贴率，搞得好像必须帮一样，真是胃疼的存在

[huiyaosoft]

引用 2 楼 qq283426694 的回复:

什么情况都不说，就甩段代码，再看看结贴率，搞得好像必须帮一样，真是胃疼的存在

[takpod]

刚好也要~~~