Need to read range 5275th row to last row but cannot find last low

Help StudioX
,
1

Good morning!

image

From this picture, I want to read range 5275th row to last row but I cannot find last low
Because the header of excel file are merged in a mess
And user doesn’t need to modify a format

Thanks,

2

@Nattawadee_Srisai

You can read whole sheet giving range as A1 and then use remove data row to remove all the rows not needed

Else try giving only the frist cell as A5275 and check that should read data till last in read range

If you are getting blank rows at end then use filter datatable

Cheers

3

Hello @Nattawadee_Srisai , Welcome to UiPath Community
You can use the read range activity with “A5275”, it will read till the end of the row.
image