Skip to content
Pierlam-dev edited this page Dec 31, 2025 · 11 revisions

What is OpenExcelSdk ?

OpenExcelSdk is an open-source backend .NET library to use Excel (xlsx) very easily.

It's written in C#/NET8.

The only dependency is OpenXML SDK, the official Microsoft library to work with Excel files. The last available version 3.3.0 is used.

OpenXML SDK is a big library to manage Excel, Word and Power-Point documents. OpenExcelSdk is focus only on Excel documents.

This Microsoft library is not easy to use, so OpenExcelSdk propose a simple way to use Excel rows and cells values. Main use cases are to get/read or set a type, define a format and set a value into a new cell or an existing one.

OpenExcelSdk is a kind of wrapper around OpenXML SDK library. OpenExcelSdk offers light and basic framework, main classes are : ExcelFile, ExcelSheet, ExcelRow, ExcelCell. OpenXML SDK classes are always available in each of these classes: SpreadsheetDocument, Sheet, WorkbookPart, Sheet, Row, Cell, ...

Install the libray and start use it

This page explains how to install the lib from nuget.

Open or Create an Open excel file

This page explains how to create or open an excel file.

Create, get a sheet

This page explains how to create or get a sheet in an excel file.

Get a row

This page explains how get row one by one from a sheet.

Get a cell, the value and the type

This page explains how to get cell, value type and data format.

Set a value into a cell

This page explains how to set a value into a cell.

Cell Value Number Format

This page explains what is Number format.