本文共 2657 字，大约阅读时间需要 8 分钟。

前言

Controller

//添加引用using System.IO;using System.Web.Script.Serialization;using System.Data;using System.Text;using NPOI;using NPOI.HPSF;using NPOI.HSSF;using NPOI.HSSF.UserModel;using NPOI.SS.UserModel; public  void OutoExcel()        {            string title = "仓库信息统计";            NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();            NPOI.SS.UserModel.ISheet sheet = book.CreateSheet("Sheet1");            NPOI.SS.UserModel.IRow headerrow = sheet.CreateRow(0);            ICellStyle style = book.CreateCellStyle();            style.Alignment = HorizontalAlignment.Center;            style.VerticalAlignment = VerticalAlignment.Center;            #region 设置表格标题，表头            ICell cell = headerrow.CreateCell(0);            cell.CellStyle = style;            cell.SetCellValue("库房编号");            cell = headerrow.CreateCell(1);            cell.CellStyle = style;            cell.SetCellValue("库房名称");            cell = headerrow.CreateCell(2);            cell.CellStyle = style;            cell.SetCellValue("库房位置");            cell = headerrow.CreateCell(3);            cell.CellStyle = style;            cell.SetCellValue("库房面积");            cell = headerrow.CreateCell(4);            cell.CellStyle = style;            cell.SetCellValue("备注");            #endregion            #region 根据标题for循环填充Excel表格            for (int i = 0; i < list.Count; i++)            {                IRow row = sheet.CreateRow(i + 1);                cell = row.CreateCell(0);                cell.SetCellValue(list[i].storageID.ToString());                cell = row.CreateCell(1);                cell.SetCellValue(list[i].storageName.ToString());                cell = row.CreateCell(2);                cell.SetCellValue(list[i].place.ToString());                cell = row.CreateCell(3);                cell.SetCellValue(list[i].capacity.ToString());                cell = row.CreateCell(4);                cell.SetCellValue(list[i].remark.ToString() == "null" ? "" : list[i].remark.ToString());//总是出错，干脆来个空！！！            }            #endregion            #region 弹出导出的界面            MemoryStream ms = new MemoryStream();            book.Write(ms);            Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xls", title + "_" + DateTime.Now.ToString("yyyy-MM-dd"), System.Text.Encoding.UTF8));            Response.BinaryWrite(ms.ToArray());            Response.End();            book = null;            ms.Close();            ms.Dispose();            #endregion        }

JS

//导出仓库Excel表格function xport() {
       window.location.href = "/Storage/OutoExcel";}

总结

转载地址：https://blog.csdn.net/j15533415886/article/details/79215108 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！