Difference between revisions of "OpenXML"
From Blue-IT.org Wiki
(Created page with "This technology from microsoft == OpenXML SDK 2.0 == This is for Office 2010 and .NET 3.5 * http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=5124 He...") |
(→OpenXML SDK 2.0) |
||
Line 2: | Line 2: | ||
== OpenXML SDK 2.0 == | == OpenXML SDK 2.0 == | ||
− | This is for Office 2010 and .NET 3.5 | + | This is for Office 2010 and .NET 3.5. |
+ | |||
+ | After playing around with this I had recognized that the "(Microsoft) Office OpenXML File Format" is NOT really compatible with Microsoft office's produced documents, especially complexer documents. This leads to the problem, that even really simple Word or Excel documents in MS native xml format simple cannot be parsed or opened with the OpenXML SDK. Therefore you cannot parse them with the standard mechanisms given by the XML assemblies. To make it clear: stay completely with Microsoft native format and use COM or produce "Office Open XML Format" documents first, then check them with the '''Open XML SDK Productivty Tool''' which is available in your start menu when you installed the SDK. | ||
+ | |||
+ | For convenience: The '''Office Open XML Format'' IS NOT compatible with OpenOffice / Libreoffice , therefore use the in the microsoft world socalled ''OpenDocument Format'' (e. g. ODF 1.1, which is supported by Office 2010). If in practice the MS Office suite is really compatible will be part of a later research ;-) | ||
+ | |||
* http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=5124 | * http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=5124 |
Revision as of 08:02, 17 November 2015
This technology from microsoft
OpenXML SDK 2.0
This is for Office 2010 and .NET 3.5.
After playing around with this I had recognized that the "(Microsoft) Office OpenXML File Format" is NOT really compatible with Microsoft office's produced documents, especially complexer documents. This leads to the problem, that even really simple Word or Excel documents in MS native xml format simple cannot be parsed or opened with the OpenXML SDK. Therefore you cannot parse them with the standard mechanisms given by the XML assemblies. To make it clear: stay completely with Microsoft native format and use COM or produce "Office Open XML Format" documents first, then check them with the Open XML SDK Productivty Tool which is available in your start menu when you installed the SDK.
For convenience: The 'Office Open XML Format IS NOT compatible with OpenOffice / Libreoffice , therefore use the in the microsoft world socalled OpenDocument Format (e. g. ODF 1.1, which is supported by Office 2010). If in practice the MS Office suite is really compatible will be part of a later research ;-)
Here an article on how to use it:
"How to create a document from a template (dotx, dotm) and attach to it using Open XML SDK":