Forum Discussion

presideji's avatar
presideji
Occasional Contributor
13 years ago
Solved

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 ...
  • 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...





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...