How to read range starting from specific cell onwards?

datatable
excel

#1

Hi Guys,

I am trying to read range from excel starting from a specific cell onwards. for example. i want to read the range from cell B9 onwards but i it will be dynamic based on the excel document.

I tried to read the range from "B9: " but it didnt work, is there any suggestion please since the end cell is not defined and will be changed based on the document ?

Thanks


#2

Have you tried just B9 without the colon? Or can you just use B9:B1000000 (or the max possible number) and simply remove any blank items from your datatable?


#3

Hi @richarddenton

I have tried all the options, it just doesn’t like it. please let me know if there is anything you’ve tried works. Also regarding setting up the end cell as B10000 that is a good idea.

I am new to UIpath, would you please guide me how to remove the blanks?

Thanks


#4

@Yan: Why aren’t you going through the training materials first?


#6

@Yan please, have you found the answer?
Thank you !