I was playing around excel and searching for some code which help me to export excel data to Datagrid.
Here is the code. Dim strCon As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Suresh\Test.xls;Extended Properties=Excel 8.0;" Dim objConn As New System.Data.OleDb.OleDbConnection(strCon) Dim daSuresh As New OleDbDataAdapter("Select * From [Suresh$]", strCon)
objConn.Open() Dim dsSuresh As New DataSet Dim dvSuresh As New DataView
dvSuresh = New DataView(dsSuresh.Tables("Sheet1"))
dvSuresh.Sort = "name"
DataGrid1.DataSource = dsSuresh
DataGrid1.DataMember = dsSuresh.Tables("Sheet1").ToString