Lightweight and fast library written in C# for reading Microsoft Excel files
Highlights in ExcelDataReader 3.7.0-develop00385 since ExcelDataReader 3.7.0-develop00365:
Highlights in ExcelDataReader 3.7.0-develop00371 since ExcelDataReader 3.7.0-develop00365:
Highlights in ExcelDataReader 3.7.0-develop00365 since ExcelDataReader 3.7.0-develop00310:
Highlights in ExcelDataReader 3.7.0-develop00310 since ExcelDataReader 3.7.0-develop00306:
GetCellError()
method returns error enum for a cellHighlights in ExcelDataReader 3.7.0-develop00306 since 3.6.0:
GetCellStyle
method returns indent, horizontal alignment, hidden, locked for a cellHighlights in ExcelDataReader 3.6.0 since 3.5.0:
AnalyzeInitialCsvRows
configuration option can speed up reading large CSV filesHighlights in ExcelDataReader 3.5.0 since 3.4.2:
GetNumberFormatIndex()
method returns the index of the built-in or custom number format in a cellGetColumnWidth()
method returns the width of a column, or 0 if collapsed or hiddenFilterSheet
callback for AsDataSetLeaveOpen
option leaves the stream open after the IExcelDataReader object is disposedHighlights in ExcelDataReader 3.4.2 since 3.4.1:
Highlights in ExcelDataReader 3.4.1 since 3.4.0:
Highlights in ExcelDataReader 3.4.0 since 3.3.0:
MergeCells
property returns merged cell ranges in the current sheetRowCount
property returns number of rows in the current sheetFilterColumn
callback option for AsDataSet()