Our Training Programs

All contents are copyright of their authors.

How to Excel Sheet data into Data table in Mvc5 use Ajax

How to Excel Sheet data into Data table in Mvc5 use Ajax

Narasimha p

5yAsked Apr 6, 2021, 4:35 AM605.NET

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

It is the same account you read, post and publish with — and you will come straight back to this page.

Jignesh Kumar5y ago
Please refer this one,
https://www.c-sharpcorner.com/blogs/solution-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine
Narasimha p5y ago
1. switch (extension
2. {
3. case ".xls": //For Excel 97-03.conString = ConfigurationManager.ConnectionStrings["Excel03ConString"].ConnectionString;
4. break;
5. case ".xlsx": //For Excel 07 and above.
6. conString = ConfigurationManager.ConnectionStrings["Excel07ConString"].ConnectionString;
7. break;
8. }
9. connExcel.Open();
I got error excel connetion open
System.InvalidOperationException: 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'

Hi,

Please use this one, Here you can remove code after Datatable fill then remove code to store in sql server database

https://www.c-sharpcorner.com/article/export-and-import-excel-file/

Hi Jignesh kumar

I want only upload excel sheet data into datatable (I'm Not using Sql Database)

Hi Narshima,

Please find this link to achieve your task,

https://www.c-sharpcorner.com/article/import-excel-file-to-sql-table-in-asp-net-mvc/