Forum Discussion

Rajesh2's avatar
Rajesh2
Contributor
8 years ago
Solved

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
8 years ago

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.

  • Rajesh2's avatar
    Rajesh2
    Contributor
    8 years ago

    Hi baxatob, Thank you for the response.

     

    1. The link which you have sent is throwing 404 error. Can you please check the same?

     

    2. Thank you, Will check the same.

     

    3. I want the screen shot to be stored in the desktop folder. How to store it externally with log files.

     

    4. Ok, Will try with the same. By creating our own method to fetch into excel report.

    • baxatob's avatar
      baxatob
      Community Hero
      8 years ago

      Hi,

       

      I have updated the link >>

       

      You can use the following code for taking a screenshot:

       

      def take_screenshot(path):
    Sys.Desktop.Picture().SaveToFile(path)


       path should be a string with full path to your destination, e.g. "C:\\Users\\User\\Desktop\\shot.jpg"
      Sys.Desktop will provide a screenshot from the whole desktop. You can use any mapped object instead of Sys.Desktop

       

       

       

       

       

  • 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"))