Why Not Open XML SDK

Contents
[ ]

What is Open XML SDK? According to the MSDN Library, Open XML SDK is defined as:The Open XML SDK 2.0 simplifies the task of manipulating Open XML packages and the underlying Open XML schema elements within a package. The Open XML SDK 2.0 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.OOXML documents are essentially zipped XML files and Open XML SDK is a collection of classes that allows you to work with the content of OOXML documents in a strongly-typed way. That is instead of unzipping a file to extract XML, loading that XML into a DOM tree and working with XML elements and attributes directly, Open XML SDK provides classes to do that.

Compare Open XML SDK and Aspose.Words

Feature or Feature Category Open XML SDK Aspose.Cells
Supported Excel or other formats XLSX XLS, CSV, SpreadsheetML 2003, XLSX, HTML, Tab Delimited, ODS, Plain Text (TXT), PDF, XPS
Convert between Excel formats No Yes

High-level programming with a workbook object model:

- Find and replace.

- Assemble spreadsheets.

- Copy fragments and worksheets between workbooks.

No Yes
Detailed programming with a document object model, access to individual elements and formatting properties of all spreadsheet elements. Yes Yes
Low-level direct and full access to the underlying XML elements and attributes such as relationship identifiers, list identifiers of an OOXML document. Yes No

Generate reports, populate documents with data:

- Import/Export data to/from a DataTable / ResultSet.

- Smart Markers feature.

- Insert/Delete Rows/Columns/Ranges.

- Custom data sources.

No Yes

Rendering and Printing:* Render worksheet pages to raster images (TIFF, multipage TIFF, PNG, JPEG, BMP).* Render spreadsheet pages to vector images (EMF).* Convert charts to images (TIFF, multipage TIFF, PNG, JPEG, BMP, EMF etc.)

- Specify image resolution, quality, compression and other options.

- Print spreadsheets using the .NET printing infrastructure. The component has built-in print method to print the worksheets as shown in Print Preview of MS Excel.

No Yes
Calculate/ Recalculate formulas dynamically No Yes
Supported platforms Windows, .NET Windows, Linux, Java, .NET, Mono

Conclusion