需求
按数据层级生成word文件,要有目录,目录里要有真实的页码,附件内容用表格显示,大标题 做为封面当独显示一页,
pdf内容
大标题,
目录(里有对应的页码)
正文 里有 表格
重点:npoi 在生成word文件时不会自动生成总页数,所以本人使用了一个固定行索引来计算页码的功能。 使用 12 号字体,一页是44行,按这个方法计算页码。有更好的方法可以在评论区告诉我。
表格使用方法也要注意
1.注意 createtable()方法里会默认添加一行,这时如果使用 table.createrow() 方法创建新行这时就会有两行。第一行为只有一个默认的单元格。所有正确的方法是使用table.getrow(0)方法
2.注意 table.createrow()方法也会默认添一列,由于第一行已确定了表格的列数所要直接使用getcell(0)方法获取列对象,0表示列索引 addnewtablecell()方法会在第一行的列数上再加列,所以正确的用法是getcell(0)方法
代码
/// <summary> /// 生成报告详情文件 pdf /// </summary> /// <param name="model"></param> /// <param name="casedetailsviewmodels"></param> /// <param name="targetpath">目录路径</param> /// <param name="newfilename">文件名</param> /// <returns></returns> private static string generatewordfile(viewmodel model, list<detailsviewmodel> detailsviewmodels, string targetpath, string newfilename) { string outmergefile = targetpath + newfilename; int rowindex = 0;//行索引 //todo:使用filestream文件流来写入数据(传入参数为:文件所在路径,对文件的操作方式,对文件内数据的操作) //通过使用文件流,创建文件流对象,向文件流中写入内容,并保存为word文档格式 using (var stream = new filestream(outmergefile, filemode.create, fileaccess.write)) { //创建document文档对象对象实例 xwpfdocument document = new xwpfdocument(); /** *这里我通过设置公共的word文档中setparagraph(段落)实例创建和段落样式格式设置,大大减少了代码的冗余, * 避免每使用一个段落而去创建一次段落实例和设置段落的基本样式 *(如下,paragraphinstancesetting为段落实例创建和样式设置,后面索引表示为当前是第几行段落,索引从0开始) */ //12号字 44行一页 //for (int i = 1; i <= 50; i++) //{ // document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, i.tostring(), true, 12, "黑体", paragraphalignment.center), rowindex); // rowindex++; //} int ipagenum = 1;//页索引 int pagerowcount = 44;//每页44行 //第一页 for (int i = 1; i <= 21; i++) { document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, string.empty, true, 12, "黑体", paragraphalignment.center), rowindex); rowindex++; } //文本标题 要显示一页 document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, model.titlemodel.f_contentstr ?? string.empty, true, 20, "黑体", paragraphalignment.center), rowindex); rowindex++; for (int i = 1; i <= 22; i++) { document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, string.empty, true, 12, "黑体", paragraphalignment.center), rowindex); rowindex++; } //空行 //document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, string.empty, true, 12, "宋体", paragraphalignment.left), rowindex); //rowindex++; document.getproperties().extendedproperties.getunderlyingproperties().pages = ipagenum; var fontsizetwotitle = 16; var fontsizetwobody = 12; var fontsize = 12; ipagenum++; //目录最大行索引 var cataloguerowcount = ipagenum * pagerowcount; document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, "目录", true, 16, "黑体", paragraphalignment.center), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); //一、检索目的...............................................4~4 var cataloguetest = "一、检索目的...............................................4~4"; //目录 要显示一页 //todo:这里一行需要显示两个文本 foreach (var item in model.twotitlelist) { if (!string.isnullorempty(item.f_contentstr)) { stringbuilder cataloguetext = new stringbuilder(item.f_contentstr);//string.format(" {0}.{1}", item.f_contentstr ?? string.empty, item.f_page ?? "1~1"); string pagenametxt = !string.isnullorempty(item.f_page) ? item.f_page : "1~1"; int begini = cataloguetext.tostring().length + pagenametxt.length; for (int i = begini; i < cataloguetest.length; i++) { cataloguetext.append("."); } cataloguetext.append(pagenametxt); document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, cataloguetext.tostring(), false, fontsize, "宋体", paragraphalignment.left), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); } } for (int i = rowindex; i < cataloguerowcount; i++) { document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, string.empty, true, 12, "黑体", paragraphalignment.center), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); } #region 正文 从第三页开始 ipagenum = 3; int beginpagenum = 3; foreach (var item in model.twotitlelist) { beginpagenum = document.getproperties().extendedproperties.getunderlyingproperties().pages; //标题 document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, string.format("{0}", item.f_contentstr ?? string.empty), false, fontsizetwotitle, "宋体", paragraphalignment.left, false, string.empty, "165dff"), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); foreach (var itemthree in item.threecontentlist) { itemthree.f_contentstr = itemthree.f_contentstr.replace("\r\n", string.empty); //内容 if (itemthree.f_contentstr.contains("</p>")) { var contentstr = itemthree.f_contentstr.replace("<p>", string.empty); var contentlist = contentstr.split("</p>"); foreach (var itemcon in contentlist) { var itemcontxt = itemcon.replace("\n", string.empty).trim(); document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, string.format(" {0}", itemcontxt), false, fontsizetwobody, "宋体", paragraphalignment.left), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); } } else { var f_contentstrtxt = itemthree.f_contentstr.replace("\n", string.empty).trim(); document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, string.format(" {0}", f_contentstrtxt), false, fontsizetwobody, "宋体", paragraphalignment.left), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); } } int pages = document.getproperties().extendedproperties.getunderlyingproperties().pages; item.f_page = string.format("{0}~{1}", beginpagenum, pages); ipagenum = pages; } #endregion #region 附件 if (model.filelist != null && model.filelist.count > 0) { document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, " (一)检索结果分析列表", false, fontsizetwotitle, "宋体", paragraphalignment.left), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, " ", false, fontsize, "宋体", paragraphalignment.left), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); int groupnum = 1; foreach (var item in model.filelist) { var keywordtxt = !string.isnullorempty(item.keyword) ? item.keyword : string.empty; keywordtxt = keywordtxt.replace("\n", string.empty).trim(); document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, string.format(" {0}", keywordtxt), false, fontsizetwobody, "宋体", paragraphalignment.left), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, " ", false, fontsize, "宋体", paragraphalignment.left), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); //注意createtable()方法里会默认添加一行,这时如果使用 table.createrow() 方法创建新行这时就会有两行。第一行为只有一个默认的单元格 //所有正确的方法是使用table.getrow(0);方法 var table = document.createtable(); xwpftablerow tableheadrow = table.getrow(0);//新增行 tableheadrow.getcell(0).settext("标题"); tableheadrow.getcell(0).setverticalalignment(xwpftablecell.xwpfvertalign.center); var tableheadrowcell_casecode = tableheadrow.addnewtablecell(); tableheadrowcell_casecode.settext("案号"); tableheadrowcell_casecode.setverticalalignment(xwpftablecell.xwpfvertalign.center); var tableheadrowcell_isadd = tableheadrow.addnewtablecell(); tableheadrowcell_isadd.settext("是否加入检索报告"); tableheadrowcell_isadd.setverticalalignment(xwpftablecell.xwpfvertalign.center); var tableheadrowcell_noaddcause = tableheadrow.addnewtablecell(); tableheadrowcell_noaddcause.settext("未加入检索报告原因"); tableheadrowcell_noaddcause.setverticalalignment(xwpftablecell.xwpfvertalign.center); foreach (var itemkey in item.keywordfilelist) { //注意 table.createrow()方法也会默认添一列,由于第一行已确定了表格的列数所要直接使用getcell(0)方法获取列对象,0表示列索引 //addnewtablecell()方法会在第一行的列数上再加列,所以正确的用法是getcell(0)方法 xwpftablerow tablebodyrow = table.createrow();//新增行 //var tablebodyrowcell_title = tablebodyrow.addnewtablecell(); //tablebodyrowcell_title.settext(itemkey.f_casetitle ?? string.empty); //tablebodyrowcell_title.setverticalalignment(xwpftablecell.xwpfvertalign.center); tablebodyrow.getcell(0).settext(itemkey.f_casetitle ?? string.empty); //var tablebodyrowcell_casecode = tablebodyrow.addnewtablecell(); //tablebodyrowcell_casecode.settext(itemkey.f_casecode ?? string.empty); //tablebodyrowcell_casecode.setverticalalignment(xwpftablecell.xwpfvertalign.center); tablebodyrow.getcell(1).settext(itemkey.f_casecode ?? string.empty); //var tablebodyrowcell_isadd = tablebodyrow.addnewtablecell(); //tablebodyrowcell_isadd.settext(itemkey.f_isadd ? "是" : "否"); //tablebodyrowcell_isadd.setverticalalignment(xwpftablecell.xwpfvertalign.center); tablebodyrow.getcell(2).settext(itemkey.f_isadd ? "是" : "否"); tablebodyrow.getcell(2).setverticalalignment(xwpftablecell.xwpfvertalign.center); //var tablebodyrowcell_noaddcause = tablebodyrow.addnewtablecell(); //tablebodyrowcell_noaddcause.settext(itemkey.f_noaddcause ?? string.empty); //tablebodyrowcell_noaddcause.setverticalalignment(xwpftablecell.xwpfvertalign.center); tablebodyrow.getcell(3).settext(itemkey.f_noaddcause ?? string.empty); groupnum++; } } } #endregion #region 生成案例 if (casedetailsviewmodels != null && casedetailsviewmodels.count > 0) { document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, string.format(" (二)检索案例全文"), false, fontsize, "宋体", paragraphalignment.left), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, " ", false, fontsize, "宋体", paragraphalignment.left), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); foreach (var item in casedetailsviewmodels) { foreach (var itemcase in item.caseitemlist) { //标题 var f_titletxt = itemcase.f_title.replace("\r\n", string.empty); document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, string.format(" {0}", f_titletxt), false, fontsize, "宋体", paragraphalignment.left), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); //内容 itemcase.f_content = itemcase.f_content.replace("\r\n", string.empty); if (itemcase.f_content.contains("</p>")) { var contentstr = itemcase.f_content.replace("<p>", string.empty); var contentlist = contentstr.split("</p>"); foreach (var itemcon in contentlist) { var itemcontxt = itemcon.replace("\n", string.empty).trim(); document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, string.format(" {0}", itemcontxt), false, fontsize, "宋体", paragraphalignment.left), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); //if (writer.pagenumber > ipagenum) //{ // writepagenumber(document, writer, bf_light); //} } } else { var f_contenttxt = itemcase.f_content.replace("\n", string.empty).trim(); document.setparagraph(npoiwordparagraphtextstylehelper._.paragraphinstancesetting(document, string.format(" {0}", f_contenttxt), false, fontsize, "宋体", paragraphalignment.left), rowindex); setwordpages(document, ref rowindex, pagerowcount, ref ipagenum); } } } } #endregion //向文档流中写入内容,生成word document.write(stream); } return outmergefile; } /// <summary> /// 设置word的pages 总页数 /// </summary> /// <param name="document"></param> /// <param name="rowindex">行索引</param> /// <param name="pagerowcount">每页的总行数</param> /// <param name="ipagenum">当前页索引</param> private static void setwordpages(xwpfdocument document, ref int rowindex, int pagerowcount, ref int ipagenum) { rowindex++; if (document != null) { if ((rowindex % pagerowcount) == 0) { ipagenum++; document.getproperties().extendedproperties.getunderlyingproperties().pages = ipagenum; } } }
调用
注意 要调用两次,第一次生成时不知道目录里的内容在第几页,第一次在生成时收集页码。这时会生成一个临时文件。第二次生成的目录里的页码才是真实有效的数据。所以要生成两次。
就好比你在写word时也是不知道目录里的内容会写在第几次,都是一、二级标题和内容都写完后,再去生成目录的。这里的道理也是一样的。
//word var filenametemppath = generatewordfile(model, casedetailsviewmodels, uploadpath, filenametemp); savepath = generatewordfile(model, casedetailsviewmodels, uploadpath, filename); //删除临时文件 if (file.exists(filenametemppath)) { file.delete(filenametemppath); }
到此这篇关于c#使用npoi实现生成word文档的文章就介绍到这了,更多相关c# npoi生成word内容请搜索代码网以前的文章或继续浏览下面的相关文章希望大家以后多多支持代码网!
发表评论