Forum Discussion

JackSparrow's avatar
JackSparrow
Frequent Contributor
10 years ago
Solved

Reading the Test-Case and Test-Data from Excel Using Python

Hii All   My Aim is to Read the Execution Col if its Yes then it need to Take the values of that particular row and call those functions :   Now for the first when am Trying to Read data fro...
Python
  • joseph_michaud's avatar
    joseph_michaud
    10 years ago

    The example is creating folders in the log file called Record: 0, Record: 1, etc.

    Expand the folders to see the values.

JackSparrow's avatar
JackSparrow
Frequent Contributor
10 years ago

Hi joseph_michaud

 

There is no'plus' to the left of the line in the TestComplete Test Log.But when i checked in the Additional info it was showing the values , now i can read a single column value and based on that i need to read the entire row values stored in diff param's .Can you please help me out

 

 

 

joseph_michaud's avatar
joseph_michaud
Icon for Staff rankStaff
10 years ago

Assuming your image somehow corresponds to your COM automation example, then the answer is to not concatenate your column values together:

 

        for k in range (5 , TSCols):
            TSData = TSData & TSSheet.cells(j,k).Value & ";"

 

  • JackSparrow's avatar
    JackSparrow
    Frequent Contributor
    10 years ago

    Hi joseph_michaud for the COM automation am facing an python run-time error "the method is not callable " at the line which is in Red Font .