VB.NET

VB.NET RSS

How to display Excel file in a tabPage?

Please support our VB.NET advertiser: Intel Parallel Studio Home

•

Join Date: Jun 2006

Posts: 2

Reputation: MikeLI is an unknown quantity at this point

Solved Threads: 0

MikeLI

Offline

Newbie Poster

How to display Excel file in a tabPage?

Jun 28th, 2006

Hi All,

My VB.NET program uses tabControl, which consists 8 tabPages, as the user interface. Basically, everything is done there, except when Excel file is opened.

My program reads Excel file by the following function:
VB:

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
 
Private Sub btnReadFile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnReadFile.Click
    excelApp = New Excel.Application
    excelApp.Visible = True
    excelApp.UserControl = True
    excelApp.DisplayAlerts = False
    xls = excelApp.Workbooks.Open(txtInFile.Text)
    init()
EndSub
 
Private Sub btnReadFile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnReadFile.Click
    excelApp = New Excel.Application
    excelApp.Visible = True
    excelApp.UserControl = True
    excelApp.DisplayAlerts = False
    xls = excelApp.Workbooks.Open(txtInFile.Text)
    init()
EndSub