-
Notifications
You must be signed in to change notification settings - Fork 0
Home
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, ...
This page explains how to install the lib from nuget.
This page explains how to create or open an excel file.
This page explains how to create or get a sheet in an excel file.
This page explains how get row one by one from a sheet.
This page explains how to get cell, value type and data format.