Summary information from excel files into one excel file

Learn Academy Feedback
1

Hi all.
@rahatadi ^^

I have an sample. I want to extract some information ( highlighted with YELLOW ) from 2 excel files ( Source File 1 & 2 ) file into one excel file ( Destination File ) as attached files.

How to do it on UiPath ?

Thanks you very much!Source File 1.xlsx (21.7 KB)
Source File 2.xlsx (33.3 KB)
Destination File.xlsx (8.0 KB)

2

@trunghai

apologies for late reply, i was busy in other work…

please check attached file.
read_files.zip (63.1 KB)

1 Like
3

@rahatadi
i’m sorry because disturb to you.

Thanks you so much always… you save my life ^^

4

@rahatadi
Sorry, I have one small question.

Why we use Write Line Activity in this case?

5
51360Ă—768 70.5 KB

5

@trunghai

dose this solved your problem ?

no need for sorry…:slight_smile:
write line just for reference.

if folder contains other than xlsx files then you just need to use if condition
“xls.EndsWith(“xlsx”)”

6

@rahatadi

I want to TRIM some individual in string as below picture with UiPATH… how to do this ?

I think when we create a Data Table, we can extract and trim in this step right ?

6
61360Ă—768 56.3 KB

7

read_files.zip (63.3 KB)

please refer this file

8

@rahatadi
Hi, Thanks you for your file.

But I want to TRIM from the space position to the end of this string.

After the final result will show as below :

5
51360Ă—768 55.4 KB

9

Use below expression before messages box assign stage

Code = Code.split(" "c)(0)

10

Thanks you so much ^^.

If I want to clear all of content in the Destination File from A2 to C1000 before append or write new data… which command or activity will be used ?

11

@trunghai

May be you can delete file…this is most simple way…

1 Like
12

Thanks you ^^.

13

@rahatadi
Sorry for disturb.

I have one small question. In the destination File, I want to assign a fix text in D column as below picture…

How to assign this case ?

5
51360Ă—768 55.9 KB
Destination File.xlsx (9.4 KB)

14

@trunghai

in build datatable activity just add one more column with name you want…

and in add data row option just add data row with “VIN”

read_files.zip (63.3 KB)

15

Thanks so much.

I set Default Value for D Column to " VN " ^^

16

@trunghai
good :slight_smile:

17

@rahatadi
Hi, sorry with another small question.

I want to value at E column combine from A Column & B Column.

Example : E2 = =A2&“/”&B2

How to setting this case ?

Thanks you.

6
61360Ă—768 56.1 KB
Destination File.xlsx (9.8 KB)

18

@trunghai

you can do something like this

read_files.zip (63.3 KB)

19

@trunghai

problem solved ?

-Aditya

20

@rahatadi

Sorry, I have setting on my project and faced error as below.

5
51360Ă—768 81.7 KB
Excel to Excel TRIM.xaml (12.5 KB)