Forum Discussion

nisgupta's avatar
nisgupta
Valued Contributor
9 years ago

Retrieving the data from Excel file

How we can retrieve the data from Excel file  to TestComplete ?   Thanks Nishchal
nisgupta's avatar
nisgupta
Valued Contributor
9 years ago

Ok At this time I want to simply retrieve the data from Excel file and process that excel data .

 

Thanks

Nishchal

  • nisgupta's avatar
    nisgupta
    Valued Contributor
    9 years ago

    Thanks for the updates

     

    Let's suppose that if we run the script from remote machine then the following statement will not work

     

    Excel.Workbooks.Open("C:\\MyFile.xls");

     

    How can we handle ?

     

    Thanks

    NG

    • tristaanogre's avatar
      tristaanogre
      Esteemed Contributor
      9 years ago

      What I would do is make sure that any Excel files that you use in your project are stored with the project path.  There is a property Project.Path that will return the path of where the MDS file is for your automation project.  So, if you do

      Excel.Workbooks.Open(Project.Path + "\\MyFile.xls");

      This will then look for the file in whatever the current path is.  So, if you go to a different machine, the file will always be referenced relative to the project path.

      • nisgupta's avatar
        nisgupta
        Valued Contributor
        9 years ago

        This is pretty new for me. have not heard this before

         

        Thanks for updating this one .