I want to read the excel file in vb.net
I coded the bellow, but I couldn't get the result I wanted
Imports Microsoft.Office.Interop.Excel
Imports Excel = Microsoft.Office.Interop.Excel
Public Class Chart
Inherits System.Web.UI.Page
Dim app As New Excel.Application
Dim worksheet As Excel.Worksheet
Dim workbook As Excel.Workbook
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
workbook = app.Workbooks.Open("E:\Results.xlsx")
worksheet = workbook.Worksheets("Information")
End Sub
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
TextBox1.Text = worksheet.Cells(1, 1).Value
TextBox2.Text = worksheet.Cells(1, 2).Value
End Sub
Protected Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
workbook.Save()
workbook.Close()
app.Quit()
End Sub
End Class