一: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.msi和OpenXMLSDKTool.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