The Sheets collection has to be accessed using Item just like the Cells collection.
For example, your line of code should change to this:
sheet = Excel.Workbooks.open(file).Sheets.Item["Sheet1"]
Hope that helps.
Hi ghuff2,
Thank you for your reply. I am sorry I didnot make it clear. I need to modify the sheet. Maybe import python library to handle this. I just think Testcomplete may has its own solution.
The Sheets collection has to be accessed using Item just like the Cells collection.
For example, your line of code should change to this:
sheet = Excel.Workbooks.open(file).Sheets.Item["Sheet1"]
Hope that helps.
Hi ghuff2,
With your solution I can read sheet in python now. Thank you very much.
Sorry, my bad, I didnot check TC's samples installed. Actually I forgot they have bunches of examples there.
Getting data from Excel is always a tough question. There are many ways of how it can be done. It's very important to choose the best way based on the current requirements. Our SmartBear Community Leader in TestComplete, shankar_r, shares best practices with us. Watch the interview here:
https://www.youtube.com/watch?v=3zQ_1xhokVQ&feature=youtu.be&t=552
