Forum Discussion

tcarey's avatar
tcarey
Occasional Contributor
5 years ago

sending keystroke to Excel

I am trying to send keystroke to Excel Screen but seems like it is not working. Sys.Process("EXCEL").Window("XLMAIN", "*", 1).Window("XLDESK", "", 1).Window("EXCEL7", "*", 1).Keys("[F6][F6]")  I use...
  • Marsha_R's avatar
    Marsha_R
    5 years ago

    Okay.  There are a couple of things here.  

     

    Can I ask why you are testing Excel and Oracle?  Is the data upload something to do with your application?  The reason I ask is that most people are testing their own app and adding other apps into the mix can unnecessarily complicate things.  Can you give us a bigger overview of what you are trying to do?

     

    Second, if you are going to use Excel this way, then the best way to handle this is when the test fails.  When you get the error, and before TestComplete closes, you'll want to check and see if Excel is still open and close the file properly.

tcarey's avatar
tcarey
Occasional Contributor

Reason why the Document Recovery screen shows up sometimes.. (I think)  is when the test fails middle of entering data in Excel - it stops the test without saving.  Then when I run again,  Excel thinks the file was ended abruptly and hence gives that screen.

 

The reason for the Excel is  due to  part of the Oracle functionality we are trying to test.  

Test is log in Oracle as a user, navigate to appropriate screen download the Excel, enter the data then there is an build in macro that uploads the file back to Oracle.  It is giving user option to bulk upload the data into Oracle.   Any suggestion on best way to do this?  I am no expert in TestComplete so I am lost. 

Thanks

Marsha_R's avatar
Marsha_R
Moderator
5 years ago

Okay.  There are a couple of things here.  

 

Can I ask why you are testing Excel and Oracle?  Is the data upload something to do with your application?  The reason I ask is that most people are testing their own app and adding other apps into the mix can unnecessarily complicate things.  Can you give us a bigger overview of what you are trying to do?

 

Second, if you are going to use Excel this way, then the best way to handle this is when the test fails.  When you get the error, and before TestComplete closes, you'll want to check and see if Excel is still open and close the file properly.

  • sonya_m's avatar
    sonya_m
    SmartBear Alumni (Retired)
    5 years ago

    Thank you for advice Marsha!

     

    Hi tcarey ! Was this solved for you? Please share your progress🙂

    If you still need help in this thread, please provide additional info as requested by Marsha.