Office Open XML (OOXML) Tools

Advantages of Office Open XML (OOXML)

Since the introduction of the Office Open XML formats in Microsoft Office, the vast amount of business data stored in Office files such as Word documents, Excel spreadsheets, and PowerPoint presentations is now saved as XML. This is a huge advantage for both business users and application developers, because, though business users still work with information through the familiar Office user interface, all their data is now standards-based and highly interoperable.

Each Office document is stored in a zipped archive that includes the user data in XML and other files with style information, images, etc. XMLSpy allows you to extract, edit, transform, and process the XML data stored in Office files (as well as any other zipped archive). These capabilities allow developers to work with the vast amount of data stored as OOXML in Word, Excel, and PowerPoint documents with full validation, intelligent entry helpers, and other useful features, and develop XSLT and XQuery transformations to publish the data or utilize it in other applications.

XMLSpy provides integrated support for accessing, editing, transforming, and querying XML data saved in Microsoft^® Office documents and other zipped files.

Open XML Editor

XMLSpy allows you to edit Open XML data in existing Word, Excel, and PowerPoint documents, or you can create new Office .docx, .xslx, and .pptx documents from scratch. Whether you prefer to work in Text View or Grid View, XMLSpy provides intelligent editing features including code auto-completion, intelligent entry helpers, validation, and more. Drop-down menus and entry helper windows offer valid editing choices depending on your location in the document, and the Info window offers an explanation of each element and its use in the OOXML file.

If you’re editing a file from an existing archive, your changes are automatically written back to the Zip file when you hit Save. It's also easy to add a new file via the Archive View.