Forum Discussion

saaran's avatar
saaran
Contributor
11 years ago

How to import excel sheet from desktop to test complete tool?

Hi All,   I need reply from your end view's, please see the below questions.   1. Is there any option to import and export excel file from desktop to test complete tool? 2. Is there any option t...
saaran's avatar
saaran
Contributor
11 years ago

Hi,

 

I tried by using STORE, but can't able to map the excel sheet inorder to import...

 

Can you please give some more suggestions or different ways to import excel sheet.

 

 

Regards,

Sarankumar P.

finae's avatar
finae
Contributor
11 years ago

Another option for using/reading files : 

 

use DDT.ExcelDriver

an example:

 

set xlDriver = DDT.ExcelDriver("C:\mytest\test.xls","Sheet1",true)
xlDriver.First
while not xlDriver.EOF
   col1Value=xlDriver.Value("TheColumnName")
   col1Name=xlDriver.ColumnName(ColumnIndex)   ' i m sure this is 0 base
   ..///codes

   xlDriver.Next

wend

This will read the xls file and loop through all records (make sure they are string base), until the last record

 

as far as the error mentioned, if the error is an application error and does not crash but allows you to continue (ie handled application thrown error), you can also consider using OnUnexpectedWindow.

 

 

 

  • saaran's avatar
    saaran
    Contributor
    11 years ago

    Thanks for your valuable reply..

     

    To read data's from external file like excel sheet, i will use fso method to get value's from excel sheet.That's not a problem for me..

     

    My quastion is, If you see UFT tool ,below expert view and keyword view excel strucure will be there like ("Global Sheet and Local Sheet"). like same way we can able to create excel sturcutre in test complete tool.

     

    Thanks

    Sarankumar P.