Contains information about references and links to other workbooks and data sources.
Contained In
Subelements
ExternName, Path, SheetName, Xct
Remarks
All subelements are required. More than one ExternName, SheetName, and Xct subelement can be specified.
This example shows a description of data from a workbook called Book2.xls. There are three worksheets in the workbook called Sheet1, Sheet2, and Sheet3. Sheet1 has 4 cells that are referenced, but the other two worksheets do not contain referenced data. The cell at row 0, column 0 ("A1") contains the number 1. The cell at row 0, column 3 ("D1") contains the text string "My Chart". The cell at row 1, column 5 ("F2") contains the Boolean value TRUE. The cell at row 3, column 0 ("A4") contains the number 4.
<x:SupBook>
<x:Path>Book2.xls</x:Path>
<x:SheetName>Sheet1</x:SheetName>
<x:SheetName>Sheet2</x:SheetName>
<x:SheetName>Sheet3</x:SheetName>
<x:Xct>
<x:Count>4</x:Count>
<x:SheetIndex>0</x:SheetIndex>
<x:Crn>
<x:Row>0</x:Row>
<x:ColFirst>0</x:ColFirst>
<x:ColLast>0</x:ColLast>
<x:Number>1</x:Number>
</x:Crn>
<x:Crn>
<x:Row>0</x:Row>
<x:ColFirst>3</x:ColFirst>
<x:ColLast>3</x:ColLast>
<x:Text>My Chart</x:Text>
</x:Crn>
<x:Crn>
<x:Row>1</x:Row>
<x:ColFirst>5</x:ColFirst>
<x:ColLast>5</x:ColLast>
<x:Boolean>TRUE</x:Boolean>
</x:Crn>
<x:Crn>
<x:Row>3</x:Row>
<x:ColFirst>0</x:ColFirst>
<x:ColLast>0</x:ColLast>
<x:Number>4</x:Number>
</x:Crn>
</x:Xct>
<x:Xct>
<x:Count>0</x:Count>
<x:SheetIndex>1</x:SheetIndex>
</x:Xct>
<x:Xct>
<x:Count>0</x:Count>
<x:SheetIndex>2</x:SheetIndex>
</x:Xct>
</x:SupBook>
This example shows a description of a linked workbook called Book4.xls containing a Microsoft Excel 97 worksheet. The workbook is in the C:\My Documents folder. The link is an automatic OLE link and the data is in clipboard format 2.
<x:SupBook>
<x:Path>Excel.Sheet.8|C:\My Documents\Book4.xls</x:Path>
<x:ExternName>
<x:Name>'</x:Name>
<x:WantAdvise/>
<x:WantPict/>
<x:Cf>2</x:Cf>
<x:OleLink/>
</x:ExternName>
</x:SupBook>