O'Reilly logo

Office 2003 XML by Evan Lenz, Mary McRae, Simon St. Laurent

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Editing XML Maps with SpreadsheetML

SpreadsheetML is primarily useful for getting information into and out of Excel from other programs. In general, it’s hard to imagine why you’d prefer to edit SpreadsheetML directly when Excel’s graphical interface offers a much easier way to see and edit your information. There is, however, one case where Excel doesn’t provide a graphical interface, and the SpreadsheetML provides a useful way to edit information that isn’t otherwise accessible. Figure 7-9 shows a spreadsheet from Chapter 6 that uses an XML Map.

A spreadsheet using an XML Map, previously shown in Figure 6-25

Figure 7-9. A spreadsheet using an XML Map, previously shown in Figure 6-25

Example 7-12 shows a portion of the SpreadsheetML that is produced when you save the spreadsheet itself as SpreadsheetML.

Example 7-12. Part of the SpreadsheetML for a spreadsheet containing an XML Map

 <Worksheet ss:Name="Sheet1"> <Names> <NamedRange ss:Name="_FilterDatabase" ss:RefersTo="=Sheet1!R1C1:R2C8" ss:Hidden="1"/> </Names> <Table ss:ExpandedColumnCount="8" ss:ExpandedRowCount="2" x:FullColumns="1" x:FullRows="1"> <Column ss:AutoFitWidth="0" ss:Width="79.5"/> <Column ss:AutoFitWidth="0" ss:Width="75"/> <Column ss:AutoFitWidth="0" ss:Width="78"/> <Column ss:AutoFitWidth="0" ss:Width="58.5"/> <Column ss:AutoFitWidth="0" ss:Width="55.5"/> <Column ss:AutoFitWidth="0" ss:Width="38.25"/> <Column ss:AutoFitWidth="0" ss:Width="99.75"/> <Column ss:AutoFitWidth="0" ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required