Forum Discussion

Rajesh2's avatar
Rajesh2
Contributor
8 years ago

How to fetch the data from a Grid/dataset/table?

Hi,   Greetings,   NOTE: Please solve my queries on the basis of Python language as i am working in Python   I am working in a project where in we are using TestComplete with Python language. I...
  • Rajesh2's avatar
    Rajesh2
    8 years ago

    Hi baxatob Thank you so much for the solution.

     

    But we are facing some issue. It is returning the value of only first row. 

     

    As Pavan name was in first row it returned the Age of that Name.

     

    But when i gave Log.Message("Raj") which is in third row, the code isn't working.

     

    while not source.EOF():
        if source.Value["NAME"] == name:
            return source.Value["AGE"]
        source.Next()

     

    Can we know why it is not working for the same. If you know the solution, Can you please help us with the same..!!

  • baxatob's avatar
    baxatob
    8 years ago

    Hi,

     

    You should call the get_value() routine within Log.Message():

     

    Log.Message(get_value("Raj"))

    It works for me.

  • baxatob's avatar
    baxatob
    8 years ago

    In your case get_value() is a class method. You should use a keyword self as a first argument, while defining your function:

     

    class Excel:
    
    def get_value(self, RowValue, ColumnName, name):
        ...

     

     

    P.S. You do not need these delays : Delay(1000)

  • baxatob's avatar
    baxatob
    8 years ago

    At first you need to import your class:

     

    from Script1 import Excel

class Common_Functions(Excel):
    ...
baxatob's avatar
baxatob
Community Hero

1. Please go carefully through this topic: https://support.smartbear.com/testcomplete/docs/app-objects/specific-tasks/grids/index.html 

 

2. You can create a DBTable variable from your excel file. Then you can use it something like this:

 

def get_value(column_name):

    source = Project.Variables.your_dbtable_variable
    source.Reset()
    while not source.IsEOF():
        Log.Message(source.Value[column_name])
        source.Next()

The code above will save all values under the column_name into the Log.

 

3. Enable Post image on error option in your Project -> Properties -> Playback -> Log

 

4. You can't do it out-of-the-box, however you can create your own script or extension for this purpose.

pavanmac's avatar
pavanmac
Contributor
8 years ago

Hi could you please elaborate on fetching the data from excel using their column names.

 

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    8 years ago

    Look into using the DDT.ExcelDriver.  Once the driver is set up, accessing the data is a matter of objExcelDriver.Value('ColumnName').

  • pavanmac's avatar
    pavanmac
    Contributor
    8 years ago

    Can you please write a sample code for fetching the data from excel. (For python using testcomplete)

     

    Please fetch the values of  (column) NAME= (ROW)Pavan 

     

    I have attached the Excel file. 

     

     

    • baxatob's avatar
      baxatob
      Community Hero
      8 years ago

       

      def get_value(name):

    source = Project.Variables.your_DBTable_variable 
    source.Reset()
    while not source.IsEOF():
              if source.Value["NAME"] == name:
                  return source.Value["AGE"]
        source.Next()

       

      Try to call:

      Log.Message(get_value("PAVAN"))
      • Rajesh2's avatar
        Rajesh2
        Contributor
        8 years ago

        Hi baxatob can you please explain why this command is used?

        Project.Variables.your_DBTable_variable