Fast READ EXCEL Without OLEDB

Question

I want to store data in datatable of excel. I want to do Quick and fast read excel in C# with out using OLEDB Driver. Please if any body having idea about this thing kindly give me Feasible solution for this problem with example.

Ajeesh · Answer

If you are ok with using Third Party dlls then you can take a look at the http://epplus.codeplex.com/ library. You can also use Nugget to add the EPPlus in your solution To read the data from excel to datatable you can use the code in this article https://pronchaia.wordpress.com/2016/10/04/c-import-excel-file-to-datatable-by-epplus/

Amit Gupta · Answer

OleDb uses a base class to access the office files. Without looking at the code It is difficult to say how you are processing the sheet. Is there any specific reason for not using it. @Shweta Interop class are almost 80% slower than OleDb. In my past projects I used Interop that tooks almost a minute whereas OleDb is doing the same within 3 sec.

Leon D · Answer

With Free Spire.XLS dll (https://www.nuget.org/packages/FreeSpire.XLS/) you can quickly read excel into datatable. The code is very simple: Workbook workbook = new Workbook(); workbook.LoadFromFile( Input.xlsx ); Worksheet sheet = workbook.Worksheets[0]; DataTable dataTable = sheet.ExportDataTable();

Shweta Lodha · Answer

Try using Microsoft.Office.Interop.Excel.