Introduction to SpreadsheetML Series
Return This 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:
SpreadsheetML 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.