I am kinda lost with the following automation, in which I need to enter data from an excel file into a web application.
In need to copy a specific excel row, let´s say called “Operations Expenses” and go to the web application look for that same row and paste the data.
How can I define which row should be copied from excel and then in which row should be pasted in the web application?
Use Application activity to open the browser and required url and there you can navigate to the required webpage
Use Read Range activitiy to read the excel file, In Properties declare a Datatable Variable
Now use For Each Row activity and there you can write into a TypeInto activity as CurrentRow(“Operations Expenses”).ToString
So that you can type the data which is in Excel to Webpage
The above steps by @Srini84 helps you to enter the data from excel to Webpage…further to it…
If you need to identify a specific row on webpage then I believe you have a identifier for the row like a invoice number or bill number…you can use that value from your excel to identify the row by using get attribute activity with dynamic selector
Sorry but my webpage does not have any identifier, however I know that that the row position in excel is the same as in web application. Maybe with this image I sent you can better understand what I need.
First step would be to identify the elments on the web application…use ui explorer and then indicate the element and then try identifying common attributes across cells and add idx=‘1’ and change and check if the cell on web app changes if not refine it more…
We would need the website to help you…without that it would be difficult as we do not know how the selectors are