导出

public ActionResult daochu()
{
var dt = bll.showlist();

if (dt != null || dt.Count > 0)
{

HSSFWorkbook book = new HSSFWorkbook();
ISheet sheet = book.CreateSheet("sheet1");
IRow rows = sheet.CreateRow(0);

rows.CreateCell(0).SetCellValue("ID");
rows.CreateCell(1).SetCellValue("Name");
rows.CreateCell(2).SetCellValue("Typeinfo");
rows.CreateCell(3).SetCellValue("SCName");
rows.CreateCell(4).SetCellValue("Newtime");

for (int i = 0; i < dt.Count; i++)
{
IRow row = sheet.CreateRow(i + 1);
row.CreateCell(0).SetCellValue(dt[i].ID);
row.CreateCell(1).SetCellValue(dt[i].Name);
row.CreateCell(2).SetCellValue(dt[i].Typeinfo);
row.CreateCell(3).SetCellValue(dt[i].SCName);
row.CreateCell(4).SetCellValue(dt[i].Newtime);
}

MemoryStream me = new MemoryStream();
book.Write(me);
me.Seek(0, SeekOrigin.Begin);
return File(me, "qpplication/ved-excel", "导出信息.xls");
}
else
{
MemoryStream me = new MemoryStream();

me.Seek(0, SeekOrigin.Begin);
return File(me, "qpplication/ved-excel", "导出信息.xls");
}
}

转载于:https://www.cnblogs.com/shenghuotaiai/p/7827851.html