he Excel XML Toolbox for Microsoft Office Excel 2003 provides many useful tools for working with XML in Excel. This toolbox helps developers in a number of ways:
Working with Custom-defined XML Schema
* Reload schema into workbooks while preserving cell mappings.
* Build a schema or add to an existing schema, directly from Excel.
* View the schema for XML maps stored within workbooks.
Working with XML and the Excel Object Model
* Quickly refresh all XML maps with bound data sources.
* Refresh XML maps with bound data sources and persist cell formulas for mapped cells.
* Use a new XML Range Properties tool to view XML mapped cell properties and to copy the XPath or Microsoft Visual Basic for Applications (VBA) statement to the Clipboard.
* View the exportable XML data without exporting.
Working with SpreadsheetML
* Quickly save the Workbook as SpreadsheetML.
* View the SpreadsheetML for the active workbook.
Shortcuts and More
* Quickly open and close the XML Source task pane.
* Turn on and off the borders for XML mapped cells.
* Import and export XML.