Read Range error on modern Excel Read Range activity

Help Studio
, ,
1

Read Range error on modern Excel Read Range activity - I am getting this error , I know its a huge spread sheet .. so what are the work around for this error – Read Range: Could not read range $A$1:$BC$30711.

2

Hi @Murali_vennapusa

Could you please show how have you defined the range property in read range activity?

Also, could you please check your excel file for the specified range, looks like some formula related error.

3

There is no formula related issues, no formulas .. here is what I have

The image shows a screenshot of a UiPath workflow where a "Read Range" activity is configured to read an Excel sheet with headers into a temporary data table, as seen in the properties panel on the right. (Captioned by AI)
The image shows a screenshot of a UiPath workflow where a "Read Range" activity is configured to read an Excel sheet with headers into a temporary data table, as seen in the properties panel on the right. (Captioned by AI)1167×342 48.2 KB

5

Can you try using read range workbook activity and see if that works for you or that also gives you same error?

6

My situation is bit complex to explain, I am converting legacy existing process to modern Windows versions, hence I don’t want to use legacy activities and wanted to use modern activities only. Hence the issue with “Read Range” with this huge excel spread sheet. Also the ultimate goal of process is the have an “Append” and then Deletes to the same sheet. As we don’t have get range in the modern activities I came up with this solution

  1. Excel scope > Use Excel > Read Range with only one row (Hard coding the range as A1:ZZ1) then found the last data column index
  2. Used “Find Fist/Last DataRow” to get the lastRow
  3. with those two activities I came up with a range like A2:BC34000 and use that in the following delete activity to delete the range .. I know we could do this may ways .. but point is that “Read Range” modern activity has some limitations and few of the good function we had in the legacy Excel are gone its frustrating.. Hope they will come up with those missing activities in the upcoming releases
1 Like
7

@Murali_vennapusa

How about this?

  1. read the whole range into a datatable
  2. then get the datatable rows count to get the last row index
  3. get the datatable columns count to get the last columns index

And then you accordingly use in your further activities?

Also can you confirm that excel sheet doesn’t have any hidden rows/columns..

8

@Murali_vennapusa

may be few things here that might help..

for getting range you can use

Screenshot 2025-06-07 at 12.09.16 PM
Screenshot 2025-06-07 at 12.09.16 PM1334×1276 145 KB

similarly there are other functions that are directly available as well

on top of this feel free to let us know what you feel is missing there might be other ways for that as well

cheers

9

I did try that FullRangeName function , but that does not give me the range it give me the range it gave me this - F0911!A:XFD ( its looks like that is tab name and some range not sure what that is ) actual range is A1:BC34191 that is what I need.

10

As I said due to the fact that this is huge spread sheet read range does not even work , so we can not even read full spread sheet, I wish that worked then , I do know how to get the other details like lastrow and last column from that data table. Thanks for checking

11

Also let me know what other functions we have available , I can try that . but now my round about solution works , but would be interested to know if there are any other better options. Thanks for looking into this .. Murali

12

@Murali_vennapusa

You have excel.sheet("sheetname").RowCount

Fullrange might fail if there is formatting left in other cells data is not present as well

Also you can try with .Address

Also .GetNumberOfColumns

Cheers