Office Open XML (OOXML) Tools

Access, Edit, Transform, and Query OOXML

  • Accessing Open XML in Microsoft Word (.docx)
  • Accessing Open XML in Excel (.xlsx)
  • Accessing Open XML in PowerPoint (.pptx)
  • Editing XML data in OOXML archives
  • Intelligent XML editing in Text and Grid Views
  • Intelligent XML editing in Text and Grid Views
  • XSLT development for OOXML
  • XQuery development for OOXML
  • Archive View for OOXML & any zipped archive

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.

Archive View

The XMLSpy Archive View provides native support creating and editing zipped archives such as Office (version 2007 and higher) or WinZip files. Individual files can be opened from the Archive View, edited in one of XMLSpy's editing views, and then saved directly back to the ZIP archive.

You may also add and delete files and folders in the archive.

The Archive View displays included folders in an expandable tree view, and documents contained in the selected folder are listed with size and data details. Below that, an info window can be toggled on or off to view general information about the zipped archive, such as the number of files it contains, its uncompressed and compressed sizes, and the compression ratio, as well as document metadata (i.e., properties) for Microsoft Office documents.

Access OOXML in Office docs like Excel and Word

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.

Transforming Open XML

XMLSpy includes robust support for XSLT and XQuery development, debugging, and profiling, allowing you to develop and test transformations and queries against Open XML /OOXML data. This support allows you to, for example, create an XSLT 2.0 transformation to publish data in a Word, Excel, or PowerPoint document to HTML on the Web or a corporate intranet, or use XQuery to extract and aggregate financial data from an Excel document and provide it in an XML form suitable for mapping to EDI messages or Web services functions.

These capabilities are extremely important and useful. XMLSpy is the first tool that allows developers to unleash all the power of XSLT 2.0/3.0 and XQuery on the vast, ever-increasing amount of data stored in Microsoft Office documents, giving you the ability to develop applications that process what has become the predominant business data format.