Forum Discussion

JackSparrow's avatar
JackSparrow
Frequent Contributor
9 years ago

python run-time error "method is not callable"

Hi All my aim is  to get the data from  the excel and execute the method which given in the excel but am facing the Python Run-time Error method cannot be callable for the lines 4 and 6   def ReadD...
  • HKosova's avatar
    HKosova
    9 years ago

    Worksheets and Cells are collections, and in Python you need to use .Item[] to access the collection items. So change

    book.Worksheets("TestCases")
TCSheet.cells(i,1)

    to

    book.Worksheets.Item["TestCases"]
TCSheet.cells.Item[i,1]

    Also check the documentation for Python specifics in TestComplete.

JackSparrow's avatar
JackSparrow
Frequent Contributor

HKosova Thanks For the info am facing an error when am trying to append and split the parameters

HKosova's avatar
HKosova
SmartBear Alumni (Retired)
9 years ago

I tried your code with Excel 2010, and the Cell object has two "Value" properties:


Value(RangeValueDataType)
Value2

 

Try Value2 instead of Value and see if that works.

  • JackSparrow's avatar
    JackSparrow
    Frequent Contributor
    9 years ago

    HKosova i Solved that one thanks but am facing this error when am trying to split and append

    • HKosova's avatar
      HKosova
      SmartBear Alumni (Retired)
      9 years ago

      Python strings don't have the append method. Change that to:

      Parameter = TSData + ";"

      You might also need to explicitly convert the cell value to a string before concatenation:

      TSData = str(TSSheet.cells.Item[j,k].Value)
Parameter = TSData + ";" 
      • JackSparrow's avatar
        JackSparrow
        Frequent Contributor
        9 years ago

        Hi HKosova

         

        When am trying to print the Log.Message(str(Parameter)) or Log.Message((Parameter)) after the changes you suggested , in the log report it displaying as "__main__.IDispatchIndexedPropertyWrapper object at 0x06EDC270" , and am facing python runtime error at code " Execute.TSSheet.cells.Item[j,3].Value " cant we use the Execute method in Python like in VB Scripting for Executing the Function.