O'Reilly logo

XML in Office 2003: Information Sharing with Desktop XML by Priscilla Walmsley, Charles F. Goldfarb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required