Forum Discussion

forrestaustin's avatar
forrestaustin
Contributor
7 years ago

Having Trouble switching to different sheet in excel using sys.oleobject

I was able to use python inside testcomplete to open an excel workbook I have and read some values. Now I am trying to change sheets from the default "Sheet1" to "Sheet2"   My code is:     def R...
  • tristaanogre's avatar
    tristaanogre
    7 years ago

    Yes, I did... which is why I suggested a change... change from () to [].

Marsha_R's avatar
Marsha_R
Moderator
7 years ago

Do you actually have a typo in this line?

Excel = Sys.OleObjext["Excel.Application"]

 

(should be OleObject)

  • forrestaustin's avatar
    forrestaustin
    Contributor
    7 years ago

    Hi Marsha, thanks for catching that. I actually had OleObject on my Testcomplete but it is on an offline computer so there was a mistake when  I was manually typing the code here.