21, Feb, 2019

excel

Write to excel file – Simple example  Dim APP As New Excel.Application         Dim worksheet As Excel.Worksheet         Dim workbook As Excel.Workbook         workbook = APP.Workbooks.Open(“D:\excelfile.xlsx”)         worksheet = workbook.Worksheets(“Sheet1”)         Dim iter1 As Integer         For iter1 = 1 To 50             ‘Add data to cells of the first […]

Step 1 :- CONVERT EXCEL FILE TO HTML FILE Step 2 :- DISPLAY INSIDE WEB-BROWSER Required Libraries Imports System Imports Microsoft.Office.Interop Imports Microsoft.Office.Core Imports System.IO Imports Excel = Microsoft.Office.Interop.Excel   Create an menu item/ button, and paste below code         Dim curFile3 As String = “E:\Excel-in-VB\copy\excel-vb.xlsx”         Dim curFile4 As […]