Ask a Question

How to Retrive Excel sheet cell values in testcomplete by using python

Ganesh3195
Occasional Contributor

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
shankar_r
Community Hero

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”

Extension Available

cancel
Showing results for 
Search instead for 
Did you mean: