Distinguish all the cells in an column

Help
1

Hey Guys,

I hope you are doing all wel! and I hope you guys can help me with my problem.

At this moment I have an Excel file which contains 7 columns: Group, hyperlink (Windows File path) and several data columns.

See picture:

excel%20uipath%20forum
excel%20uipath%20forum915×705 10.9 KB

As you can see, the column “group” has three groups: Group 1, 2 and 3.
The name of the group has been changed, because it has some confidential data in it. That’s why i have renamed it to group 1,2, and 3. The group isn’t always the same. It depends each month.

How can the Robot distinguish the name of the group?

The main purpose of this Excel file is to copy only the test data (Column C till G) to the Excel file that is linked on the hyperlink (Column B).

To do that, the robot has to filter the group column and keep only Group 1 and copy the test data to another Excel file. After that, the robot has to filter and keep only group 2 and so on.

Like i said, the column group isn’t always the same, so it is harder to filter it out, if the robot doesn’t know which group contains in the column.

Thank you guys for taking the time and would love to hear to a solution!

Kind regards

2

Hi, can you upload that excel file? Thank you

1 Like
3

Here you go.
Thanks for the reply!

Excel Uipath forum.xlsx (9.4 KB)

1 Like
4

Hi @Nutella,
Please check this flow: GroupSorting.zip (32.0 KB)

Feel free to consult me if there is anything else.
Thanks and regards,
Despi

1 Like
5

Is it all good now? :slight_smile:

1 Like
6

First, Thank you for your time and effort to help me.

Correction: it is not 7 columns but 27 columns. Is it wisely to add 27 columns to the build datatable?

The hyperlink is an existing Excel file and it should’t overwrite the file, but adding the data to the last blank row. How can i do that?

Again thank for your time!

7

So what we can do first is create an excel file for each group. Right?

1 Like
8

We have to copy the data of the first excel file to the existing file that we can reach/open with the hyperlink.

The hyperlink file has already data on it and we just have to add the data from the first excel file.

Please let me know, if you are still confused

9

I have figured it out. Thanks

Is it possible to to only open the excel file once and paste all the rows in the file?
Now it is opening and closing the Excel file for each row.

1 Like
10

Good to hear that!
Yes. You can.
First use Read Range. The output is a data table.
Then use Write Range or Append Range and use the data table as the input.
Thanks

1 Like
11

Do i need to use Excel app or workbook?
I use now the Excel application scope

12

You may use Excel Application Scope

1 Like
13

I have tried it out.

For now it copy and paste all the rows, but it keeps repeating.
Also on the add data row, i have only typed the rows that needs to be paste on the output file, but it also copy the hyperlink cell.

What am I doing wrong?
Main.xaml (29.4 KB)

14

I think you may just uncheck the ‘Visible’ property in the Excel Application Scopes.

1 Like
15

Then in the Append Range activity, use dt BoRapport as the datatable

1 Like
16

Thanks, all the rows are now placed at the same time in the output file.
I have removed the cell “hyperlink” with the filter wizard, which doesn’t need to be copied to the output file, but i get the following error:
Filter Data Table: In the ‘Filter datatable wizard’ the value for argument ‘Column Name’ is not set or is invalid.

What did i do wrong?
Main.xaml (30.5 KB)

17

Okay. I will check. Before that, please mark the reply that helps you most as the Solution :slight_smile:

1 Like
18

Thank you, i have checked the solution

1 Like
19

I checked it. And I can’t see a Hyperlink Column in the data table

1 Like
20

If you just want to remove a column, just use Remove Data Column activity :slight_smile:

1 Like