excel as variable inputs.. stuck!

[jot_gabbi]

Hi
Abit, well very new to automation anywhere premier and am just getting to grips with the software.

I have a website, that has a form on it, inc dropdowns and radio fields that show extra fields based on the choice.

I have an excel spreadsheet with 7000 rows and 309 columns. Each column relates to a field on the form. Though not every row has values in everyone, so there will situations where IF cell = NULL.. skip the next bit.. else do this... This is possible??

So it starts A1 then each field has value etc.. until end, then go down row and start again with next room, on a loop..

My issue is, I can have the excel file in any format if needed, but how do i say to the field.. input the text from this column for the row you on.. and how would I do this?

Does this make sense?

Any help offered would be great.

Thanks

Jonathon

[forumsupport]

Hello,

Yes, it is certainly possible using Automation Anywhere. You can use combination of Excel command and If Variable command to achieve the mentioned task. Below is the link to show demo of form filling task,

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

Hope that helps. If you could upload sample excel file and exact steps to fill the form, we would be able to help you more with specific task.