![]() ![]() Step 8: Then finally, add this code to save the Excel file and closes it. TextBox2.Text = worksheet.Cells(1, 2).Value TextBox1.Text = worksheet.Cells(1, 1).Value Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) _ Add this following code to the Button Click Event. Step 7: To get the value from Excel cell to TextBox. Worksheet = workbook.Worksheets("sheet1") Workbook = ("C:\Users\Clive\Documents\Visual Studio 2008\clive projects\writeandread\writeandread\bin\Debug\sales.xlsx") ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |