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

shankar_r's avatar
shankar_r
Community Hero

try this line instead of your, it should work.

  sheet2 = book.Sheets.Item("Sheet2")

forrestaustin's avatar
forrestaustin
Contributor
7 years ago

When I try that suggestion I get the following error: Python runtime error

 

TypeError: 'IdispatchIndexedPropertyWrapper' object is not callable

 

Do you know how I can fix this?

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    7 years ago

    Try

     

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

    • forrestaustin's avatar
      forrestaustin
      Contributor
      7 years ago

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

      • tristaanogre's avatar
        tristaanogre
        Esteemed Contributor
        7 years ago

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