Overview of Excel Library (XlsIO)
24 Jul 20262 minutes to read
Essential® XlsIO is a native .NET class library used to create, read, edit, and modify Microsoft Excel files using C#, VB.NET, and managed C++. It is a non-UI component that provides a full-fledged object model for accessing and manipulating spreadsheets, with no dependency on Microsoft Office COM libraries or Microsoft Office.
The library can be used in Windows Forms, WPF, UWP, ASP.NET Web Forms, ASP.NET MVC, ASP.NET Core, Xamarin, Blazor, WinUI, and .NET MAUI applications.
Key Features
- Support to create Excel documents from scratch.
- Support to modify existing Excel documents.
- Support to import and export data.
- Supports Excel formulas.
- Ability to create and manipulate Conditional Formats and Data Validations.
- Create and manipulate Charts and Sparklines.
- Supports creation and manipulation of Tables, Pivot Tables and Pivot Charts.
- Fill data using Template Markers.
- Clone and merge Excel worksheets.
- Encrypt and decrypt Excel documents.
- Convert Excel worksheets to images.
- Convert chart in a worksheet to image.
- Supports data filtering and data sorting.
- Support to insert Images and AutoShapes.
- Support to add Comments and Form Controls.
- Support to add Ole objects and Group Shapes.
- Ability to convert Excel workbook to PDF.
- Converts Excel worksheet to HTML.
- Support to open and create CSV files.
- Support to open and create SpreadsheetML files.
- Access the Custom document properties of Excel file.
- Access the Built-in document properties.
Compatible Microsoft Excel Versions
- Microsoft Excel 97-2003
- Microsoft Excel 2007
- Microsoft Excel 2010
- Microsoft Excel 2013
- Microsoft Excel 2016
- Microsoft Excel 2019
- Microsoft 365
Supported File Formats
- XLSX
- XLSM
- XLS
- XLTX
- XLTM
- XLT
- CSV
- SpreadsheetML
- TSV
- XLSB (Limited support)
NOTE
You can also explore our .NET Excel Framework demo that shows how to create and modify Excel files from C# with 5 lines of code on different platforms.
NOTE
XlsIO can open and edit Microsoft Excel 97-2003 and later workbooks. Documents created in earlier versions of Excel (pre-97) are not supported.