.net core 替换word、excel模板内容并导出

需要在NuGet搜索DotNetCore.NPOI并安装；

word替换方式

 public async Task<FileResult> DownLoadFile()
        {
            var entity = "";//这里换成自己的实体
            string webRootPath = _hostingEnvironment.WebRootPath;
            var FullSourcePath = webRootPath + TemplatePath;
            FileStream fileStream = new FileStream(FullSourcePath, FileMode.Open, FileAccess.Read);
            XWPFDocument myDoc = new XWPFDocument(fileStream);
            //遍历段落，替换内容
            foreach (var para in myDoc.Paragraphs)
            {
                ReplaceKey(entity, para);
            }

            // 遍历table，替换单元格内容
            foreach (var table in myDoc.Tables)
            {
                foreach (var row in table.Rows)
                {
                    foreach (var cell in row.GetTableCells())
                    {
                        foreach (var para in cell.Paragraphs)
                        {
                            ReplaceKey(entity, para);
                        }
                    }
                }
            }
            byte[] buffer = new byte[1024 * 5];
            using (MemoryStream ms = new MemoryStream())
            {
                myDoc.Write(ms);
                buffer = ms.GetBuffer();
                ms.Close();
            }
            return File(buffer, "application/msword", "文件名.docx");
        }

     
        private void ReplaceKey<T>(T etity, XWPFParagraph para)
        {
            Type entityType = typeof(T);
            PropertyInfo[] properties = entityType.GetProperties();
            string entityName = entityType.Name;//实体类名称
            string paratext = para.ParagraphText;
            var runs = para.Runs;
            string styleid = para.Style;
            string text = "";
            foreach (var run in runs)
            {
                text = run.ToString();
                foreach (var p in properties)
                {
                    string propteryName = "{" + p.Name + "}";//Word模板中设定的需要替换的标签
                    object value = p.GetValue(etity);
                    if (value == null)
                    {
                        value = "";
                    }
                    if (text.Contains(propteryName))
                    {
                        var v = value.ToString();

                        text = text.Replace(propteryName, v);
                    }
                    run.SetText(text);
                }
            }
        }

 

excel替换方式

  public async Task<FileResult> DownLoadFile()
        {
            var entity = "";//实体
            string webRootPath = _hostingEnvironment.WebRootPath;
            var FullSourcePath = webRootPath + TemplatePath;
            FileStream fs = new FileStream(FullSourcePath, FileMode.Open, FileAccess.Read);
            IWorkbook workbook = WorkbookFactory.Create(fs);
            ISheet sheet = workbook.GetSheetAt(0);
            IRow firstRow = sheet.GetRow(0);
            int cellCount = firstRow.LastCellNum;
            int rowCount = sheet.LastRowNum;
            for (int i = 0; i < rowCount; i++)
            {
                IRow row = sheet.GetRow(i);
                for (int j = 0; j < cellCount; j++)
                {
                    NPOI.SS.UserModel.ICell cell = row.GetCell(j);
                    ReplaceExcelKey(entity, cell);
                }
            }
            byte[] buffer = new byte[1024 * 5];
            using (MemoryStream ms = new MemoryStream())
            {
                workbook.Write(ms);
                buffer = ms.GetBuffer();
                ms.Close();
            }
            return File(buffer, "application/ms-excel", "文件名.xlsx");
        }


        private void ReplaceExcelKey<T>(T etity, NPOI.SS.UserModel.ICell cell)
        {
            Type entityType = typeof(T);
            PropertyInfo[] properties = entityType.GetProperties();
            if (cell != null)
            {
                var text = "";
                if (cell.CellType == CellType.String)//这里根据不同的类型进行不同的处理
                {
                    text = cell.ToString();
                }
                if (text != "")
                {
                    foreach (var p in properties)
                    {
                        string propteryName = "{" + p.Name + "}";
                        object value = p.GetValue(etity);
                        if (value == null)
                        {
                            value = "";
                        }
                        if (text.Contains(propteryName))
                        {
                            var v = value.ToString();
                            text = text.Replace(propteryName, v);
                        }
                        cell.SetCellValue(text);
                    }
                }

            }
        }