通过模板将数据导入到Word中

通过网上一些代码整理后封装了一个WordHelper 的辅助类

主要实现个功能如下

1、单个书签填充

2、根据字段名填充数据(数据格式DataRow)

   

3、使用DataTable填充表格(现在模板中设计好表头,放置一个书签到表头中,书签必须放在表头的最后一列)

    注意数据的列数和顺序

4、可以在表格的最后增加一行自定义行 可以用于合计(包括两个聚合方法Sum,Avg)

 

#region "命名空间" using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Linq; using System.Reflection; using System.Xml; using Word = Microsoft.Office.Interop.Word; #endregion /// <summary> /// Word文档操作辅助类 /// 注意:使用此类必须安装Office 2003以上版本 /// </summary> public class WordHelper { #region "事件委托" public delegate object FillBookmarkHandler(string sBookmark, object oCurrentValue); public event FillBookmarkHandler FillBookmark; public delegate object FillTableCellHandler(string sBookmark, string sColumnName, object oCurrentValue); public event FillTableCellHandler FillTableCell; #endregion #region "私有字段" private Word.Document oDocument = null; private Word.Application oApplication = null; private object missing = System.Reflection.Missing.Value; #endregion #region "公有属性" /// <summary> /// Word文档对象 /// </summary> public Word.Document Document { get { return oDocument; } private set { oDocument = value; } } /// <summary> /// Word应用程序对象 /// </summary> public Word.Application Application { get { return oApplication; } private set { oApplication = value; } } #endregion #region "公有方法" #region "打开保存关闭" /// <summary> /// 从模板创建新的Word文档 /// </summary> /// <param name="sTemplateFile">模板文件名</param> /// <returns>是否创建成功</returns> public bool CreateNewWordDocument(string sTemplateFile) { return CreateNewWordDocument(sTemplateFile, false); } /// <summary> /// 从模板创建新的Word文档 /// </summary> /// <param name="sTemplateFile">模板文件名</param> /// <param name="bVisible">是否打开文档</param> /// <returns>是否创建成功</returns> public bool CreateNewWordDocument(string sTemplateFile, bool bVisible) { try { return CreateNewWordDocument(sTemplateFile, ref oDocument, ref oApplication, bVisible); } catch (Exception ex) { throw ex; } } /// <summary> /// 从模板创建新的Word文档 /// </summary> /// <param name="sTemplateFile">模板文件名</param> /// <param name="oDocument">文档内容</param> /// <param name="oAppliction">Word应用程序对象</param> /// <returns>是否创建成功</returns> public static bool CreateNewWordDocument(string sTemplateFile, ref Word.Document oDocument, ref Word.Application oAppliction) { return CreateNewWordDocument(sTemplateFile, ref oDocument, ref oAppliction, false); } /// <summary> /// 从模板创建新的Word文档， /// </summary> /// <param name="sTemplateFile">模板文件名</param> /// <param name="oDocument">返回的Word.Document对象</param> /// <param name="oAppliction">返回的Word.Application对象</param> /// <returns></returns> public static bool CreateNewWordDocument(string sTemplateFile, ref Word.Document oDocument, ref Word.Application oAppliction, bool bVisible) { Word.Document thisDocument = null; Word.Application thisApplication = new Word.ApplicationClass(); thisApplication.Visible = bVisible; thisApplication.Caption = ""; thisApplication.Options.CheckSpellingAsYouType = false; thisApplication.Options.CheckGrammarAsYouType = false; Object Template = sTemplateFile; Object NewTemplate = false; Object DocumentType = Word.WdNewDocumentType.wdNewBlankDocument; Object Visible = true; try { Word.Document wordDoc = thisApplication.Documents.Add(ref Template, ref NewTemplate, ref DocumentType, ref Visible); thisDocument = wordDoc; oDocument = wordDoc; oAppliction = thisApplication; return true; } catch (Exception ex) { string err = string.Format("创建Word文档出错，错误原因：{0}", ex.Message); throw new Exception(err, ex); } } /// <summary> /// 文档另存为其他文件名 /// </summary> /// <param name="fileName">文件名</param> /// <param name="wDoc">Document对象</param> public bool SaveAs(string fileName) { try { return SaveAs(fileName, oDocument); } catch (Exception ex) { throw ex; } } /// <summary> /// 文档另存为其他文件名 /// </summary> /// <param name="sFileName">文件名</param> /// <param name="oDocument">Document对象</param> public static bool SaveAs(string sFileName, Word.Document oDocument) { Object FileName = sFileName; // 文档的名称。默认值是当前文件夹名和文件名。如果文档在以前没有保存过，则使用默认名称（例如，Doc1.doc）。如果已经存在具有指定文件名的文档，则会在不先提示用户的情况下改写文档。 Object FileFormat = Word.WdSaveFormat.wdFormatDocument; // 文档的保存格式。可以是任何 WdSaveFormat 值。要以另一种格式保存文档，请为 SaveFormat 属性指定适当的值。 Object LockComments = false; // 如果为 true，则锁定文档以进行注释。默认值为 false。 Object Password = System.Type.Missing; // 用来打开文档的密码字符串。（请参见下面的备注。） Object AddToRecentFiles = false; // 如果为 true，则将该文档添加到“文件”菜单上最近使用的文件列表中。默认值为 true。 Object WritePassword = System.Type.Missing; // 用来保存对文件所做更改的密码字符串。（请参见下面的备注。） Object ReadOnlyRecommended = false; // 如果为 true，则让 Microsoft Office Word 在打开文档时建议只读状态。默认值为 false。 Object EmbedTrueTypeFonts = false; //如果为 true，则将 TrueType 字体随文档一起保存。如果省略的话，则 EmbedTrueTypeFonts 参数假定 EmbedTrueTypeFonts 属性的值。 Object SaveNativePictureFormat = true; // 如果图形是从另一个平台（例如，Macintosh）导入的，则 true 表示仅保存导入图形的 Windows 版本。 Object SaveFormsData = false; // 如果为 true，则将用户在窗体中输入的数据另存为数据记录。 Object SaveAsAOCELetter = false; // 如果文档附加了邮件程序，则 true 表示会将文档另存为 AOCE 信函（邮件程序会进行保存）。 Object Encoding = System.Type.Missing; // MsoEncoding。要用于另存为编码文本文件的文档的代码页或字符集。默认值是系统代码页。 Object InsertLineBreaks = true; // 如果文档另存为文本文件，则 true 表示在每行文本末尾插入分行符。 Object AllowSubstitutions = false; //如果文档另存为文本文件，则 true 允许 Word 将某些符号替换为外观与之类似的文本。例如，将版权符号显示为 (c)。默认值为 false。 Object LineEnding = Word.WdLineEndingType.wdCRLF;// Word 在另存为文本文件的文档中标记分行符和换段符。可以是任何 WdLineEndingType 值。 Object AddBiDiMarks = true;//如果为 true，则向输出文件添加控制字符，以便保留原始文档中文本的双向布局。 try { oDocument.SaveAs(ref FileName, ref FileFormat, ref LockComments, ref Password, ref AddToRecentFiles, ref WritePassword , ref ReadOnlyRecommended, ref EmbedTrueTypeFonts, ref SaveNativePictureFormat , ref SaveFormsData, ref SaveAsAOCELetter, ref Encoding, ref InsertLineBreaks, ref AllowSubstitutions , ref LineEnding, ref AddBiDiMarks); return true; } catch (Exception ex) { string err = string.Format("另存文件出错，错误原因：{0}", ex.Message); throw new Exception(err, ex); } } /// <summary> /// 关闭文档 /// </summary> public void Close() { Close(oDocument, oApplication); oDocument = null; oApplication = null; } /// <summary> /// 关闭文档 /// </summary> /// <param name="oDocument">Document对象</param> /// <param name="oAppliction">Application对象</param> public static void Close(Word.Document oDocument, Word.Application oAppliction) { Object SaveChanges = Word.WdSaveOptions.wdSaveChanges;// 指定文档的保存操作。可以是下列 WdSaveOptions 值之一：wdDoNotSaveChanges、wdPromptToSaveChanges 或 wdSaveChanges。 Object OriginalFormat = Word.WdOriginalFormat.wdOriginalDocumentFormat;// 指定文档的保存格式。可以是下列 WdOriginalFormat 值之一：wdOriginalDocumentFormat、wdPromptUser 或 wdWordDocument。 Object RouteDocument = false;// 如果为 true，则将文档传送给下一个收件人。如果没有为文档附加传送名单，则忽略此参数。 try { if (oDocument != null) oDocument.Close(ref SaveChanges, ref OriginalFormat, ref RouteDocument); if (oAppliction != null) oAppliction.Quit(ref SaveChanges, ref OriginalFormat, ref RouteDocument); } catch (Exception ex) { throw ex; } } #endregion #region "书签操作" /// <summary> /// 填充书签 /// </summary> /// <param name="sBookmark">书签</param> /// <param name="sValue">值</param> public void Fill(string sBookmark, string sValue) { try { object bkObj = sBookmark; if (oApplication.ActiveDocument.Bookmarks.Exists(sBookmark) == true) { oApplication.ActiveDocument.Bookmarks.get_Item(ref bkObj).Select(); } else return; oApplication.Selection.TypeText(sValue); } catch (Exception ex) { throw ex; } } /// <summary> /// 自动填充数据到书签中 /// </summary> /// <param name="sPrefix">前缀</param> /// <param name="oDataRow">数据行</param> private void Fill(string sPrefix, DataRow oDataRow) { try { Word.Bookmarks oBookmarks = oApplication.ActiveDocument.Bookmarks; foreach (DataColumn item in oDataRow.Table.Columns) { FillData(sPrefix, oBookmarks, item.ColumnName, oDataRow[item.ColumnName]); } } catch (Exception ex) { throw new Exception("自动填充数据时发生错误", ex); } } /// <summary> /// 自动填充数据到书签中 /// </summary> /// <param name="oData">数据对象(DataRow,DataTable,DataSet,Object)</param> public void Fill(object oData) { Fill("", oData); } /// <summary> /// 自动填充数据到书签中 /// </summary> /// <param name="sPrefix">前缀</param> /// <param name="oData">数据对象(DataRow,DataTable,DataSet,Object)</param> public void Fill(string sPrefix, object oData) { if (oData is DataRow) { Fill(sPrefix, (DataRow)oData); } else if (oData is DataTable) { DataTable dt = (DataTable)oData; if (dt.Rows.Count > 0) Fill(sPrefix, dt.Rows[0]); } else if (oData is DataSet) { DataSet ds = (DataSet)oData; if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) Fill(sPrefix, ds.Tables[0].Rows[0]); } else { PropertyInfo[] arrProperies = oData.GetType().GetProperties(); Word.Bookmarks oBookmarks = oApplication.ActiveDocument.Bookmarks; foreach (PropertyInfo item in arrProperies) { FillData(sPrefix, oBookmarks, item.Name, item.GetValue(oData, null)); } } } #endregion #region "位置移动" /// <summary> /// 向右移动一个字符 /// </summary> public void MoveRight() { MoveRight(1); } /// <summary> /// 向右移动N个字符 /// </summary> /// <param name="num"></param> public void MoveRight(int num) { object unit = Word.WdUnits.wdCharacter; object count = num; MoveRight(unit, count, missing); } /// <summary> /// 向下移动一个字符 /// </summary> public void MoveDown() { MoveDown(1); } /// <summary> /// 向下移动N个字符 /// </summary> /// <param name="num"></param> public void MoveDown(int num) { object unit = Word.WdUnits.wdCharacter; object count = num; MoveDown(unit, count, missing); } /// <summary> /// 光标上移 /// Moves the selection up and returns the number of units it's been moved. /// </summary> /// <param name="unit">Optional Object. The unit by which to move the selection. Can be one of the following WdUnits constants: wdLine, wdParagraph, wdWindow or wdScreen etc. The default value is wdLine.</param> /// <param name="count">Optional Object. The number of units the selection is to be moved. The default value is 1.</param> /// <param name="extend">Optional Object. Can be either wdMove or wdExtend. If wdMove is used, the selection is collapsed to the end point and moved up. If wdExtend is used, the selection is extended up. The default value is wdMove.</param> /// <returns></returns> public int MoveUp(object unit, object count, object extend) { return oApplication.Selection.MoveUp(ref unit, ref count, ref extend); } /// <summary> /// 光标下移 /// Moves the selection down and returns the number of units it's been moved. /// 参数说明详见MoveUp /// </summary> public int MoveDown(object unit, object count, object extend) { return oApplication.Selection.MoveDown(ref unit, ref count, ref extend); } /// <summary> /// 光标左移 /// Moves the selection to the left and returns the number of units it's been moved. /// 参数说明详见MoveUp /// </summary> public int MoveLeft(object unit, object count, object extend) { return oApplication.Selection.MoveLeft(ref unit, ref count, ref extend); } /// <summary> /// 光标右移 /// Moves the selection to the left and returns the number of units it's been moved. /// 参数说明详见MoveUp /// </summary> public int MoveRight(object unit, object count, object extend) { return oApplication.Selection.MoveRight(ref unit, ref count, ref extend); } #endregion #region "表格操作" /// <summary> /// 填充表格 /// </summary> /// <param name="sBookmark">书签名称</param> /// <param name="oDataSource">数据源</param> public void FillTable(string sBookmark, DataTable oDataTable, params string[] arrColumnName) { FillTable(sBookmark, oDataTable, null, arrColumnName); } /// <summary> /// 填充表格 /// </summary> /// <param name="sBookmark">书签名称</param> /// <param name="oDataSource">数据源</param> /// <param name="arrColumnName"></param> public void FillTable(string sBookmark, DataTable oDataTable, DataRow oCoustomLastRow, params string[] arrColumnName) { FillTable(sBookmark, oDataTable, oCoustomLastRow, false, arrColumnName); } /// <summary> /// 填充表格 /// </summary> /// <param name="sBookmark">书签名称</param> /// <param name="oDataTable">数据表</param> /// <param name="oCoustomLastRow">尾行(直接输出)</param> /// <param name="bStartFirstDataRow">是否从第一行开始</param> /// <param name="arrColumnName">显示DataTable中的字段名称(不传此参数默认按datatable数据列显示顺序)</param> public void FillTable(string sBookmark, DataTable oDataTable, DataRow oCoustomLastRow, bool bStartFirstDataRow, params string[] arrColumnName) { if (oDataTable == null) return; try { //oDataTable.Compute(); if (!FindSelection(sBookmark)) return; int iRowIndex = 0; foreach (DataRow row in oDataTable.Rows) { if (bStartFirstDataRow || iRowIndex > 0) MoveNextRow();//移动到下一行 CreateDataRow2Word(sBookmark, row, arrColumnName); iRowIndex++; } //加入最后一行 if (oCoustomLastRow != null) { MoveNextRow(); CreateDataRow2Word(sBookmark, oCoustomLastRow, arrColumnName); } } catch (Exception ex) { throw new Exception("填充数据表时发生了错误", ex); } } /// <summary> /// 填充表格 /// </summary> /// <param name="sBookmark">书签名称</param> /// <param name="oHeaderTree">表头</param> /// <param name="oDataTable">数据表</param> /// <param name="arrColumnName">指定列</param> public void FillTable(string sBookmark, XmlDocument oHeaderTree, DataTable oDataTable, params string[] arrColumnName) { if (!FindSelection(sBookmark)) return; string[,] arrHeader = TreeToTable(oHeaderTree); int rowCount = arrHeader.GetLength(0); // int colCount = arrHeader.GetLength(1); Word.Table table = AddTable(rowCount, colCount); //生成二维表 for (int i = 0; i <= rowCount - 1; i++) { for (int n = 0; n <= colCount - 1; n++) { table.Cell(i + 1, n + 1).Range.Text = arrHeader[i, n]; } } SetTableBorder(ref table);//设置表格边框 //添加数据行 foreach (DataRow oDataRow in oDataTable.Rows) { Word.Row oRow = AddRow(table); if (arrColumnName.Length > 0) { int k = 1; foreach (var item in arrColumnName) { oRow.Cells[k].Range.Text = NullFormat(oDataRow[item]); k++; } } else { int k = 1; foreach (DataColumn item in oDataTable.Columns) { oRow.Cells[k].Range.Text = NullFormat(oDataRow[item.ColumnName]); k++; } } } //设置垂直合并 for (int i = 1; i <= colCount; i++) { VerticalCellMerge(table, 1, rowCount, i); } //设置水平合并 for (int i = 1; i <= rowCount; i++) { HorizontalCellMerge(table, 1, i); } } /// <summary> /// 设置边框 /// </summary> /// <param name="oTable">表格对象</param> private void SetTableBorder(ref Word.Table oTable) { foreach (Word.WdBorderType item in new Word.WdBorderType[] { Word.WdBorderType.wdBorderBottom, Word.WdBorderType.wdBorderTop, Word.WdBorderType.wdBorderLeft, Word.WdBorderType.wdBorderRight, Word.WdBorderType.wdBorderHorizontal, Word.WdBorderType.wdBorderVertical }) { oTable.Borders[item].LineStyle = Word.WdLineStyle.wdLineStyleSingle; oTable.Borders[item].LineWidth = Word.WdLineWidth.wdLineWidth050pt; oTable.Borders[item].Color = Word.WdColor.wdColorAutomatic; } } /// <summary> /// 填充表格 /// </summary> /// <param name="sBookmark">书签名称</param> /// <param name="arrData">可没觉的数据对象</param> /// <param name="arrName">字段名</param> public void FillTable(string sBookmark, IEnumerable arrData, params string[] arrName) { if (string.IsNullOrEmpty(sBookmark)) throw new ArgumentException("sBookmark"); if (arrData == null) throw new ArgumentNullException("arrData"); if (arrName.Length == 0) throw new ArgumentException("arrName"); IEnumerator itor = arrData.GetEnumerator(); if (!FindSelection(sBookmark)) return; int iRowIndex = 0; while (itor.MoveNext()) { object obj = itor.Current; PropertyInfo[] arrProperties = obj.GetType().GetProperties(); if (iRowIndex > 0) MoveNextRow(); foreach (var item in arrName) { var lq = from p in arrProperties where p.Name == item select p; PropertyInfo oProperty = lq.FirstOrDefault(); if (oProperty != null) { object value = oProperty.GetValue(obj, null); SetCellValue(value != null ? value.ToString() : ""); } MoveNextCell(); } iRowIndex++; } } /// <summary> /// 新增自定表格 /// </summary> /// <param name="iNumRows">行数</param> /// <param name="iNumColumns">列数</param> /// <returns></returns> public Word.Table AddTable(int iNumRows, int intNumColumns) { return AddTable(oApplication.Selection.Range, iNumRows, intNumColumns, missing, missing); } /// <summary> /// 新增自定义表格 /// </summary> /// <param name="iNumRows">行数</param> /// <param name="iNumColumns">列数</param> /// <param name="AutoFitBehavior">自适应方式</param> /// <returns></returns> public Word.Table AddTable(int iNumRows, int iNumColumns, Word.WdAutoFitBehavior AutoFitBehavior) { return AddTable(oApplication.Selection.Range, iNumRows, iNumColumns, missing, AutoFitBehavior); } /// <summary> /// 新增自定义表格：Returns a Table object that represents a new, blank table added to a document. /// </summary> /// <param name="oRange">Required Range object. The range where you want the table to appear. The table replaces the range, if the range isn't collapsed.</param> /// <param name="iNumRows">Required Integer. The number of rows you want to include in the table.</param> /// <param name="iNumColumns">Required Integer. The number of columns you want to include in the table.</param> /// <param name="oDefaultTableBehavior">Optional Object. Sets a value that specifies whether Word automatically resizes cells in tables to fit the cells’ contents (AutoFit). Can be either of the following constants: wdWord8TableBehavior (AutoFit disabled) or wdWord9TableBehavior (AutoFit enabled). The default constant is wdWord8TableBehavior.</param> /// <param name="oAutoFitBehavior">Optional Object. Sets the AutoFit rules for how Microsoft Word sizes tables. Can be one of the following WdAutoFitBehavior constants: wdAutoFitContent, wdAutoFitFixed, or wdAutoFitWindow. If DefaultTableBehavior is set to wdWord8TableBehavior, this argument is ignored.</param> /// <returns></returns> public Word.Table AddTable(Word.Range oRange, int iNumRows, int iNumColumns, object oDefaultTableBehavior, object oAutoFitBehavior) { if (oDocument == null) { oDocument = oApplication.ActiveDocument; } return oDocument.Tables.Add(oRange, iNumRows, iNumColumns, ref oDefaultTableBehavior, ref oAutoFitBehavior); } /// <summary> /// 在表尾插入行 /// </summary> /// <param name="oTable"></param> /// <returns></returns> public Word.Row AddRow(Word.Table oTable) { return AddRow(oTable, missing); } /// <summary> /// 插入行到指定列前 /// 如object beforeRow = table.Rows[1]; /// </summary> /// <param name="oTable"></param> /// <param name="oBeforeRow">Optional Object. A Row object that represents the row that will appear immediately below the new row.</param> /// <returns></returns> public Word.Row AddRow(Word.Table oTable, object oBeforeRow) { return oTable.Rows.Add(ref oBeforeRow); } /// <summary> /// 在当前位置插入指定数量行 /// Inserts the specified number of new rows above the row that contains the selection. /// </summary> /// <param name="iNumRows"></param> public void InsertRows(int iNumRows) { object NumRows = iNumRows; object wdCollapseStart = Word.WdCollapseDirection.wdCollapseStart; oApplication.Selection.InsertRows(ref NumRows); oApplication.Selection.Collapse(ref wdCollapseStart); } /// <summary> /// 向上移动一个单元格 /// </summary> public void MoveToUpCell() { MoveToUpCell(1); } /// <summary> /// 向上移动N个单元格 /// </summary> /// <param name="num"></param> public void MoveToUpCell(int num) { object unit = Word.WdUnits.wdCell; MoveUp(unit, num, missing); } /// <summary> /// 向下移动一个单元格 /// </summary> public void MoveToDownCell() { MoveToDownCell(1); } /// <summary> /// 向下移动N个单元格 /// </summary> public void MoveToDownCell(int iNum) { MoveDown(missing, iNum, missing); } /// <summary> /// 向右移动一个单元格 /// </summary> public void MoveToRightCell() { MoveToRightCell(1); } /// <summary> /// 向右移动N个单元格 /// </summary> public void MoveToRightCell(int iNum) { object unit = Word.WdUnits.wdCell; MoveRight(unit, iNum, missing); } /// <summary> /// 向左移动一个单元格 /// </summary> public void MoveToLeftCell() { MoveToLeftCell(1); } /// <summary> /// 向左移动N个单元格 /// </summary> public void MoveToLeftCell(int iNum) { object unit = Word.WdUnits.wdCell; MoveLeft(unit, iNum, missing); } /// <summary> /// 向上移动1个单元格，并加入选中（Section） /// </summary> public void MoveExtendToUpCell() { MoveExtendToUpCell(1); } /// <summary> /// 向上移动N个单元格，并加入选中（Section） /// </summary> /// <param name="iNum"></param> public void MoveExtendToUpCell(int iNum) { object extend = Word.WdMovementType.wdExtend; MoveUp(missing, iNum, extend); } /// <summary> /// 向下移动1个单元格，并加入选中（Section） /// </summary> public void MoveExtendToDownCell() { MoveExtendToDownCell(1); } /// <summary> /// 向下移动N个单元格，并加入选中（Section） /// </summary> /// <param name="iNum"></param> public void MoveExtendToDownCell(int iNum) { object extend = Word.WdMovementType.wdExtend; MoveDown(missing, iNum, extend); } /// <summary> /// 移动到下一个单元格 /// </summary> public void MoveNextCell() { try { Object unit = Word.WdUnits.wdCell; Object count = 1; oApplication.Selection.Move(ref unit, ref count); } catch (Exception ex) { throw ex; } } /// <summary> /// 设置当前选中单元格内容 /// </summary> public void SetCellValue(string sValue) { try { oApplication.Selection.TypeText(sValue); } catch (Exception ex) { throw ex; } } /// <summary> /// 移动到下一行 /// </summary> public void MoveNextRow() { try { Object extend = Word.WdMovementType.wdExtend; Object unit = Word.WdUnits.wdCell; Object count = 1; oApplication.Selection.MoveRight(ref unit, ref count, ref extend); } catch (Exception ex) { throw ex; } } #endregion #region "图片操作" /// <summary> /// 插入图片（图片大小自适应） /// </summary> /// <param name="sFileName">图片名（包含路径）</param> public void InsertPic(string sFileName) { object range = oApplication.Selection.Range; InsertPic(sFileName, missing, missing, range); } /// <summary> /// 插入图片 /// </summary> /// <param name="sFileName">图片名（包含路径）</param> /// <param name="width">设置宽度</param> /// <param name="height">设置高度</param> public void InsertPic(string sFileName, float width, float height) { object range = oApplication.Selection.Range; InsertPic(sFileName, missing, missing, range, width, height); } /// <summary> /// 插入图片（带标题） /// </summary> /// <param name="fileName">图片名（包含路径）</param> /// <param name="width">设置宽度</param> /// <param name="height">设置高度<</param> /// <param name="caption">标题或备注文字</param> public void InsertPic(string sFileName, float width, float height, string caption) { object range = oApplication.Selection.Range; InsertPic(sFileName, missing, missing, range, width, height, caption); } /// <summary> /// 插入图片（带标题） /// </summary> public void InsertPic(string sFileName, object LinkToFile, object SaveWithDocument, object Range, float Width, float Height, string caption) { oApplication.Selection.InlineShapes.AddPicture(sFileName, ref LinkToFile, ref SaveWithDocument, ref Range).Select(); if (Width > 0) { oApplication.Selection.InlineShapes[1].Width = Width; } if (Height > 0) { oApplication.Selection.InlineShapes[1].Height = Height; } object Label = Word.WdCaptionLabelID.wdCaptionFigure; object Title = caption; object TitleAutoText = ""; object Position = Word.WdCaptionPosition.wdCaptionPositionBelow; object ExcludeLabel = true; oApplication.Selection.InsertCaption(ref Label, ref Title, ref TitleAutoText, ref Position, ref ExcludeLabel); MoveRight(); } /// <summary> /// Adds a picture to a document. /// </summary> /// <param name="sFileName">Required String. The path and file name of the picture.</param> /// <param name="LinkToFile">Optional Object. True to link the picture to the file from which it was created. False to make the picture an independent copy of the file. The default value is False.</param> /// <param name="SaveWithDocument">Optional Object. True to save the linked picture with the document. The default value is False.</param> /// <param name="Range">Optional Object. The location where the picture will be placed in the text. If the range isn't collapsed, the picture replaces the range; otherwise, the picture is inserted. If this argument is omitted, the picture is placed automatically.</param> /// <param name="Width">Sets the width of the specified object, in points. </param> /// <param name="Height">Sets the height of the specified inline shape. </param> public void InsertPic(string sFileName, object LinkToFile, object SaveWithDocument, object Range, float Width, float Height) { oApplication.Selection.InlineShapes.AddPicture(sFileName, ref LinkToFile, ref SaveWithDocument, ref Range).Select(); oApplication.Selection.InlineShapes[1].Width = Width; oApplication.Selection.InlineShapes[1].Height = Height; MoveRight(); } /// <summary> /// Adds a picture to a document. /// </summary> /// <param name="sFileName">Required String. The path and file name of the picture.</param> /// <param name="LinkToFile">Optional Object. True to link the picture to the file from which it was created. False to make the picture an independent copy of the file. The default value is False.</param> /// <param name="SaveWithDocument">Optional Object. True to save the linked picture with the document. The default value is False.</param> /// <param name="Range">Optional Object. The location where the picture will be placed in the text. If the range isn't collapsed, the picture replaces the range; otherwise, the picture is inserted. If this argument is omitted, the picture is placed automatically.</param> public void InsertPic(string sFileName, object LinkToFile, object SaveWithDocument, object Range) { oApplication.Selection.InlineShapes.AddPicture(sFileName, ref LinkToFile, ref SaveWithDocument, ref Range); } #endregion #region "表头操作" public static string[,] TreeToTable(XmlDocument tree) { #region 临时存储变量 int a = 0, b = 0; //计算列数 初始为1 int c = 1, d = 1; #endregion //实际总行数 int rowCount = 0; //字段列数 int colunmCount = 0; //实际总列数 int totalColumnCount = 0; //获得行数 (深度) rowCount = GetNodeDepth(tree.DocumentElement, ref a, ref b); //获得列(根节点下的节点数) colunmCount = tree.DocumentElement.ChildNodes.Count; for (int n = 0; n <= colunmCount - 1; n++) { int innerColumnCount = GetColumnMaxCount(tree.DocumentElement.ChildNodes[n], ref c, ref d); totalColumnCount += innerColumnCount; } //创建指定大小的数据行 string[,] data = new string[rowCount, totalColumnCount]; List<XmlNode> list = new List<XmlNode>(); //获取所有的节点 GetAllList(list, tree.DocumentElement); //偏移量 int currentcolumn = 0; int lastrow = 0; int lastcolumn = 0; int currentAdd = 0; int cuurentInnerAdd = 0; int currentrow = 0; foreach (XmlNode item in list) { int e = 1, f = 1; int g = 0, h = 0, nowcount = rowCount; int x = 1, z = 1; //当前字段有几列 int nodeColunmCount = GetColumnMaxCount(item, ref e, ref f); //当前字段有几行 int nodeRowCount = GetNodeCurrentDepth(item, ref g, ref h, ref nowcount); //移动多少位置 //每个大列的偏移量 if (cuurentInnerAdd >= currentAdd) { currentAdd += GetColumnMaxCount(GetFirstNode(item), ref z, ref x) * rowCount; } //寻找位置 for (int n = 0; n <= nodeColunmCount - 1; n++) { for (int m = 0; m <= nodeRowCount - 1; m++) { data[m + currentrow, n + currentcolumn] = item.Name; //每个小列的偏移量 每走一步加一 cuurentInnerAdd++; } } if ((nodeColunmCount * nodeRowCount == 1) && item.HasChildNodes) { currentrow++; } if (currentrow < rowCount && (nodeColunmCount * nodeRowCount != 1)) { currentrow += nodeRowCount; } //如果是走的是每个小格子 那么移动列+1 if ((nodeColunmCount * nodeRowCount == 1) && GetFirstNode(item) != item) { currentcolumn++; } //如果每个大列都走过 if (cuurentInnerAdd == currentAdd) { currentcolumn = lastcolumn + GetColumnMaxCount(GetFirstNode(item), ref z, ref x); lastcolumn = currentcolumn; //行数从0开始计算 currentrow = 0; } ////移动 //if ((rowCount * (currentcolumn + 1)) == (currentAdd)) //{ // currentcolumn = lastcolumn; //} } return data; } private static List<XmlNode> GetAllList(List<XmlNode> list, XmlNode node) { //如果存在子节点将当前所有节点加入集合内，并继续递归 if (node.HasChildNodes) { foreach (XmlNode item in node.ChildNodes) { list.Add(item); GetAllList(list, item); } } return list; } /// <summary> /// 获得当前字段下最大列数数 /// </summary> /// <returns></returns> private static int GetColumnMaxCount(XmlNode node, ref int count, ref int max) { if (node.HasChildNodes) { count = node.ChildNodes.Count; foreach (XmlNode item in node.ChildNodes) { GetColumnMaxCount(item, ref count, ref max); } } else { if (count > max) { max = count; } } return max; } private static XmlNode GetFirstNode(XmlNode node) { if (node.ParentNode.ParentNode != null && node.ParentNode.ParentNode.GetType() == typeof(XmlDocument)) { return node; } else { return GetFirstNode(node.ParentNode); } } /// <summary> /// 获得节点的深度(深度遍历) /// </summary> /// <param name="nodelist"></param> /// <param name="count"></param> /// <param name="max"></param> /// <returns></returns> private static int GetNodeDepth(XmlNode node, ref int count, ref int max) { if (node.HasChildNodes) { XmlNode newnode = node.FirstChild; while (newnode != null) { GetNodeDepth(newnode, ref count, ref max); newnode = newnode.NextSibling; } } else { //火了~ 这里先递归到没有子节点 然后倒推回去算得长度，然后比较 count = GetNodeLength(node); if (count > max) { max = count; } } return max; } private static int GetNodeLength(XmlNode node) { int n = 0; XmlNode parent = node.ParentNode; while (parent != node.OwnerDocument) { n++; parent = parent.ParentNode; } return n; } private static int GetNodeCurrentDepth(XmlNode node, ref int count, ref int max, ref int nowCount) { int a = 0, b = 0; int depth = GetNodeDepth(node, ref a, ref b); if (depth == nowCount - 1 && node.HasChildNodes && node.ChildNodes.Count == 1) { return 1; } //如果是头结点和深度=最大深度-1 if (node.ParentNode.ParentNode != null && node.ParentNode.ParentNode.GetType() == typeof(XmlDocument) && depth == nowCount) { return 1; } //如果是头结点且没有子节点 if (node.ParentNode.ParentNode != null && node.ParentNode.ParentNode.GetType() == typeof(XmlDocument) && !node.HasChildNodes) { return nowCount; } //如果不是头结点且有子节点 if (node.ParentNode.ParentNode != null && node.ParentNode.ParentNode.GetType() == typeof(XmlDocument) && node.HasChildNodes) { return nowCount - 1; } //最后一个结点 if (node.ParentNode.ParentNode != null && node.ParentNode.ParentNode.GetType() != typeof(XmlDocument) && !node.HasChildNodes) { return 1; } //如果是中间结点 if (node.ParentNode.ParentNode != null && node.ParentNode.ParentNode.GetType() != typeof(XmlDocument) && node.HasChildNodes) { return 1; } return max; } #endregion #region "其他方法" /// 查找指定书签并选中 /// </summary> /// <param name="sBookmark">书签名称</param> /// <returns>存在返回true,否则返回false</returns> public bool FindSelection(string sBookmark) { try { object oBookmark = sBookmark; if (oApplication.ActiveDocument.Bookmarks.Exists(sBookmark) == true) { oApplication.ActiveDocument.Bookmarks.get_Item(ref oBookmark).Select(); return true; } else return false; } catch (Exception ex) { throw ex; } } /// <summary> ///获取选中区 /// </summary> /// <returns></returns> public Word.Range GetSelectionRange() { return oApplication.Selection.Range; } /// <summary> /// 计算列总和 /// </summary> /// <param name="dt">包含数据的Datatable</param> /// <param name="columnName">列名</param> /// <returns></returns> public static object Sum(System.Data.DataTable dt, string columnName) { return dt.Compute(string.Format("Sum([{0}])", columnName), ""); } /// <summary> /// 计算列平均值 /// </summary> /// <param name="dt">包含数据的Datatable</param> /// <param name="columnName">列名</param> /// <returns></returns> public static object Avg(System.Data.DataTable dt, string columnName) { return dt.Compute(string.Format("Avg([{0}])", columnName), ""); } /// <summary> /// 纵向单元格合并 /// 说明：如合并了第一行第一列和第二行第一列两个单元格，则单元格cell(2, 1)已经不存在，继续操作会有异常， /// 只有通过cell(1, 1)来获取合并后的单元格 /// </summary> /// <param name="table"></param> /// <param name="startRowIndex"></param> /// <param name="columnIndex"></param> public void VerticalCellMerge(Word.Table table, int startRowIndex, int endRowIndex, int columnIndex) { string previousText = table.Cell(startRowIndex++, columnIndex).Range.Text.Trim().Replace("/r", ""); // 保存对比文字 int previousRowIndex = startRowIndex - 1; // 因刚已经+1了，所以再减回去 for (int i = startRowIndex; i <= endRowIndex; ++i) // 遍历所有行的columnIndex列，发现相同的合并，从起始行的下一行开始对比 { string currentText = table.Cell(i, columnIndex).Range.Text.Trim().Replace("/r", ""); if (previousText.Equals(currentText)) { table.Cell(previousRowIndex, columnIndex).Merge(table.Cell(i, columnIndex)); // 合并先前单元格和当前单元格 table.Cell(previousRowIndex, columnIndex).Range.Text = currentText; // 因为合并后并没有将单元格内容去除，需要手动修改 table.Cell(previousRowIndex, columnIndex).Select(); oApplication.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter; // 水平居中显示 table.Cell(previousRowIndex, columnIndex).VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter; // 垂直居中 } else { previousText = currentText; // 将对比文字替换为当前的内容 previousRowIndex = i; // 检索到不同的内容，将当前行下标置为先前行下标，用于合并 } } } /// <summary> /// 横向单元格合并 /// 注意：在合并单元格后必须将纵列数减去1 /// 如第一行第一列和第一行第二列合并后，原第一行第三列将变成第一行第二列，这就是在合并后i不加1的原因 /// </summary> /// <param name="WordApp"></param> /// <param name="table"></param> /// <param name="startColumnIndex"></param> /// <param name="rowIndex"></param> public void HorizontalCellMerge(Word.Table table, int startColumnIndex, int rowIndex) { // string previousText = table.Cell(rowIndex, startColumnIndex).Range.Text.Trim().Replace("/r", ""); // 保存对比文字 Word.Cell cell = GetTableCell(table, rowIndex, startColumnIndex); if (cell == null) return; string previousText = cell.Range.Text.Trim().Replace("/r", ""); int previousColumnIndex = startColumnIndex++; // 保存先前对比列下标 Word.Cell previousCell = cell; int colCount = table.Columns.Count; for (int i = startColumnIndex; i <= colCount; ) {// 遍历所有行的columnIndex列，发现相同的合并，从起始行的下一行开始对比 Word.Cell currentCell = GetTableCell(table, rowIndex, i); if (currentCell == null) { --colCount; continue; } string currentText = currentCell.Range.Text.Trim().Replace("/r", ""); if (previousText.Equals(currentText) && previousCell.ColumnIndex != currentCell.ColumnIndex) { previousCell.Merge(currentCell); // 合并先前单元格和当前单元格 previousCell.Range.Text = currentText; // 因为合并后并没有将单元格内容去除，需要手动修改 previousCell.Select(); oApplication.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter; // 水平居中显示 previousCell.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter; // 垂直居中 --colCount; } else { previousText = currentText; // 将对比文字替换为当前的内容 previousCell = currentCell; previousColumnIndex = i++; // 检索到不同的内容，将当前行下标置为先前行下标，用于合并 } } } private Word.Cell GetTableCell(Word.Table table, int rowIndex, int columnIndex) { Word.Cell cell = null; try { cell = table.Cell(rowIndex, columnIndex); } catch (Exception) { if (columnIndex < table.Columns.Count - 1) { columnIndex++; cell = GetTableCell(table, rowIndex, columnIndex); } } return cell; } private string NullFormat(object val) { if (val == null || val == DBNull.Value) return string.Empty; return val.ToString(); } #endregion #endregion #region "私有方法" /// <summary> /// /// </summary> /// <param name="sPrefix"></param> /// <param name="oBookmarks"></param> /// <param name="sName"></param> /// <param name="oVal"></param> private void FillData(string sPrefix, Word.Bookmarks oBookmarks, string sName, object oVal) { string sMark = sPrefix + "_" + sName; if (!oBookmarks.Exists(sMark)) sMark = sName; if (oVal != null && oVal != DBNull.Value) { if (FillBookmark != null) oVal = FillBookmark(sMark, oVal); Fill(sMark, oVal.ToString()); } } /// <summary> /// 创建数据行到Word中 /// </summary> /// <param name="oDataRow">数据行</param> /// <param name="arrColumnName">列名数组</param> private void CreateDataRow2Word(string sBookmark, DataRow oDataRow, params string[] arrColumnName) { if (arrColumnName != null && arrColumnName.Length > 0) { foreach (var item in arrColumnName) { if (string.IsNullOrEmpty(item)) continue; object val = oDataRow[item]; if (val == null) continue; if (FillTableCell != null) val = FillTableCell(sBookmark, item, val); SetCellValue(val.ToString()); MoveNextCell();//移动到下一格 } } else { foreach (DataColumn col in oDataRow.Table.Columns) { object val = oDataRow[col.ColumnName]; if (FillTableCell != null) val = FillTableCell("", col.ColumnName, val); SetCellValue((val != null || val == DBNull.Value) ? val.ToString() : ""); MoveNextCell();//移动到下一格 } } } #endregion }

 

调用代码

 

/// <summary> /// 创建Word文档 /// </summary> /// <param name="sTempalteFile">模板文件路径</param> /// <param name="sTargetFile">导出Word路径</param> /// <param name="bVisible">是否打开Word</param> private void CreateWordDocument(string sTempalteFile, string sTargetFile, bool bVisible) { WordHelper helper = new WordHelper(); helper.InsertLastRow += new WordHelper.InsertLastRowHander(helper_InsertLastRow); helper.CreateNewWordDocument(sTempalteFile, bVisible); helper.Fill("Year", DateTime.Now.Year.ToString());//普通替换标签的方法 helper.Fill("Month", DateTime.Now.Month.ToString()); helper.Fill("Name", "小强"); helper.Fill("Table1", GetFillTable());//指定前缀(前缀格式 "前缀名_" ),主要用来区分不同表中的相同字段 helper.FillTable("Table", GetTableData()); if (!bVisible) { helper.SaveAs(sTargetFile); helper.Close(); } }