Skip to Main Content
XML in Office 2003: Information Sharing with Desktop XML
book

XML in Office 2003: Information Sharing with Desktop XML

by Charles F. Goldfarb, Priscilla Walmsley
December 2003
Beginner to intermediate content levelBeginner to intermediate
576 pages
9h 46m
English
Pearson
Content preview from XML in Office 2003: Information Sharing with Desktop XML

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Office 2003 XML

Office 2003 XML

Simon St. Laurent, Mary McRae, Evan Lenz
Essential XML: Beyond Markup

Essential XML: Beyond Markup

Don Box, Aaron Skonnard, John Lam

Publisher Resources

ISBN: 013142193XPurchase book