Forum Discussion

presideji's avatar
presideji
Occasional Contributor
13 years ago

using excel spread sheet with testcomplete

I want to call up data from more than one sheet within an excel workbook. So far I see that you can only call up data from only one sheet within an excel workbook.



How do you call up data from more than one sheet on an excel workbook at a time. (i.e. from sheet 1, sheet 2, sheet 3 with an excel workbook.



Thanks
  • nilesh_singhai_1's avatar
    nilesh_singhai_1
    13 years ago
    Set Objexcel=CreateObject("Excel.Application")

    Set Objworkbook= Objexcel.Workbooks.open(filepath)

    Set ObjSheet1= Objworkbook.worksheets("Sheet1")

    Set ObjSheet2= Objworkbook.worksheets("Sheet2")



    by using above worksheets object you can read or write data...