Elerium Excel .NET Reader

» Allow to read Excel files XLS, XLSX, CSV (without references to third-party libraries).
» Supported Excel file formats XLS, XLSX, CSV.
» Available in C# and VB.NET (see Examples in Learning Center).
» Free future Updates and Support.
Overview Download PRICES Learning Center Demo

Export Excel data to DataTable

Excel .NET Reader presents an easy way to export Excel data to DataTable. Just use Worksheet's method WriteToDataTable().

How to read XLSX files

To read XLSX files use method ReadXLSX().

Font and Formats of Excel Cell data

This sample demonstrates reading of different cell properties such as Alignment, Rotation, Number format, Font name, size, color ...

Excel Cell Color and Background

It's easy to read background color and filling of Excel cells using Elerium Excel .NET Reader component.

Borders & Merger in Excel

This sample shows how to get information about cell borders, its style and color.

Open Excel file protected by Password

The component can read excel XLS and XSLX protected by Password.

GridView/DataTable with headers

This sample shows how to export data from excel to DataTable and fill DataTable headers. For example, the first row of excel file is a header for the table.
 1  
 
© Copyright 2017 | Elerium Software | All Rights Reserved.