SpreadsheetML
Back to TOCJust VideosCondensed TOC
The markup language within Open XML for spreadsheets.
- How to Extract Comments from Open XML Documents
- Automated Processing of Open XML Documents using PowerShell
- Using LINQ to Query Excel Tables
- Inner Join of Two Excel Tables
- Joining LINQ to SQL and LINQ to Excel
- Validate Open XML Documents using the Open XML SDK 2.0
- Table Markup in Open XML SpreadsheetML
- 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
How to Extract Comments from Open XML Documents (Article)
Processing Open XML documents using PowerShell is a powerful approach for creating, modifying, and transforming Open XML documents. The PowerTools for Open XML are examples and guidance that show how to do this. They consist of PowerShell cmdlets, and a number of example scripts that demonstrate the use of the cmdlets. Examples include automated word processing document and spreadsheet generation, and preparing documents for distribution external to a company, including removing comments, accepting revisions, applying a uniform theme to them, and applying a watermark to them. (Article)
Excel has a very cool feature where you can declare that a range of cells is a table. It is a feature that allows you to use Excel very much like a database. Because these tables are stored in Open XML documents, we can implement some simple extension methods and some classes so that we can query these tables using LINQ in a manner that is similar to querying a SQL database. This post presents a bit of code to do this. (Article)
I recently posted some code that allows you to use LINQ to query Excel tables. The source for these queries is the Open XML document – you don’t need to involve the Excel application to query the data in these tables. In that post, I presented a few examples of queries of various types. This post shows a join of two tables using the extension methods and classes presented in that post. (Article)
This post explains how to open the Excel spreadsheet, query a database using LINQ to SQL, and project a collection of an anonymous type that contains data from both data sources (Article)
Validate Open XML Documents using the Open XML SDK 2.0 (Article)
This post presents a summary of the Open XML SpreadsheetML markup that you use to define or query a table. (Article)
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)