Read Excel file from ASP.NET
The following ASP.NET application read the content of an Excel file using OLEDB. Here we are using OleDbConnection , OleDbDataAdapter and DataSet for doing this operation in an Excel file. First we have to create an OLEDB connection string to connect the Excel file
Data Source='ExcelFile.xls' : we have to specify the Excel file location.
For read the content from an Excel file using ADO.NET , We can use the SELECT command like in SQL Operations.
MyCommand = New OleDbDataAdapter("select * from [Sheet1$]", MyConnection)
MyCommand = new OleDbDataAdapter("select * from [Sheet1$]", MyConnection);
Click the following links to see full source code