Forum Discussion
ebarbera
4 years agoStaff
Hi Vicky_17 -
I would suggest trying to use the excel methods instead of the ole objects - these methods allow you to pull data from a single cell.
Take a look at this information : https://support.smartbear.com/testcomplete/docs/reference/program-objects/excel/index.html
Let me know if this is not an option - or if there was a reason you were looking to use the ole object over the excel object.
Thanks,
Emma
I would suggest trying to use the excel methods instead of the ole objects - these methods allow you to pull data from a single cell.
Take a look at this information : https://support.smartbear.com/testcomplete/docs/reference/program-objects/excel/index.html
Let me know if this is not an option - or if there was a reason you were looking to use the ole object over the excel object.
Thanks,
Emma
- Vicky_174 years agoNew Contributor
i want to read a range of cell not Single cell
- ebarbera4 years agoStaff
Hello Vicky_17 -
I apologize I read that post incorrectly - is the script you have there not working? Or is it the vba script and you are just having trouble with the conversion process? Also - where are you looking to store the data after you read it from the excel sheet.
Thanks,
Emma
- Vicky_174 years agoNew Contributor
It is taking long time to load data one by one and My PC is hanging and fan is running fast once i click run .It was a python script. i want to store the read data as List of Lists in python
Related Content
- 4 years ago
Recent Discussions
- 8 days ago
- 2 days ago