Relationships
An Excel 2007 document is made of parts. These parts are ???joined??? together via relationships
as defined in the various XML files we??™ve seen. The connection between a data table and the
worksheet it resides in is defined by a relationship.
Our root folder contains a _rels folder that contains a .rels file. This file defines relationships
between our document properties files, app.xml and core.xml, and the xl/workbook.xml
file. The xl folder itself contains a _rels folder that has a relationship file, workbook.xml.rels.
This file defines the relationships of the workbook, data, and formatting parts. Figure 3-25
shows an example of the workbook.xml.rels file.
Figure 3-25. Contents of the workbook.xml.rels file
From the Downloads section of this book??™s page on the Apress web site, copy the file
named NwindEmps01.xlsx to a local folder and rename it to NwindEmps.zip. This file contains
the same Northwind employee information as NwindEmps.xlsx, but this data was imported
from the Northwind Access database. Note the additional files reflecting the imported data
when we open it. I??™ve opened the file using WinZip, as shown in Figure 3-26.
Before we look at these new files, let??™s check the [Content_Types].xml file (shown in
Figure 3-27). Remember that this shows us all the various types of content we??™ll find in our
Excel project.
CHAPTER 3 n USING XML IN EXCEL 2007 125
Figure 3-26. Additional XML files with imported data highlighted
Figure 3-27.
Pages:
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149