添加NPOI包

在這里插入圖片描述

將數據導出Excel實現

  public async Task<bool> ExportPatientStatisticsDetails(ExportPatientDetailDto patientDetails)
        {
            try
            {
                var patientList = patientDetails.PatientTableList;
                HSSFWorkbook workbook = new HSSFWorkbook();
                //創(chuàng)建工作表
                var sheet = workbook.CreateSheet("患者統(tǒng)計表");
                //創(chuàng)建標題行
                var row = sheet.CreateRow(0);
                //創(chuàng)建單元格
                var cellName = row.CreateCell(0);
                cellName.SetCellValue("部位");
                var cellNumber = row.CreateCell(1);
                cellNumber.SetCellValue("患者數");
                var cellPortion = row.CreateCell(2);
                cellPortion.SetCellValue("比例");
                //遍歷集合，生成行
                int index = 1;
                for (int i = 0; i < patientList.Count(); i++)
                {
                    var x = index + i;
                    var rowi = sheet.CreateRow(x);
                    var cell1 = rowi.CreateCell(0);
                    cell1.SetCellValue(patientList[i].NameOfDistributionType);
                    var cell2 = rowi.CreateCell(1);
                    cell2.SetCellValue(patientList[i].NumberOfPatients);
                    var cell3 = rowi.CreateCell(2);
                    cell3.SetCellValue(patientList[i].Proportion);
                }

                if (File.Exists(@"D:\患者統(tǒng)計表.xls"))
                {
                   File.Delete(@"D:\患者統(tǒng)計表.xls");
                }
                FileStream file = new FileStream(@"D:\患者統(tǒng)計表.xls", FileMode.CreateNew, FileAccess.Write);
                workbook.Write(file);
                file.Dispose();
                return true;

            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                return false;
            }
           
        }