• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Working with XML Data in Exc... > Analyzing XML Data with Microsoft Ex...

Analyzing XML Data with Microsoft Excel

XML and Microsoft Excel workbooks are both designed to handle structured data, which makes Excel a natural choice to present XML data in its familiar pattern of worksheet columns, rows, and cells. However, because XML documents contain elements that can be related to other elements that don’t lend themselves to a row-and-column layout, Excel must use a special algorithm to “flatten” XML data into a two-dimensional representation. Excel can avoid using the flattening algorithm if the XML data you’re working with adheres to a schema created by Microsoft. I’ll describe this schema later in the chapter.

Understanding and Working with the XML Spreadsheet Flattener

You can open any well-formed XML file in Excel 2002. To do so, click Open on the File menu and then select XML Files in the Files Of Type list. Once you open the XML file in Excel, you can analyze the XML data as if it were native Excel data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint