See also the configuration options FallbackEncoding and AutodetectSeparators. Use ExcelReaderFactory.CreateCsvReader instead of CreateReader to parse a stream of plain text with comma separated values. The result of each spreadsheet is in result.Tables Use the AsDataSet extension method var result = reader. Auto-detect format, supports: // - Binary Excel files (2.0-2003 format *.xls) // - OpenXml Excel files (2007 format *.xlsx, *.xlsb) using ( var reader = ExcelReaderFactory. Compatible with net20, net45 and netstandard2.0. Install the ExcelDataReader.DataSet extension package to use the AsDataSet() method to populate a. Compatible with net20, net45, netstandard1.3 and netstandard2.0. Install the ExcelDataReader base package to use the "low level" reader interface. It is recommended to use NuGet through the VS Package Manager Console Install-Package or using the VS "Manage NuGet Packages." extension.Īs of ExcelDataReader version 3.0, the project was split into multiple packages: Supported file formats and versions File Type If you are reporting an issue it is really useful if you can supply an example Excel file as this makes debugging much easier and without it we may not be able to resolve any problems. Please feel free to fork and submit pull requests to the develop branch. Lightweight and fast library written in C# for reading Microsoft Excel files (2.0-2007).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |