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 ReadDataFromExcel():
Excel = Sys.OleObjext["Excel.Application"]
book = Excel.Workbooks.Open("path to excel sheet")
sheet2 = book.Sheets("Sheet2")
.... At this point the code breaks and gives me the error "RuntimeError: The specific object is not callable"
Now if I debug and put a break point right above last step and look at the local variables. The book object is not empty and it recognizes that it has 3 sheets.
Also if I follow the sample from the documentation using "ActiveSheet" the program runs fine.
Does anyone have any ideas on what could be wrong?
Yes, I did... which is why I suggested a change... change from () to [].