Chapter 7. Using XML data in spreadsheets Excel Power User Task

  • Mapping between XML and worksheets

  • Flattening structure for data analysis

  • XMLSS: The Excel XML vocabulary

Narrative text may be the most flexible way to communicate data, but when you want to see how it all lines up, there is nothing quite like a spreadsheet. It was the original “killer app” for the PC, and now, with a strong shot of XML, it is more powerful and useful than ever.

This chapter teaches you how to create worksheets that import and export XML data. Excel makes it easy: you don’t have to write scripts or code to work with XML.

And XML import means you can use Excel’s advanced capabilities for data analysis on almost any data, whether it comes from a database, Web service, or ...

Get XML in Office 2003: Information Sharing with Desktop XML now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.