Forum Discussion

nisgupta's avatar
nisgupta
Valued Contributor
7 years ago

Retrieving the data from Excel file

How we can retrieve the data from Excel file  to TestComplete ?

 

Thanks

Nishchal

7 Replies

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor

    Depends upon what you intend to do with the data.  If the data is a set of data that you're going to use to drive a loop, then you would use the DDT.ExcelDriver object or a Data Driven Loop in Keyword Tests using the Excel file.

     

    If you're looking at simply retrivieving data from the file and processing it into something else, not necessarily in a loop, then I would use Sys.OleObject('Excel.Application') to access the Excel application object and work with it.

     

    If you could give us more details as to what you're intending, we can target you to the best solution.