Office Open XML
Office Open XML (OOXML) Tools:
- Accessing OOXML in Microsoft Word (.docx)
- Accessing OOXML in Excel (.xlsx)
- Accessing OOXML in PowerPoint (.pptx)
- Editing XML data in OOXML archives
- Intelligent XML editing in Text and Grid Views
- XSLT and XQuery development for OOXML
- Archive View for any zipped archive
Office Open XML Development
XMLSpy® 2013 provides powerful support for accessing, editing, transforming, and querying XML data saved in Microsoft® Office 2007+ documents and other zipped files.
With 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.
The XMLSpy Archive View provides native support creating and editing zipped archives such as Office (version 2007 and higher) or WinZip files. Individual files in the archive 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.
Editing Office Open XML
XMLSpy allows you to edit Open XML data in existing Word, Excel, and PowerPoint (version 2007 or higher) 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 & Processing Office Open XML
XMLSpy includes robust support for XSLT 1.0/2.0 and XQuery development, debugging, and profiling, allowing you to develop and test transformations and queries against Open XML data. This support allows you to, for example, create an XSLT 2.0 transformation to publish data in a Word, Excel, or PowerPoint document 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 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.