Get data in excel sheet and write it to another sheet

[KSK_R_D]

Hi everyone, i’ve been struggling with this problem quite a long time. I have a sheet containing data like this

I want to get the data of the this sheet and write it to another sheet, i managed to read the data as well as skipped empty cells. but i did not get the exact result i required.
Please help me!

[KSK_R_D]

I want to get the data in the column “AI” from sheet “VAN PHONG”

And write it to column D (D46 - D50) of the sheet “Tong luong”

[Anas-p-v]

Use Read range workbook activity, pass the sheet name and for Range pass “AI:AI” and while writing back, use range “D46:D50”. Attaching screenshot for reference.

[KSK_R_D]

thanks for the reply, i did it but the result has a little problem

[Anas-p-v]

This could be because there are merged cells on the source datatable, use a filter datatable activity before writing cells and remove empty/blank rows, then write results to destination sheet.

[KSK_R_D]

can you help with that, i need it to be more specific, i’m still new to UiPath

[Anas-p-v]

Use filter data table activity from activity panel, provide the table to be filtered and the condition (column which to be checked for non empty values). Attaching screenshot below for reference.

[KSK_R_D]

OMG, you’re my hero, i can’t believe in my eyes now