Issues with If Variables

[Jillian]

Hello

I am attempting to move large pieces of data from an excel spreadsheet onto a web application. Depending on the information contained within a cell on the spreadsheet, corresponding information needs to be updated onto the web. I am using the copy/paste functions to migrate the data.

Script:
$Copy$ in Excel //[ctrl dwn]c[ctrl up]
Assign value of variable $Copy$ to Clipboard
IF $Clipboard$ Equals $Story 2$ Then // $Story 2$ = 2 Story
Keystroke 2 in Windows
Keystroke [tab] in Windows
Else if $Clipboard$ Equals $Story 1$ Then // $Story 1$ = 1 Story
Keystroke 1 in Windows
Keystroke [tab] in Windows
Else if $Clipboard$ Equals $Bilevel$ Then // $Bilevel$ = Bi-level
Keystroke B in Windows
Keystroke [tab] in Windows
Else if $Clipboard$ Equals $Splitlevel$ Then // $Splitlevel$ = Split level
Keystroke S in Windows
Keystroke [tab] in Windows
End if


Excel cell = 2 Story or 1 Story or Bi-level or Split level or ...
Many different options/row

Any suggestions to make this work???

Thank you,

[forumsupport]

Hello,

We suggest using Excel command to get data from an excel spreadsheet and use Web Recorder command to update the web application with data in excel.

You can view demo on Excel commands usage from, http://www.tethyssolutions.com/AAExcelIntegration.html

You can view web form filling demo at,

http://www.automationanywhere.com/Cu...rmFillDemo.wmv
http://www.automationanywhere.com/Cu...rmFilling.atmn

Also, Please refer to following example (web Link), which explains how to use excel sheet to feed data in particular web application and similarly ,you can use it for other types of application.
http://www.tethyssolutions.com/T85.htm

Hope that helps. If you could tell us more about your case, we would be able to help you more with specific task.