mvc导出excel问题，谢谢各位帮忙

2017-08-10 03:16:19 309 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

关于MVC控制器导出Excel时MemoryStream流已关闭的问题在MVC控制器导出Excel时遇到一个问题，当我关闭流时，无法导出Excel文件代码： MemoryStream ms = bll.GetOrdersExcel(info, ul, filePath,tempPath); try { { if (ms == null) 阅读详情

下面是我的通用类，请问控制器里面的action怎么写？怎么调用这个方法



  /// <summary>

        /// 将DataTable数据导出到Excel文件中(xlsx)

        /// </summary>

        /// <param name="dt"></param>

        /// <param name="file"></param>

        public static void TableToExcelForXLSX(DataTable dt, string file, string sheetName)

        {

            XSSFWorkbook xssfworkbook = new XSSFWorkbook();



            ISheet sheet = null;

            if (!string.IsNullOrEmpty(sheetName))

            {

                sheet = xssfworkbook.CreateSheet(sheetName);

            }

            else

            {

                sheet = xssfworkbook.CreateSheet("Sheet1");

            }



            //表头

            IRow row = sheet.CreateRow(0);

            for (int i = 0; i < dt.Columns.Count; i++)

            {

                ICell cell = row.CreateCell(i);

                cell.SetCellValue(dt.Columns[i].ColumnName);

            }



            //数据

            for (int i = 0; i < dt.Rows.Count; i++)

            {

                IRow row1 = sheet.CreateRow(i + 1);

                for (int j = 0; j < dt.Columns.Count; j++)

                {

                    ICell cell = row1.CreateCell(j);

                    cell.SetCellValue(dt.Rows[i][j].ToString());

                }

            }



            //转为字节数组

            MemoryStream stream = new MemoryStream();

            xssfworkbook.Write(stream);



            HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", file));

            HttpContext.Current.Response.AddHeader("Content-Length", stream.ToArray().Length.ToString());

            HttpContext.Current.Response.BinaryWrite(stream.ToArray());

            xssfworkbook = null;

            stream.Close();

            stream.Dispose();

            HttpContext.Current.Response.End();

        }