How to Retrive Excel sheet cell values in testcomplete by using python
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-09-2018
09:00 PM
05-09-2018
09:00 PM
How to Retrive Excel sheet cell values in testcomplete by using python
i want to use the excel sheet values in testcomplete for input operation by using python script
if the retrive the data by using excel sheet is possible how do i get mention buy a column and get the row values give some suggession for it by using python language
1 REPLY 1
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-09-2018
11:18 PM
05-09-2018
11:18 PM
As you are working on TestComplete, it has in-build function where you can the data from Excel by using DDT drivers.
Simple from help Doc:
def CurDriverExample(): # Creates a driver DDT.ExcelDriver("C:\\MyFiles\\MyFile.xls", "Sheet1") # Iterates through records while not DDT.CurrentDriver.EOF(): # Gets a value from the storage and posts it to the log Log.Message(DDT.CurrentDriver.Value[0]) DDT.CurrentDriver.Next() # Closes the driver DDT.CloseDriver(DDT.CurrentDriver.Name)
you can find more information here
Thanks
Shankar R
LinkedIn | CG-VAK Software | Bitbucket | shankarr.75@gmail.com
“You must expect great things from you, before you can do them”