Hi @pravin_bindage
Try the below vb.net code to read excel data
VB Code:
Dim excelApp As Excel.Application
Dim excelWorkbook As Excel.Workbook
excelApp = CreateObject(“Excel.Application”)
excelWorkbook = excelApp.Workbooks.Open(“C:\Path\To\Excel\File.xlsx”)
Dim dataTable As DataTable
dataTable = New DataTable()
Dim rows As Excel.Range
Dim columns As Excel.Range
rows = excelWorkbook.Sheets(“Sheet1”).UsedRange.Rows
columns = excelWorkbook.Sheets(“Sheet1”).UsedRange.Columns
For i As Integer = 1 To columns.Count
dataTable.Columns.Add()
Next
For i As Integer = 1 To rows.Count
Dim row As DataRow
row = dataTable.NewRow()
For j As Integer = 1 To columns.Count
row(j - 1) = excelWorkbook.Sheets(“Sheet1”).Cells(i, j).Value
Next
dataTable.Rows.Add(row)
Next
excelWorkbook.Close()
excelApp.Quit()
Return dataTable