Example Sheet

Consider the following graphical representation of a worksheet:

Notice that cells A2 and A3 contain text. Cell B1 contains a formula linking to another workbook, whose value is 1. Cell B2 contains a formula as well; this formula appears in the formula bar (top of picture) because it is the active cell. Cells D5:H5 contain bold-faced text that serves as headers for the table of data residing in D6:H11. The table of data has a filter feature applied to it (evidenced by drop down arrows in the header row), and columns G and H have different types of conditional formatting applied. Finally, cells D13:H14 are part of a merged cell feature, where a series of cells behave together as a single, larger cell.

When saved, the above example will have the syntax below written out in the corresponding sheet part. Sheet information is organized into three main sections:

1. Top-level sheet properties (everything before <sheetData>)

2. The cell table (<sheetData>)

3. Supporting sheet features (everything after <sheetData>)

Therefore, the XML for the above example would look like this, broken into three sections: