How to copy one by one each row from excel file

Help
1

Hello guys the title says it all,. how can i copy one by one each cell.

The process is going to be this:

Copy → paste in web browser → etc
Copy Cell 2 → paste in web browser

Anybody has any idea?

Tried actually but didn’t get anywhere, for few hours :frowning:

Hope the masterminds can give some juice :smiley:

1 Like
2

Hi Buddy @BillionaireEmpire

Welcome to UiPath Commuity Forum…Thats a great question to start with…

  1. Alright lets take like this, first open the browser - web application with open browser activity
  2. Then open excel application to get the cell details you want from single column name mycolumn and this can be done by using excel application scope activity
  3. Inside excel application scope, you can use read range activity,
  4. the output of the read range activity would be datatable with variable name out_dt
  5. Use a for each row loop to iterate through datatable with input out_dt
  6. Here comes the answer for you… use type into activity to enter your details…with input like row(“mycolumn”).Tostring where mycolumn is the name of the column from where you want to enter the details from each cell…either you can even mention the column index and it usually starts from 0 for the first column

Ahhhhh you might need like this either like you would like to enter the details from each row of each column…may be from left to right rather than from top to bottom like above mentioned
for that simple buddy, you can use row_counter initialised with default value 0…and column_counter with 0
Just with assign activity inside any loop condition, put like
mycellvalue = out_dt_Rows(row_counter)(column_counter)
increment the row_counter keeping the column_counter as 0 untill all the cells in a row of all column is read…(from left to right fullyy)
then increment column_counter with +1
and then repeat same for all the rows…

Hope this would help you…
Cheers…Buddy…

3

Hi @BillionaireEmpire, welcome back to the community! :slight_smile:
:

I suggest you to join our Uipath Academy and take the Foundation Course to understand Uipath’s World. It’s free and you also can obtain a Certificate :open_mouth:

Anyway, Here’s some activities that will help you to begin:

Open Browser: Use to open a Web browser and navigate to a specific link

activities.uipath.com

Open Browser

UiPath.Core.Activities.OpenBrowser A container that enables you to open a browser at a specified URL and execute multiple activities within it. # Properties ## Input * Url - The URL that you want to open in the specified browser. *…

Read Range: Use to read the Excel file and store all the data on a DataTable variable.

activities.uipath.com

Read Range

UiPath.Excel.Activities.ExcelReadRange Reads the value of an Excel range and stores it in a DataTable variable. If the range isn’t specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from…

For Each Row: Use to iterate through all the rows from the DataTable

activities.uipath.com

For Each Row

UiPath.Core.Activities.ForEachRow Executes an action once for each row in the DataTable provided. # Properties ## Input * DataTable - The DataTable variable for which an action is to be executed once for each row. ## Misc * Private…

Type Into: Use to type something on somewhere

activities.uipath.com

Type Into

UiPath.Core.Activities.TypeInto Sends keystrokes to a UI element. Special keys are supported and can be selected from the drop-down list. # Properties ## Input * Text - The text to be written in the specified UI element. Special keys are…

Hope it helps!:slight_smile:

Regards,
~Diego Turati

2 Likes
4

ah thanks man! going to try this ou tomorow morning letssee :slight_smile:

2 Likes
5

yeah, i will start from tomorrow with daily basis i guess

1 Like
6

Great @BillionaireEmpire, if it helped , could you mark as solved? Then you can do the basic training’s and then open a new topic case needed!

Feel free to contact us if you need ok?

Good lucky on your automation journey!

~Diego Turati

2 Likes
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.