Read Range: Could not read range error

Help Forum
1

image
image1306×813 29 KB

2

Hi @Soudios,

Try below things and see if that works

  1. Check that the file does not have any hidden rows or columns, it can cause this error
  2. Try using workbook read range activity to read.
  3. Select all the empty cells for example you have data till A200 then select all the rows from A201 till last of excel and perform CTRL + - this will delete the rows the reason for this is sometimes excel contains junk data which is not visible but the UiPath identifies it.

Thanks

4

Hi @Soudios

First use kill process “Excel”

Before working on any excel from uipath to make sure there are no ongoing excel tasks

Next
If issue still persist use work book activities

5

here the file :
EXCEL1.xlsx (10.4 KB)

6

Can u try reading with workbook @Soudios

7

how can i do that ?

8

Hi @Soudios,

Looking you excel I saw that there are same name columns in the excel file which is causing the error.

Thanks

9

In activities search workbook , so once you search , there will be read range workbook --drag that activity and provide your excel path

10

i just change the column name but there is no same column name in mine

11

So can u try workbook activities

12

Don’t have

image
image359×565 9.85 KB

13

Yes there select readrange

14

Try like this

image

1 Like
15

@Soudios follow this
activities search workbook , so once you search , there will be read range workbook --drag that activity and provide your excel path

This works similar to excel application scope readrange

16

Thank you its working well

17

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.