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

Chapter 6. Working with XML Data in Excel Spreadsheets

Chapter 6. Working with XML Data in Excel Spreadsheets

Microsoft Office Excel 2003 offers two rather different kinds of XML functionality. Excel (in the Professional and Enterprise editions) allows users to build spreadsheets that load data from XML files, making it easy to analyze information sent from various sources using the same spreadsheet. The data that a spreadsheet analyzes can be separated from the logic used to analyze it very easily this way, making it simpler to create spreadsheets that work more like ordinary applications. Excel 2003 (and XP) also offer the ability to save and open spreadsheets which are themselves saved in Excel's own XML format; these features will be explored in Chapter 7.

The features described in this chapter are available only to users of the Professional or Enterprise editions of Microsoft Office Excel. Sadly, the Standard edition does not include these capabilities. If you have problems finding the XML features in your copy of Excel, check to see which edition you're using. (The Small Business Edition appears to include the Standard, not the Professional, version.)



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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