c# 使用数据流的方式下载Excel

/// <summary>
        /// 导出excel模板  2020年4月28日18:18:18  dennyhui
        /// </summary>
        /// <param name="entityid">实体ID</param>
        /// <returns></returns>
        public byte[] OutputExcel(string entityid)
        {
            try
            {
                NPOI.SS.UserModel.IWorkbook workbook = new NPOI.XSSF.UserModel.XSSFWorkbook();
                NPOI.SS.UserModel.ISheet sheet = workbook.CreateSheet("sheet");
                IRow Title = sheet.CreateRow(0);
                var attributeColumn = _dbContext.system_attribute.Where(e => e.EntityID.ToString() == entityid).ToList();
                for (int i = 0; i < attributeColumn.Count; i++)
                {
                    Title.CreateCell(i).SetCellValue(attributeColumn[i].DisplayName.ToString() == "" ? attributeColumn[i].Name : attributeColumn[i].DisplayName);
                }
                byte[] buffer = new byte[1024 * 5];
                using (MemoryStream ms = new MemoryStream())
                {
                    workbook.Write(ms);
                    //ms.Flush();
                    //ms.Position=0;
                    buffer = ms.ToArray();
                    ms.Close();
                }
                return buffer;
            }
            catch (Exception ex)
            {
                this._logger.LogError($@"OutputExcel，错误描述：{ex}");
                return null;
            }
            
        }

控制器：

        /// <summary>
        /// 导出Excel文件  2020年4月30日14:50:08  DennyHui
        /// </summary>
        /// <returns></returns>
        public FileResult OutputExcel() {
            string entityid = Request.Query["entityID"].FirstOrDefault();
            var result = _masterdatamanage.OutputExcel(entityid);
            return File(result, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "UploadTemplate.xlsx");
        }

更多文章请扫码关注公众号，有问题的小伙伴也可以在公众号上提出。