Net-informations.com

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.

VB.Net

C#

Default.aspx



Click the following links to see full source code

C# Source Code
VB.NET Source Code
default.aspx.cs
default.aspx.vb





net-informations.com (C) 2019    Founded by raps mk
All Rights Reserved. All other trademarks are property of their respective owners.
SiteMap  | Terms  | About