Menu
I want to know if there is anything that you cannot do with SDK that was exposed in the COM interface?
578
ClosedXML is an open source library created based on OpenXmlSdk. It's more user friendly. ClosedXML is a . NET library for reading, manipulating and writing Excel 2007+ (.
Open XML SDK 2.0 for Microsoft Office All functions available in version 1.0 are still supported.
The Open XML SDK 2.5 simplifies the task of manipulating Open XML packages and the underlying Open XML schema elements within a package. The Open XML SDK 2.5 encapsulates many common tasks that developers perform on Open XML packages, so that you can perform complex operations with just a few lines of code.
Today MS Open Tech has announced the release of the Open XML SDK version 2.5 as open source software (Apache 2.0 license) under the stewardship of the . NET Foundation.
The OpenXML SDK is a convenience layer for the OpenXML file format. Using this SDK you can do everything that is possible to do with the file format, e.g. insert, modify and remove content, metadata and formatting.
In contrast to COM automation of Office you can't do anything that is related to application logic. To give you some examples: Using the OpenXML SDK, you can't know the page number of a certain element in a text document because that would require pagination, you can't recalculate the formulas of a spreadsheet because that requires Excel's math engine, or you can't convert a presentation slide into an image because that requires PowerPoint to render the slide.
Regarding Word, you can have a look at the following presentation which demonstrates when to use the OpenXML SDK vs. Office automation:
Open XML SDK + Word Automation Services Presentation at PDC
178
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
