Read range still include empty cells and write into next excel

Greeting,

I’m having trouble figuring out why read range still copying blank cells in excel and write into new excel even inside read range is “”. The process is only copying values and write into new excel and fill the first row.

How the process should be:
image

My Error:
image

@DTECH
because “” will make uipath read starting from cell “A1”

after read range you can use filter data table to filter out blank rows
so that when you write range there wont be any empty rows left

Thanks, after many runs, I realise the empty cells actually fill with " " values instead of empty. So inside filter I put remove column 0 if = " ".

1 Like

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