Spreadsheets

This section provides how-to topics for working with spreadsheet documents using the Open XML SDK for Office.

In this section

• Structure of a SpreadsheetML document

• Working with the calculation chain

• Working with conditional formatting

• Working with formulas

• Working with PivotTables

• Working with the shared string table

• Working with sheets

• Working with SpreadsheetML tables

• Calculate the sum of a range of cells in a spreadsheet document

• Create a spreadsheet document by providing a file name

• Delete text from a cell in a spreadsheet document

• Get a column heading in a spreadsheet document

• Get worksheet information from an Open XML package

• Insert a chart into a spreadsheet document

• Insert a new worksheet into a spreadsheet document

• Insert text into a cell in a spreadsheet document

• Merge two adjacent cells in a spreadsheet document

• Open a spreadsheet document for read-only access

• Open a spreadsheet document from a stream

• Parse and read a large spreadsheet document

• Retrieve a dictionary of all named ranges in a spreadsheet document

• Retrieve a list of the hidden rows or columns in a spreadsheet document

• Retrieve a list of the hidden worksheets in a spreadsheet document

• Retrieve the values of cells in a spreadsheet document

Related sections

• Getting started with the Open XML SDK for Office