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

17

any solution for this??

18

I’m afraid nothing changed. I had to set some fake range like “A5:D5000” to read data starting from cell “A5”

19

@pboleszc Hello Pawel,

Instead of giving fake range as D5000, you can take count of datatable rows and give it as

“A5:D”+InputDT.rows.count.ToString

20

How about following

dt = ReadRange(“A:A”) - will read whole column A into dt
dt = dt.AsEnumerable.Skip(4).CopyToDataTable - skip first 4 rows of dt, i.e. same as read from A5

Cheers