cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Highlighted
Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Hero

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

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


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available

View solution in original post

8 REPLIES 8
Highlighted
Community Hero

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

Do you actually have a typo in this line?

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

 

(should be OleObject)

Highlighted
Community Hero

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

try this line instead of your, it should work.

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


Thanks
Shankar R

LinkedIn | CG-VAK Software | Bitbucket | shankarr.75@gmail.com

“You must expect great things from you, before you can do them”


Extension Available

Highlighted
Contributor

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

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?

Highlighted
Contributor

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

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. 

Highlighted
Community Hero

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

Try

 

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


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
Highlighted
Contributor

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

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

Highlighted
Community Hero

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

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


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available

View solution in original post

Highlighted
Contributor

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

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

New Here?
Join us and watch the welcome video:
Announcements
Script Wanted
Let's start July with new challenges!

Create a script to pass custom command-line arguments as a test parameter for the TechCorner tag!

Will you dare to take the challenge?


Top Kudoed Authors