Open Source .NET Library for Reading Excel Spreadsheets
ExcelDataReader allows you read Microsoft Excel file formats using C#.
ExcelDataReader is an open source lightweight API written in C# for reading Microsoft Excel Files. Using the API you can read Microsoft XLS, XLSX, and CSV easily. The API supports older versions of XLS files back to Excel 2.0, supports text dates, cached formula values and empty sheet paths in XLSX.
Furthermore, the API supports fallback encoding in XLS and more flexible column name handling in Datasets. It is easy to configure and is available on NuGet.
At A Glance
An overview of ExcelDataReader features.
- Read Excel
- Date Create on Mac
- Text Dates
- Cached Formula
- Empty Sheets Path
- Fallback Encoding
- Column Handling
- Password Protection
- Timespan values
ExcelDataReader is cross platform API and canbe used with Windows with .Net Framework 2, Windows Mobile with Compact Framework, Linux, OS X, and BSD with Mono 2+
Getting Started with ExcelDataReader
The recommended way to install ExcelDataReader is from Nuget, Please use the following command for fasters installation.
Install ExcelDataReader from NuGet
Install-Package ExcelDataReader -Version 3.6.0
Read Excel Files via .NET API
ExcelDataReader allows C# .NET developers to read Microsoft Excel Files easily and efficiently. The AsDataSet() extension method is a convenient helper for quickly getting the data. IExcelDataReader extends the System.Data.IDataReader and IDataRecord interfaces to navigate and retrieve data at a lower level.
Read Protected Workbooks
The open source .NET API ExcelDataReader also allows you to read password protected Microsoft Excel documents.You can read password protected file using setting password in ExcelReaderConfiguration configuration and opening it using CreateOpenXmlReader() method.