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

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}

}