Copy excel and paste into WEB

Help Activities
1

Dear Experts

Need to copy B2:B5 in excel and paste into below WEB column

I can simply Ctrl+C in excel and Ctrl+V in web only once for all

But I am not sure what is the best way to do so in UiPath
Can you give me some idea?

image

image

Expected result, Ctrl+V only once and no need to type in one by one
image

image
image557×799 19.5 KB

Thank you for your advise in advance

2

Hi @yangyq10

String.Join(" ", DT.AsEnumerable().Select(Function(row) row("ColumnName").ToString()))

Regards,

3

@yangyq10

The image depicts a UiPath workflow sequence that reads data from an Excel file, assigns the joined data to a variable, and displays the result in a message box. (Captioned by AI)
The image depicts a UiPath workflow sequence that reads data from an Excel file, assigns the joined data to a variable, and displays the result in a message box. (Captioned by AI)818×576 20.3 KB

Input:

The image displays a spreadsheet listing different currencies with their respective import and export values. (Captioned by AI)

Output:

The image shows a flowchart sequence in a software automation tool displaying steps to read an Excel workbook, join its data, and display it in a message box, which currently outputs "IMPORT EXPORT EXPORT EXPORT IMPORT EXPORT EXPORT EXPORT." (Captioned by AI)
The image shows a flowchart sequence in a software automation tool displaying steps to read an Excel workbook, join its data, and display it in a message box, which currently outputs "IMPORT EXPORT EXPORT EXPORT IMPORT EXPORT EXPORT EXPORT." (Captioned by AI)1058×553 22.1 KB

4

Hi @yangyq10

Follow the below steps,
→ Use the Read range workbook activity to read the excel and store in a datatable called DT.
→ Then use the assign activtity and create a variable called Str_Value to store all the values in PURCHASE ORDER NUMBER column. Then use the below expression,

- Assign -> Str_Value = String.Join(" ", DT.asenumerable.select(Function(X) X("PURCHASE ORDER NUMBER").toString).tolist())

→ Then use the Type into activity and give the Str_Value to type the value in the variable in the field.

Note: Change the Column name in the expression as it is in excel file.

Hope it helps!!

1 Like
5

@lrtetala Thank you~~Its awesome :smile:

1 Like
6

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