xwpfdocument 保存修改_使用NPOI读取Word文档内容并进行修改

￡神魔★判官ぃ 2022-12-31 08:27 314阅读 0赞

usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Data;usingSystem.Web.UI.WebControls;usingSystem.IO;usingGXEIS.Web.Main.Common;usingSystem.Configuration;usingNewtonsoft.Json;usingNPOI.XWPF.UserModel;usingNPOI.OpenXmlFormats.Wordprocessing;usingSystem.Text;namespaceCourseMgr

\{public partial classCourseList : PageBase

BLL.Course \_CourseBLL= null;

Model.v\_Course \_v\_CourseModel= null;

BLL.Grade \_GradeBLL= null;

Model.Grade \_GradeModel= null;protected void Page\_Load(objectsender, EventArgs e)

\{if (!IsPostBack)

ExportToWordByTemplate();

\}\#region 根据课程表模板下载Word文档

///

///根据课程表模板下载Word文档///

///

public voidExportToWordByTemplate()

\{string sClassName =hfSelectedClass.Value.Trim();string sYear1 =txtYear1.Text.Trim();string sYear2 =txtYear2.Text.Trim();string sSemester =txtSemester.Text.Trim();string sYear = sYear1 + "-" +sYear2;\#region 数据验证

if (string.IsNullOrEmpty(sClassName))

Windows.MessageBox(Page,"请先选择班级", MessageType.Normal);return;

\}if (string.IsNullOrEmpty(sYear1))

Windows.MessageBox(Page,"学年不可为空", MessageType.Normal);return;

\}if (string.IsNullOrEmpty(sYear2))

Windows.MessageBox(Page,"学年不可为空", MessageType.Normal);return;

\}if (string.IsNullOrEmpty(sSemester))

Windows.MessageBox(Page,"学期不可为空", MessageType.Normal);return;

\}\#endregion

try\{\#region 获取课程表数据DataTable dtExport= newDataTable();

BLL.Grade GradeBLL= newBLL.Grade();

Model.Grade GradeModel=GradeBLL.GetModelByGradeClassName(CurrentOperator.OrgNo, sClassName);

\_CourseBLL= newBLL.Course();

DataView dvResult= \_CourseBLL.GetViewList(string.Format("OrgNo='\{0\}' and YearStr='\{1\}' and Semester='\{2\}' and ClassNo='\{3\}'", CurrentOperator.OrgNo, sYear, sSemester, GradeModel.GradeNo)).Tables\[0\].DefaultView;\#endregion

\#region 打开文档

string fileName = Server.MapPath(@"~/Upload/CourseExportTemplate/班级课程表模板.doc");if (!File.Exists(fileName))

Windows.MessageBox(Page,"导出失败：课程表模板不存在！", MessageType.Normal);return;

XWPFDocument document= null;using (FileStream file = newFileStream(fileName, FileMode.Open, FileAccess.Read))

document= newXWPFDocument(file);

\}\#endregion

\#region 正文段落

foreach (XWPFParagraph paragraph indocument.Paragraphs)

\{//判断是否是"\*\*课程表"标题

if (paragraph.ParagraphText.Contains("GradeClassName课程表"))

IList listRun =paragraph.Runs;while (listRun.Count > 0)

paragraph.RemoveRun(0);

XWPFRun xwpgr1=paragraph.CreateRun();

xwpgr1.SetBold(true);

xwpgr1.FontSize= 23;

xwpgr1.SetText(sClassName+ "课程表");

xwpgr1.SetTextPosition(30);

\}\#endregion

\#region 表格

int iRow = 0;//表中行的循环索引

int iCell = 0;//表中列的循环索引//1.循环Word文档中的表格(该Word模板中就一个课程表)

foreach (XWPFTable table indocument.Tables)

\{//2.循环表格行

foreach (XWPFTableRow row intable.Rows)

iRow= table.Rows.IndexOf(row);//获取该循环在List集合中的索引//3.循环没行中的列

foreach (XWPFTableCell cell inrow.GetTableCells())

iCell= row.GetTableCells().IndexOf(cell);//获取该循环在List集合中的索引//4.进行单元格中内容的获取操作//4.1获取单元格中所有的XWPFParagraph(单元格中每行数据都是一个XWPFParagraph对象)

IList listXWPFParagraph =cell.Paragraphs;//4.1.1如果列中的XWPFParagraph为1个以上则是课程+教师，进行数据操作。

if (listXWPFParagraph.Count > 1)

\{//4.2根据行列获取对应的星期节次的课程信息

dvResult.RowFilter = string.Format("Section='\{0\}' and WorkingDay='\{1\}'", iRow + 1, iCell + 1);//4.2.1获取到对应的课程信息，将单元格中的课程名称和教师名称进行替换

if (dvResult.Count > 0)

\{//第一个XWPFParagraph为课程名称

XWPFParagraph xwpfPCource = listXWPFParagraph\[0\];if (xwpfPCource != null)

\{//获取现有的Run集合

IList listRun =xwpfPCource.Runs;//循环移除

while (listRun.Count > 0)

xwpfPCource.RemoveRun(0);

\}//添加获取的数据

XWPFRun xwpgRScience =xwpfPCource.CreateRun();

xwpgRScience.SetText(dvResult\[0\]\["ScienceName"\].ToString().Trim());

xwpgRScience.FontSize= 12;

xwpfPCource.AddRun(xwpgRScience);

\}//第二个XWPFParagraph为教师名称

XWPFParagraph xwpfPTeacher = listXWPFParagraph\[1\];if (xwpfPTeacher != null)

\{//获取现有的Run集合

IList listRun =xwpfPTeacher.Runs;//循环移除

while (listRun.Count > 0)

xwpfPTeacher.RemoveRun(0);

\}//添加获取的数据

XWPFRun xwpgRTeacher =xwpfPTeacher.CreateRun();

xwpgRTeacher.SetText(dvResult\[0\]\["TeacherName"\].ToString().Trim());

xwpgRTeacher.FontSize= 12;

xwpfPTeacher.AddRun(xwpgRTeacher);

\}//4.2.2没有对应的课程信息。为了美观，移除单元格中的第二个XWPFParagraph，避免出现多个换行符。

else\{

cell.RemoveParagraph(1);

\}//4.1.2如果列中的XWPFParagraph为1个则是标题单元格(星期和节次)，不进行数据操作。

else\{ \}

\}\#endregion

\#region 导出文件System.IO.MemoryStream ms= newSystem.IO.MemoryStream();

document.Write(ms);

Response.AddHeader("Content-Disposition", string.Format("attachment; filename=\{0\}.doc", HttpUtility.UrlEncode(sClassName + "课程表", System.Text.Encoding.UTF8)));

Response.BinaryWrite(ms.ToArray());

Response.End();\#endregion\}catch(Exception ex)

Windows.MessageBox(Page,"导出失败！", MessageType.Normal);

LogWrite("导出失败！", ex.ToString(), CurrentOperator.OperatorNo, ResourceID);

\}\#endregion\}