Excel using for each row, second column elements has to be filled in webform. I have to automate it to fill webform with such multiple excels!

Help Forms
1

Untitled

2

Hy @nikhil.s,

You can use the ‘GetWorkbookSheets’ Activity to get all sheets inside an excel file, inside an ‘Excel Application Scope’

Inside each sheet:

  • use Read Range Activity
  • Loop through the Data table
  • input the data into the web

Have a look an workflow that loops through diferent sheets

Loop_Excel_Sheets_Test.zip (36.9 KB)

Is it clear for you
Please let me know if you have any questions

Regards

3

I need to use column with “fields” as headers and want to fill data in web form such as username textbox = Xxxx so on…
So my column A should act as header

4

Hy @nikhil.s,

To get data from an Excel sheet use the ‘Read Range’ activity inside an ‘Excel Application scope’ activity

Click the ‘Add Header’ property to true to let uipath knows your sheet has header.

Is this clear to you?

Regards

5

Will it take my first column as header or first row as header?

6

@nikhil.s, the first row of the selected range will be considered as header

7

Hy @nikhil.s,

Did you manage to do what you wanted? Please let me know

thanks

8

No, i want complete first column as header is that possible??

9

Hy @nikhil.s,

Yes it is possible, just leave the range argument in the read range qctivity blank. Ok?!
Have you already prepared a workflow? Please send me to have a look

10

AllDependencies.json (69.2 KB) PackageCache.json (31.2 KB) ProjectSettings.json (75 Bytes) 0efa38ddcde866f74e097814d522752e 87d69f7324fb8e1a835142c533572ad5 e4df658f74a3a391e883fbaf0945f50b settings-1a5b880a.json (1.5 KB) settings-5190454b.json (346 Bytes) settings-590bb27b.json (1.2 KB) settings-9e9290da.json (935 Bytes) settings-1a5b880a.json (1.5 KB) settings-5190454b.json (346 Bytes) settings-590bb27b.json (1.2 KB) settings-9e9290da.json (935 Bytes) test.xlsx (8.0 KB) files.xlsx (7.5 KB) Main.xaml (11.5 KB) project.json (942 Bytes) I will explain it
for example take a facebook signup page
i want to read excel data which consists of first columns first name, last name, number, password… and second column with values such as xxxxx, yyyyyy, 111111, xyz i want fill these values in signup page with foreach row and using type into.AllDependencies.json (69.2 KB) PackageCache.json (31.2 KB) ProjectSettings.json (75 Bytes) 0efa38ddcde866f74e097814d522752e 87d69f7324fb8e1a835142c533572ad5 e4df658f74a3a391e883fbaf0945f50b settings-1a5b880a.json (1.5 KB) settings-5190454b.json (346 Bytes) settings-590bb27b.json (1.2 KB) settings-9e9290da.json (935 Bytes) settings-1a5b880a.json (1.5 KB) settings-5190454b.json (346 Bytes) settings-590bb27b.json (1.2 KB) settings-9e9290da.json (935 Bytes) test.xlsx (8.0 KB) files.xlsx (7.5 KB) Main.xaml (11.5 KB) project.json (942 Bytes)

11

Hy @nikhil.s,

Your post looks to messy, it is difficult to undertand :frowning:

Could you zip all your process folder and upload a single zip file?

Thanks

12

:sweat_smile:my mistake
ExcelTextPropero.zip (45.0 KB)
I will explain it
for example take a facebook signup page
i want to read excel data which consists of first columns first name, last name, number, password… and second column with values such as xxxxx, yyyyyy, 111111, xyz i want fill these values in signup page with foreach row and using type into. If i take first column as header i can easily use header to implement values to fill it

13

Hy @nikhil.s,

You are very close from your goal!

Whenever UiPath fails to recognize a selector, you can use the ‘Repair’ button so UiPaith will try to remap the selector, it may take a couple of times depending on the component.

You could also use the Open in Ui Explorer to help you set up the selector mannualy.

Please have a look my workflow, I adjusted the selector using the repair method.

I ask you to like my posts and mark my answer as a solution, it helps me.

Thank you

Happy Automation

ExcelTextPropero.zip (45.3 KB)

14

Hy @nikhil.s,

Did you tried it? did it worked?

Please let me know

Regards