OpenXml Sdk 根据Word模板导出到word


一:OpenXml Sdk 简介

  Open XML标准的简单介绍:Ecma Office Open XML(“Open XML”)是针对字处理文档、演示文稿电子表格的国际化开放标准,可免费供多个应用程序在多个平台上实现。Microsoft Office(2007、2003、XP、2000)、OpenOffice Novell Edition、开源项目 Gnumeric、Neo-Office 2.1 和 PalmOS (Dataviz) 已经支持 Open XML。Corel 已经宣布在 WordPerfect 2007 中提供 Open XML 支持,全球的开发人员 正在使用 OpenXML 构建解决方案。

  Open XML 的标准化工作是由 Ecma International 通过其技术委员会 45 (TC45) 执行的,来自 Apple、Barclays Capital、BP、The British Library、Essilor、Intel、Microsoft、NextPage、Novell、Statoil、Toshiba 和 United States Library of Congress 的代表参与了该项工作。该标准旨在提供现有 ISO 标准所无法提供的独特好处,其中包括能够实现从现有二进制格式向基于 XML 的格式的高保真移植。

二:OpenXml Sdk 安装

  下载并安装OpenXMLSDKv2.msiOpenXMLSDKTool.msi,下载地址:https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=5124

  

  官方SDK文档:

  

三:OpenXml Sdk 使用(新建项目)

  打开vs新建项目OpenXmlWord,引用DocumentFormat.OpenXml.dll 和 WindowsBase.dll,如下如

      

  新建word模板(word模板.docx)

  

四:OpenXml Sdk 使用(插入简单文本)

  这里主要根据插入书签(BookMark)的方式来定位位置,打开word模板.docx分别在‘公司名称’和‘公司简介’中插入两个书签。

  

  

  InsertSimpleText方法:

  

/// <summary>
       /// 
       /// </summary>
       /// <param name="filepPath"></param>
       /// <param name="Dictionary"></param>
       public static void InsertSimpleText(string filepPath, Dictionary<string, string> dictionary)
       {
           using (WordprocessingDocument wordprocessingDocument = WordprocessingDocument.Open(filepPath, true))
           {
               List<BookmarkStart> allBookmarkStart = wordprocessingDocument.MainDocumentPart.RootElement.Descendants<BookmarkStart>().ToList();
               foreach (KeyValuePair<string, string> keyValuePair in dictionary)
               {
                   foreach (BookmarkStart bookmarkStart in allBookmarkStart)
                   {
                       if (bookmarkStart.Name.Value == keyValuePair.Key)
                       {
                           InsertIntoBookmark(bookmarkStart,keyValuePair.Value);
                           break;
                       }
                   }
               }
           }
       }
 /// <summary>
       /// 更换书签单一文本内容
       /// </summary>
       /// <param name="bookmarkStart">书签</param>
       /// <param name="text">书签内容文本</param>
       private static void InsertIntoBookmark(BookmarkStart bookmarkStart, string text)
       {
           OpenXmlElement elem = bookmarkStart.NextSibling();
           while (elem != null && !(elem is BookmarkEnd))
           {
               OpenXmlElement nextElem = elem.NextSibling();
               elem.Remove();
               elem = nextElem;
           }
           bookmarkStart.Parent.InsertAfter<DocumentFormat.OpenXml.Wordprocessing.Run>(new DocumentFormat.OpenXml.Wordprocessing.Run(new DocumentFormat.OpenXml.Wordprocessing.Text(text)), bookmarkStart);
       }

  

五:OpenXml Sdk 使用(插入图片)

  根据步骤四中新建2个图片书签位置,具体代码如下:

  

  

 /// <summary>
       /// 
       /// </summary>
       /// <param name="filepPath"></param>
       /// <param name="dictionary"></param>
       public static void InsertImage(string filepPath, Dictionary<string, string> dictionary,byte [] byteArrary=null)
       {
           using (WordprocessingDocument wordprocessingDocument = WordprocessingDocument.Open(filepPath, true))
           {
               List<BookmarkStart> allBookmarkStart = wordprocessingDocument.MainDocumentPart.RootElement.Descendants<BookmarkStart>().ToList();
               {
                   foreach (KeyValuePair<string, string> keyValuePair in dictionary)
                   {
                       foreach (BookmarkStart bookmarkStart in allBookmarkStart)
                       {
                           if (bookmarkStart.Name.Value == keyValuePair.Key)
                           {
                               byte[] imageByte = Convert.FromBase64String(keyValuePair.Value);
                               MainDocumentPart mainPart = wordprocessingDocument.MainDocumentPart;
                               ImagePart imagePart = mainPart.AddImagePart(ImagePartType.Jpeg);
                               Stream stream = new MemoryStream(imageByte);
                               if (byteArrary != null)
                               {
                                   stream = new MemoryStream(byteArrary);
                               }
                               imagePart.FeedData(stream);
                               AddImageToBody(wordprocessingDocument, wordprocessingDocument.MainDocumentPart.GetIdOfPart(imagePart), bookmarkStart);
                               break;
                           }
                       }
                   }
               }
           }
       }
  /// <summary>
       /// 
       /// </summary>
       /// <param name="wordDoc"></param>
       /// <param name="relationshipId"></param>
       /// <param name="bookmarkStart"></param>
       private static void AddImageToBody(WordprocessingDocument wordDoc, string relationshipId, BookmarkStart bookmarkStart)
       {
           // Define the reference of the image.
           var element =
              new Drawing(
                new Inline(
                  new Extent() { Cx = 4900000L, Cy = 3920000L }, // 调节图片大小
                  new EffectExtent()
                  {
                      LeftEdge = 0L,
                      TopEdge = 0L,
                      RightEdge = 0L,
                      BottomEdge = 0L
                  },
                  new DocProperties()
                  {
                      Id = (UInt32Value)1U,
                      Name = "Picture 1"
                  },
                  new DocumentFormat.OpenXml.Drawing.Wordprocessing.NonVisualGraphicFrameDrawingProperties(
                    new GraphicFrameLocks() { NoChangeAspect = true }),
                  new Graphic(
                    new GraphicData(
                      new DocumentFormat.OpenXml.Drawing.Pictures.Picture(
                        new PIC.NonVisualPictureProperties(
                          new PIC.NonVisualDrawingProperties()
                          {
                              Id = (UInt32Value)0U,
                              Name = "New Bitmap Image.jpg"
                          },
                          new DocumentFormat.OpenXml.Drawing.Pictures.NonVisualPictureDrawingProperties()),
                        new DocumentFormat.OpenXml.Drawing.Pictures.BlipFill(
                          new DocumentFormat.OpenXml.Drawing.Blip(
                            new DocumentFormat.OpenXml.Drawing.BlipExtensionList(
                              new DocumentFormat.OpenXml.Drawing.BlipExtension()
                              {
                                  Uri =
                                   "{28A0092B-C50C-407E-A947-70E740481C1C}"
                              })
                          )
                          {
                              Embed = relationshipId,
                              CompressionState =
                              DocumentFormat.OpenXml.Drawing.BlipCompressionValues.Print
                          },
                          new DocumentFormat.OpenXml.Drawing.Stretch(
                            new DocumentFormat.OpenXml.Drawing.FillRectangle())),
                        new PIC.ShapeProperties(
                          new DocumentFormat.OpenXml.Drawing.Transform2D(
                            new A.Offset() { X = 0L, Y = 0L },
                            new A.Extents() { Cx = 990000L, Cy = 792000L }), //与上面的对准
                          new A.PresetGeometry(
                            new A.AdjustValueList()
                          ) { Preset = A.ShapeTypeValues.Rectangle }))
                    ) { Uri = "http://schemas.openxmlformats.org/drawingml/2006/picture" })
                )
                {
                    DistanceFromTop = (UInt32Value)0U,
                    DistanceFromBottom = (UInt32Value)0U,
                    DistanceFromLeft = (UInt32Value)0U,
                    DistanceFromRight = (UInt32Value)0U,
                    EditId = "50D07946"
                });
           //bookmarkStart.InsertAfterSelf(new DocumentFormat.OpenXml.Wordprocessing.Paragraph(new DocumentFormat.OpenXml.Wordprocessing.Run(element)));
           //bookmarkStart.Parent.InsertAfter<DocumentFormat.OpenXml.Wordprocessing.Run>(new DocumentFormat.OpenXml.Wordprocessing.Paragraph(new DocumentFormat.OpenXml.Wordprocessing.Run(element)), bookmarkStart);
           bookmarkStart.Parent.InsertAfter<DocumentFormat.OpenXml.Wordprocessing.Run>(new DocumentFormat.OpenXml.Wordprocessing.Run(new DocumentFormat.OpenXml.Wordprocessing.Run(element)), bookmarkStart);
       }

   注:  图片的长度和宽度都乘以9525之后导入到word里的图片显示为100%。 

六:OpenXml Sdk 使用(根据表格写入数据)

  首先给已有表格插入书签

  

  

/// <summary>
       /// 
       /// </summary>
       /// <param name="filepPath"></param>
       /// <param name="configModel"></param>
       /// <param name="dataModelList"></param>
       public static void InsertTable(string filepPath, ConfigModel configModel, List<TableDataModel> dataModelList)
       {
           using (WordprocessingDocument wordprocessingDocument = WordprocessingDocument.Open(filepPath, true))
           {
               Body body = wordprocessingDocument.MainDocumentPart.Document.Body;
               List<BookmarkStart> allBookmarkStart = wordprocessingDocument.MainDocumentPart.RootElement.Descendants<BookmarkStart>().ToList();
               //通过索引获得table
               //var table = body.Elements<DocumentFormat.OpenXml.Wordprocessing.Table>().ElementAt(configModel.Index);
               //通过标签获得table
               BookmarkStart bookmarkStart = allBookmarkStart.Find(a => a.Name.Value == configModel.tableBookMark);
               if (bookmarkStart == null)
                   return;
               var table = bookmarkStart.Parent.Parent.Parent.Parent;

               //List<DocumentFormat.OpenXml.Wordprocessing.TableRow> rowList = table.Elements<DocumentFormat.OpenXml.Wordprocessing.TableRow>().ToList();
               //row = rowList[1].Clone() as DocumentFormat.OpenXml.Wordprocessing.TableRow;
               foreach (TableDataModel tableDataModel in dataModelList)
               {
                   var row = table.Elements<DocumentFormat.OpenXml.Wordprocessing.TableRow>().ElementAt(configModel.StartRowIndex).Clone() as DocumentFormat.OpenXml.Wordprocessing.TableRow;
                   var cells = row.Elements<DocumentFormat.OpenXml.Wordprocessing.TableCell>();
                   for (int i = 0; i < cells.Count(); i++)
                   {
                       var cell = cells.ElementAt(i);
                       //DocumentFormat.OpenXml.Wordprocessing.TableCell cellCreate = new DocumentFormat.OpenXml.Wordprocessing.TableCell();
                       //cellCreate.Append(new DocumentFormat.OpenXml.Wordprocessing.Paragraph(new DocumentFormat.OpenXml.Wordprocessing.Run(new DocumentFormat.OpenXml.Wordprocessing.Text(DateTime.Now.ToString()))));
                       //row.Append(cell);
                       //cell = cellCreate;

                       DocumentFormat.OpenXml.Wordprocessing.Paragraph tmpPa = cell.Elements<DocumentFormat.OpenXml.Wordprocessing.Paragraph>().First();
                       var tmpRuns = tmpPa.Elements<DocumentFormat.OpenXml.Wordprocessing.Run>();
                       if (tmpRuns.Count() <= 0)
                       {
                           tmpPa.Remove();
                           tmpPa = new DocumentFormat.OpenXml.Wordprocessing.Paragraph(new DocumentFormat.OpenXml.Wordprocessing.Run(new DocumentFormat.OpenXml.Wordprocessing.Text(" ")));
                           //cell.RemoveAllChildren();
                           cell.Append(tmpPa);

                       }
                       var tmpRun = tmpPa.Elements<DocumentFormat.OpenXml.Wordprocessing.Run>().First();
                       var tmpText = tmpRun.Elements<DocumentFormat.OpenXml.Wordprocessing.Text>().First();

                       //获取属性值
                       Type type = tableDataModel.GetType();
                       string propertyKey = "Property" + (i + 1);
                       System.Reflection.PropertyInfo propertyInfo = type.GetProperty(propertyKey); //获取指定名称的属性
                       object objValue = propertyInfo.GetValue(tableDataModel, null);
                       if (objValue != null)
                       {
                           tmpText.Text = objValue.ToString();
                       }
                       else
                       {
                           tmpText.Text = "-";
                       }
                   }
                   //DocumentFormat.OpenXml.Wordprocessing.TableRow rowx = new DocumentFormat.OpenXml.Wordprocessing.TableRow();
                   //string[] rowArray = { "","","",""};
                   //foreach (string strCell in rowArray)
                   //{
                   //    DocumentFormat.OpenXml.Wordprocessing.TableCell cell = new DocumentFormat.OpenXml.Wordprocessing.TableCell();
                   //    cell.Append(new DocumentFormat.OpenXml.Wordprocessing.Paragraph(new DocumentFormat.OpenXml.Wordprocessing.Run(new DocumentFormat.OpenXml.Wordprocessing.Text(strCell))));
                   //    row.Append(cell);
                   //}
                   //table.Append(rowx);

                   var lastRow = table.Elements<DocumentFormat.OpenXml.Wordprocessing.TableRow>().Last();
                   table.InsertAfter<DocumentFormat.OpenXml.Wordprocessing.TableRow>(row, lastRow);
               }
               //最后删除startIndex行
               table.Elements<DocumentFormat.OpenXml.Wordprocessing.TableRow>().ElementAt(configModel.StartRowIndex).Remove();
           }
       }

  最后源码下载地址:http://files.cnblogs.com/files/sunyj/OpenXmlWord.rar

  相关资料网址:https://msdn.microsoft.com/en-us/library/bb497430(office.14).aspx


作者:青春岁月,无怨无悔,发布于:2018/08/31
原文:https://www.cnblogs.com/sunyj/p/5069951.html