Introduction to SpreadsheetML Series

ReturnThis page contains links to a set of introductory screen-casts on SpreadsheetML, which is the markup language for XLSX.

If you have not already done so, you may want to view the screen-casts that provide an overview of Open XML and Open Packaging Conventions:

1 Cells and Styles Shows how to represent cell values and format those values using styles.
2 Formulas Shows the details of cell formulas, evaluation and the calculation chain.
3 Pivot Tables Shows the organization of the pivot table parts and how to make some changes to it.
4 Pivot Table Layout Shows details about how to change the layout of pivot tables.
5 Charts Shows details about how charts are stored in a SpreadsheetML document.
6 Exploring Table Markup in Open XML SpreadsheetML Discusses Tables in a spreadsheet.
7 Precisely Placing Images in an Open XML Spreadsheet Sometimes you want to place an image on a worksheet. You want to be able to control exactly where the image is, its size, and in most cases, you want to preserve its aspect ratio.
8 Precisely Calculating Cell Sizes in Open XML SpreadsheetML Sometimes you need to calculate the cell sizes (in pixels) exactly in an Open XML spreadsheet. The most common use case is when placing graphics on a worksheet. You also need cell sizes in pixels when placing controls. In addition, understanding exactly how column widths and row heights work can help when generating spreadsheets. You can create spreadsheets that look exactly as you want.
9 Quick Generation of Spreadsheet Data and Cell Styles Discusses Tables in a spreadsheet.
10 SmlDataRetriever: Better Approach for Retrieving Spreadsheet Data This screen-cast discusses SmlDataRetriever, which makes it easier to get the data for a table or range from a workbook. It formats the values, providing the displayable form of each cell.