We are building a new experience for our SmartBear Community.
This site is now read-only. You can still browse and search as usual. Learn More

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





1 Reply

  • nilesh_singhai_1's avatar
    nilesh_singhai_1
    Not applicable
    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...