[dba-VB] Open XML Format SDK for .Net (Office 2007 docs)

Gustav Brock Gustav at cactus.dk
Thu Jun 26 01:21:13 CDT 2008


Hi all

Woody's Office Watch posted this:

<quote>
Programming tools for Office 2007 documents now available
See this article online 
http://news.office-watch.com/t/n.aspx?a=639

Microsoft has released a set of programming tools to let developers
work with Office 2007 documents without the Office applications
themselves.

The Open XML SDK v1.0 is available from here with information and
'how to' over here. It works in any language supported by the
.net framework.  The Software Development Kit lets you access Word,
Excel and Powerpoint documents from programs. You could extract data,
add or replace text and many other things. 

Chances are good you'd do many of these things inside an Office VBA
program but that can be quite slow and requires an Office license on
each computer it's running. A separate program using the SDK can do
the job faster and without more Office licenses.

In practice, the SDK is mainly useful for companies that want to link
Office documents with other non-Office systems. The 'How do I *'
page is especially useful with answers to particular questions:
http://msdn.microsoft.com/en-us/library/bb491088.aspx

As you'd expect from Microsoft, version 1.0 isn't the end of the
matter. There'll be a v2 of the SDK later this year and yet another
with the next version of Office (aka Office 14).
</quote>

Download is here:
http://www.microsoft.com/downloads/details.aspx?FamilyId=AD0B72FB-4A1D-4C52-BDB5-7DD7E816D046&displaylang=en

<quote>
The 2007 Microsoft® Office system introduces a new file format that is
based on XML called Open XML Formats. Microsoft Office Word 2007,
Microsoft Office Excel® 2007, and Microsoft Office PowerPoint® 2007 all
use these formats as the default file format. 

Open XML formats are useful for developers because they are an open
standard and are based on well-known technologies: ZIP and XML.
Microsoft provides a library for accessing these files as part of the
WinFX technologies in the System.IO.Packaging namespace. 

The Open XML Format SDK is built on top of the System.IO.Packaging API
and provides strongly typed part classes to manipulate Open XML
documents.
</quote>

/gustav




More information about the dba-VB mailing list