public FileResult Export()
{
var data = db.QuerySet<SelfProvidedWellDanWeiInfoTable>().ToList();
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1");
NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0);
row1.CreateCell(0).SetCellValue("ID");
row1.CreateCell(1).SetCellValue("名称");
for (int i = 0; i < data.Count; i++)
{
NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1);
rowtemp.CreateCell(0).SetCellValue(data[i].Id.ToString());
rowtemp.CreateCell(1).SetCellValue(data[i].Name.ToString());
}
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
DateTime time = DateTime.Now;
string Time = time.ToString("yyMMddHHmmssfff");
string fileName = "Excel" + Time + ".xls";
return File(ms, "application/vnd.ms-excel", fileName);
}
function ExportExcel()
{
window.location.href = "@Url.Action("Export")";
}
//HTML
<button type="button" class="define" onclick="ExportExcel()">导出</button>