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.

HKosova's avatar
HKosova
SmartBear Alumni (Retired)
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
    9 years ago

    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