当前位置： 移动技术网 > IT编程>开发语言>.net > .NET Core 通过EPPlus批量导出

.NET Core 通过EPPlus批量导出

2018年07月05日  | 移动技术网IT编程  | 我要评论

7.11ufo事件,牛星丽,我的淘气王子演员表

前台代码：

前台代码是在.net core bootstrap集成框架上的（这是效果浏览地址：），首先是添加Nuget包，

 <button id="btnExport" type="button" class="btn btn-info " onclick="exportModel()"><i class="fa fa-paste"></i> 导出Excel</button>





 function exportModel() { //导出
            var delDatas = JucheapGrid.GetDataTableDeleteData();
            if (delDatas.Len > 0 && delDatas.Data.length > 0) {
                if (confirm("确认要导出这" + delDatas.Len + "条数据？")) {
  
                        //  delDatas.Data  传入的id值                                           
                    window.location.href = "/***/***?id=" + delDatas.Data;
                }
            } else {
                alert("请选择要导出的数据！");
            }
        }

　　下面就是控制器代码：

   #region 导出Excel.xlsx文件
        public IActionResult ExportText()
        {

            string sWebRootFolder = _hostingEnvironment.WebRootPath;
            string sFileName = $"{DateTime.Now.ToString("yyyyMMddHHmmssfff")}.xlsx";
            FileInfo file = new FileInfo(Path.Combine(sWebRootFolder, sFileName));
            if (file.Exists)
            {
                file.Delete();
                file = new FileInfo(Path.Combine(sWebRootFolder, sFileName));
            }
            using (ExcelPackage package = new ExcelPackage(file))
            {
               string str = Request.Query["id"];//获取传过来的id
                String[] str1 = str.Split(",");
                long[] ids = new long[str1.Length];
                for (int i = 0; i < str1.Length; i++)
                {
                    ids[i] = long.Parse(str1[i]);//装成long数组
                }
             //根据id在数据库获取集合
                IList<FeedbackDto> collection = _usermanagementservice.GetExportAsync(ids);
                // 添加worksheet
                ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("意见反馈列表");
                worksheet.Cells[1, 1].Value = "***";//这的*号表示的是导出后列的名称
                worksheet.Cells[1, 2].Value = "***";
                worksheet.Cells[1, 3].Value = "***";
                worksheet.Cells[1, 4].Value = "*** ";
                worksheet.Cells[1, 5].Value = "***";
                worksheet.Cells[1, 6].Value = "***";
                worksheet.Cells[1, 7].Value = "***";
                worksheet.Cells[1, 8].Value = "***";
                worksheet.Cells[1, 1].Style.Font.Bold = true;
                worksheet.Cells[1, 2].Style.Font.Bold = true;
                worksheet.Cells[1, 3].Style.Font.Bold = true;
                worksheet.Cells[1, 4].Style.Font.Bold = true;
                worksheet.Cells[1, 5].Style.Font.Bold = true;
                worksheet.Cells[1, 6].Style.Font.Bold = true;
                worksheet.Cells[1, 7].Style.Font.Bold = true;
                worksheet.Cells[1, 8].Style.Font.Bold = true;
                for (int i = 0; i < collection.Count; i++)
                {
                    worksheet.Cells[2 + i, 1].Value = collection[i].*;//这的*是字段名
                    worksheet.Cells[2 + i, 2].Value = collection[i].*;
                    worksheet.Cells[2 + i, 3].Value = collection[i].*;
                    worksheet.Cells[2 + i, 4].Value = collection[i].*;
                    worksheet.Cells[2 + i, 5].Value = collection[i].*;
                    worksheet.Cells[2 + i, 6].Value = collection[i].*;
                    worksheet.Cells[2 + i, 7].Value = collection[i].CreateTime.ToString();//日期tostring一下，不然是乱的
                    worksheet.Cells[2 + i, 8].Value = collection[i].UpdateTime.ToString();
                }
                package.Save();

            }
           
            return File(sFileName, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", sFileName);
        }

　　新手代码，大神勿喷，

您可能感兴趣的文章:

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网