Page 37 - Microsoft Office Excel 2003 Programming Inside Out
P. 37

Part 1:  Preliminaries
                                                   What’s New in Excel 2003

                             This schema tells Excel to expect three data elements for a data structure named productType:
                             productId, productName, and priceEach. The complexType statement names the data struc­
                             ture, whereas element definition statements give you the name of the element and the   Chapter 1
                             expected data type (in this case, either a string or a decimal value), while the <xs:sequence>
                             statement tells Excel to expect the elements in exactly that order every time.

                    Publishing Spreadsheets with Web Components

                             Technically part of the Microsoft Office program suite, rather than Excel, the Office Web
                             Components available for your use in Excel 2003 offer updated functionality that make it
                             possible for you to publish Web pages that behave like spreadsheets. There are three
                             Web components available in Office 2003: PivotTable Lists, Spreadsheets, and Charts.
                             A fourth component, the Data Source Component, provides database access for Web-based
                             PivotTable lists.
















































                                                                                                        11
   32   33   34   35   36   37   38   39   40   41   42