Overview

14 Oct 20161 minute to read

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 and Microsoft Office.

Key Features

• Support to create Excel documents from scratch.
• Modifying existing workbooks.
• Support to import data.
• Supports Excel formulas.
• Create & manipulate Conditional Formats.
• Create & manipulate Data Validations.
• Create & manipulate Charts and Sparklines.
• Fill data using Template Markers.
• Clone and merge worksheets.
• Supports data filtering.
• Supports data sorting.
• Support to add Images, AutoShapes, Comments and other drawing objects.
• 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