Essential XlsIO is a native .NET class library that can be used to create and modify Microsoft Excel files by using C#, VB.NET and managed C++ code. It is a non-UI component that provides a full-fledged object model that facilitates accessing & manipulating the spreadsheets without any dependency of Microsoft Office COM libraries & Microsoft Office.

The library can be used in Windows Forms, WPF, UWP, ASP.NET Web, ASP.NET MVC, ASP.NET Core and Xamarin application.

Key Features

  • Support to create Excel documents from scratch.
  • Modifying existing workbooks.
  • Support to import and export data.
  • Supports Excel formulas.
  • Create & manipulate Conditional Formats.
  • Create & manipulate Data Validations.
  • Create & manipulate Charts and Sparklines.
  • Create & manipulate Pivot Tables, Pivot Charts.
  • Fill data using Template Markers.
  • Clone and merge worksheets.
  • Encrypt and decrypt Excel documents.
  • Convert Excel worksheets to images.
  • Convert chart in a worksheet to image.
  • Supports data filtering.
  • Supports data sorting.
  • Support to add Images, AutoShapes, Ole objects, Comments and other drawing objects.
  • Convert Excel workbook to PDF.
  • Convert Excel worksheet to HTML.
  • Support to open and create CSV, SpreadsheetML files.
  • Access the Built-in and Custom 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