Loading

Read Data From Excel File (xls, xlsx) In ASP.NET MVC

Yasir Nazir

9y1.8k.NET

I am using Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path1 + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\""; to import MS 2016 excel file and getting exception. Any idea how can I solve this issue I tried to change solution 32 to 64 bit but it doesn't work.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

alice yang9y ago
Hi Yasir,

You can also use Free Spire.XLS(https://www.nuget.org/packages/FreeSpire.XLS/) to achieve the same purpose.

Refer the following tutorial:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html
Rajeesh Menoth9y ago
Hi,

You can refer this article :

http://www.c-sharpcorner.com/UploadFile/dbb82e/read-data-from-excel-filexlsxlsxcsv-in-Asp-Net-mvc/