While using modern read range activity i am getting extra empty rows like (,,,,,)

[shaik.muktharvalli1 (shaik muktharvalli)]

While using modern read range activity i am getting extra empty rows like (,)

Anyone help please

Thanks
Shaik

[ashokkarale]

@shaik.muktharvalli1,

This happens when there is some formatting to those rows. So read range consider it as valid rows to read and add them to the datatable.

One solution would be used Filter activity and remove rows where value is empty.

[shaik.muktharvalli1 (shaik muktharvalli)]

@ashokkarale ranges are dynamically changes then what have to do ?

[ashokkarale]

@shaik.muktharvalli1,

Use Find First/Last Data Row activity to find last row and pass this last row in Range