项目中添加ExcelModel文件夹存放Excel模版文件,添加SingleExport文件夹存放下载文件。
首先定义文件下载类:
导出事件:
List<TouBiaoRenDO> list = ViewState["touBiaoRenList"] as List<TouBiaoRenDO>;
if (list.Count > 0)
{
string filePath = Server.MapPath("~/");
FileStream file = new FileStream(@filePath + "ExcelModel/TouBiaoRenList.xls", FileMode.Open, FileAccess.ReadWrite);
HSSFWorkbook hssfworkbook = new HSSFWorkbook(file);
HSSFSheet sheet1 = hssfworkbook.GetSheet("sheet1");
for (int i = 0; i < list.Count; i++)
{
TouBiaoRenDO ExcelDO = list[i] as TouBiaoRenDO;
sheet1.CreateRow(i + 2).CreateCell(0).SetCellValue((i + 1).ToString());
sheet1.CreateRow(i + 2).CreateCell(1).SetCellValue(ExcelDO.UserName);
sheet1.CreateRow(i + 2).CreateCell(2).SetCellValue(ExcelDO.MiFeng);
sheet1.CreateRow(i + 2).CreateCell(3).SetCellValue(ExcelDO.BaoZhengJin.ToString());
sheet1.CreateRow(i + 2).CreateCell(4).SetCellValue(ExcelDO.BaoJia.ToString());
sheet1.CreateRow(i + 2).CreateCell(5).SetCellValue(ExcelDO.XMFei.ToString());
sheet1.CreateRow(i + 2).CreateCell(6).SetCellValue(ExcelDO.ChengNuo);
sheet1.CreateRow(i + 2).CreateCell(7).SetCellValue(ExcelDO.GongQi.ToString());
sheet1.CreateRow(i + 2).CreateCell(8).SetCellValue(ExcelDO.BeiZhu);
}
sheet1.ForceFormulaRecalculation = true;
string fileName = DateTime.Now.ToString("yyyyMMddHHmmfff") + "_" + "投标人列表.xls";
string path = @filePath + "SingleExport/" + fileName;
FileStream newFile = new FileStream(path, FileMode.OpenOrCreate);
hssfworkbook.Write(newFile);
newFile.Close();
CommTool.ResponseFile(HttpContext.Current.Request, HttpContext.Current.Response, fileName, path, 102400);
}