Forum Discussion

forrestaustin's avatar
forrestaustin
Contributor
8 years ago
Solved

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
    8 years ago

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

tristaanogre's avatar
tristaanogre
Esteemed Contributor
8 years ago

Try

 

sheet2 = book.Sheets.Item["Sheet2"]

forrestaustin's avatar
forrestaustin
Contributor
8 years ago

Hi Tristan, did you see my error I get when I try that?

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    8 years ago

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

    • forrestaustin's avatar
      forrestaustin
      Contributor
      8 years ago

      Oh sorry I couldn't discern that change, but it doesn't throw that error any more after changing to []. Thank you!