Asp.net excel data reading and display into gridview

Jerald Jayaraj D

7y1.3k.NET

i try to upload excel file using asp.net and reading all the datas and displaying in gridview but am facing below mentioned error kindly help me out .

System.Data.OleDb.OleDbException(0x80040E37): The Microsoft Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly. If 'Sheet1$' is not a local object, check your network connection or contact the server administrator.at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResulthr)at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMSdbParams, Object& executeResult)at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehaviorbehavior)at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)at testhd.WebForm5.Button1_Click(Object sender, EventArgs e) in E:\host app - Copy\New folder (3) - Copy\New folder (2)\ncs\ncs2\Addbom.aspx.cs:line 184

4 Replies

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

Leon D6y ago
As an alternative solution, you can use Spire.XLS to read the Excel file to a DataTable and then bind to a GridView.

Refer the below link to read excel to datatable:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html
0
Mageshwaran R6y ago
Hi,
please refer this link:
https://www.c-sharpcorner.com/UploadFile/75a48f/read-excel-sheet-data-and-bind-with-asp-net-gridview/
0
Sonu Gupta7y ago
Hi,

Visit the following urls -

https://www.aspdotnet-suresh.com/2012/12/how-to-import-data-from-excel-to-aspnet.html

https://www.aspsnippets.com/Articles/Import-data-from-Excel-to-GridView-in-ASPNet.aspx
+1
Abhijeet Jadhav7y ago
Hi Jerald,

Can you try below, this will help to resolve the issue.
Save the excel file on the server.

Use that path in your code to browse through the excel, you can save the path in web.config and use it.

Do let me know if the issue is not resolved.
+1