Before running this program you have to create an excel file name test1.xlsx and add some data in the cell B2. When you execute this program, the program open the file c:\test1.xlsx and edit the content in the cell B2, it replace the old content to "". Now you can start coding to open or read from Excel file and edit cells. Create a new project and add a button to the Form. From the following pictures to show how to add Excel reference library in your project. In the code, Imports Excel = - we assign the excel reference to a vatriable Excel. For open or edit an Excel worksheet in VB.NET, you have to add the Microsoft Excel 12.0 Object Library in you project. Imports Excel = Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, _ěyVal e As System.EventArgs) Handles Button1.Click Dim xlApp As Excel.Application Dim xlWorkBook As Excel.Workbook Dim xlWorkSheet As Excel.Worksheet xlApp = New Excel.ApplicationClass xlWorkBook = ("c:\test1.xlsx") xlWorkSheet = xlWorkBook.Worksheets("sheet1") 'display the cells value B2 MsgBox(xlWorkSheet.Cells(2, 2).value) 'edit the cell with new value xlWorkSheet.Cells(2, 2) = "" xlWorkBook.Close() xlApp.Quit() releaseObject(xlApp) releaseObject(xlWorkBook) releaseObject(xlWorkSheet) End Sub Private Sub releaseObject(ByVal obj As Object) Try .ReleaseComObject(obj) obj = Nothing Catch ex As Exception obj = Nothing Finally GC.Collect() End Try End SubEnd Class
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |