Spreadsheets (Open XML SDK)

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

In this section

• 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

• How do I...
• Getting started with the Open XML SDK 2.5 for Office