wordpress hit counter
Simple OpenXML Library - using the Simple OOXML Library to create new documents - OpenXML Developer - Blog - OpenXML Developer
Goodbye and Hello

OpenXmlDeveloper.org is Shutting Down

There is a time for all good things to come to an end, and the time has come to shut down OpenXmlDeveloper.org.

Screen-casts and blog posts: Content on OpenXmlDeveloper.org will be moving to EricWhite.com.

Forums: We are moving the forums to EricWhite.com and StackOverflow.com. Please do not post in the forums on OpenXmlDeveloper.org. Instead, please post in the forums at EricWhite.com or at StackOverflow.com.

Please see this blog post for more information about my plans moving forward.  Cheers, Eric

Simple OpenXML Library - using the Simple OOXML Library to create new documents

Simple OpenXML Library - using the Simple OOXML Library to create new documents

Rate This
  • Comments 1

There is a recent project on Codeplex called Simple OOXML Library - http://simpleooxml.codeplex.com - that enables the creation of Word and Excel documents using the Open XML SDK v2.0. 

In the words of creator, James Westgate, the project 'provides a layer of abstraction over version 2.0 as a set of simple classes and methods to create new spreadsheet (Excel) and word processing (Word) files with the following benefits:

  1. No Excel or Word is required on the server.
  2. No in-depth knowledge of the OOXML standard or SDK is required.
  3. New documents can be created or existing templates can be modified.
  4. Ability to stream directly to the browser or between servers
  5. High performance
The following table outlines the classes used to create and read office open xml documents:

DocumentReader

Static functions used to create new word processing documents.

DocumentWriter

Static functions used to paste text items into a word processing document using bookmarks and save the document to a stream or file.

SpreadsheetReader

Static functions to create new spreadsheet documents and to retrieve worksheet, column and row references. Get style and defined name range parts.

SpreadsheetStyle

Create an object that can set style, color and font information in a spreadsheet and retrieve and compare style parts.

SpreadsheetWriter

Static functions to create style parts in a spreadsheet, control shared strings and helper functions when working with spreadsheet documents

WorksheetReader

High level and static fucntions to retrieve cell and style information from a worksheet.

WorksheetWriter

High level and static functions to write text, numeric and datatable based values to a worksheet. Draw borders, insert rows, merge cells and set print areas.