How to read range starting from specific cell onwards?

Help
,
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?

1 Like
6

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

7

@Yan
Just use ā€œB9ā€ From the UiPath documentation:

  • Range - Specifies the range of cells to be read. If this value is not specified, the whole spreadsheet is read. If the value consists of only one cell, the whole spreadsheet is read starting from that cell. Only String variables and strings are supported.
2 Likes
8

@dzhou I have faced the same problem
I have try to read range from ā€œb19ā€ but it come to ā€œerrorā€ and say"Read Range: A column named ā€˜420ā€™ already belongs to this DataTable."

%E6%8D%95%E8%8E%B7
%E6%8D%95%E8%8E%B71080Ɨ497 21.7 KB

9

@xiepanfeng This is a different issue. Do you have two identical column headers with the name ā€˜420ā€™?

10

I have figured it out, tks @dzhou

11

Can you please share how you managed to figure it out please ?
Thanks. :slight_smile:

12

it means you have greater than 2 columns with the same column nameā€¦

13

OK thank you. Iā€™ll investigate this.

14

I donā€™t want to open another topic, because my question is in fact the same, but it relates to action ā€˜Read Rangeā€™ in the ā€˜Microsoft Office 365 Activitiesā€™.

In the classic Read Range writing one cell (eg. ā€˜A5ā€™) is interpreted as the starting cell.

In the O365 Read Range writing one cell is interpreted as reading only one cell.

How can I set the starting cell in O365 Read Range action?

16

Hi,

Did you find any solution?

Thanks