Page 18 - Microsoft Office Excel 2003 Programming Inside Out

Table of Contents

Adding Interactivity with the Web Components . . . . . . . . . . . . . . . . 534
Communicating with a Web Server. . . . . . . . . . . . . . . . . . . . . . . . . 536
Using Internet Solutions with Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . 537
Chapter 26
Excel and the Extensible Markup Language (XML) 539

Introducing Data Lists. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 539
Creating Data Lists Programmatically. . . . . . . . . . . . . . . . . . . . . . . 541
Creating XML Schemas. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 546
Creating XML Data Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 549
Adding XML to a Workbook Manually . . . . . . . . . . . . . . . . . . . . . . . . . . . 550
Importing XML Data Manually . . . . . . . . . . . . . . . . . . . . . . . . . . . . 552
Adding XML to a Worksheet Programmatically. . . . . . . . . . . . . . . . . . . . . 553
Mapping a Schema to a Worksheet Programmatically . . . . . . . . . . . 553
Mapping Schema Elements to Cells Using XPath . . . . . . . . . . . . . . 557

xviii