SpreadsheetML
Back to TOCAll TopicsCondensed TOC
The markup language within Open XML for spreadsheets.
- Updating Data for an Embedded Chart in an Open XML WordprocessingML Document
- How to Create Protected Spreadsheets with Locked and Unlocked Cells
- Exploring Table Markup in Open XML SpreadsheetML
- Query Open XML Spreadsheets in VB.NET using LINQ
- Screen-Cast: Write Simpler SpreadsheetML when Generating Spreadsheets
Embedding charts in a word-processing document is a good way to put together documents that display graphical data. When you embed a chart in a document, an Open XML SpreadsheetML workbook is stored as an embedded part in the WordprocessingML document. The spreadsheet contains the data behind the chart. When you maintain that data, Word starts Excel, opening that embedded spreadsheet. (Video)
7-minute video that shows markup related to protected sheets with locked and unlocked cells. (Article,Video)
Tables are a convenient and useful feature of Open XML SpreadsheetML. This post explores table markup, and links to a screen-cast that shows how to create a table programmatically
(Video)
(Video)
When working with SpreadsheetML, one of the most common needs is to retrieve the data from a worksheet or a table in as easy a fashion as possible. There has been a fair amount written for C# developers to do this, but not nearly as much for VB.NET. (Video)
This screen-cast presents a small tip that can make it easier to write code to generate SpreadsheetML. You can avoid the complications of updating the shared string table by using the idea in this tip. (Video)