Read Range error, not reading the workbook

Help Studio
, ,
1

Hi everyone please assist here

image
image991Ă—473 23.7 KB

I am trying to read the workbook using read range activity but it gives me this error above when I run it.

image
image1046Ă—391 11.3 KB

Here is the file name:
image
Here is the workbook name:

image
image723Ă—101 2.07 KB

Please help what am I doing wrong

2

Hi @Anelisa_Bolosha

Instead of writing “.xls” try writing FileName+“.xlsx”. It might work and the file may be of extension .xlsx. Try passing the correct Sheet Name also.

Hope this works!!

Regards,

3

@Anelisa_Bolosha,

It is the filename, but in the read range activity you need to pass the sheet name. Open the workbook and get the sheetname. Then try with that in the read range

4

@Anelisa_Bolosha

I guess there is a space after 202305 in the excel sheet…please check the same…if yes either remove space or add space in the sheetname field in ReadRange

cheers

5

The file I am trying to read is in .xls
image

6

@Anelisa_Bolosha Can you please share the workflow so that it would be easy to sort out error.

Regards,

7

Do you have the screenshot for this example please

8

Hi @Anelisa_Bolosha

I have uploaded the workflow and Sample excel for your reference.
Main.xaml (10.0 KB)
User Login Access Report 20230511.xls (24.5 KB)

Hope it helps!!

Regards,

9

User Login Access Report 20230511.xls (10.0 KB)
MainV6 - Copy.xaml (23.5 KB)

10

I have removed the space, because there is space in the naming but still

11

@Anelisa_Bolosha Try giving the full file Path in the FileName variable.

Regards,

12

It works! Thank you so much :blush: :100:

1 Like
13

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