Read range - identifier expected

[Olivera_Kalinic (Olivera Kalinić)]

When I am trying to use Read range activity, it gets error as below

As it works correctly with same file, but different Sheet name, the question is why Sheet name “2022-total” is returning error, but “2022” is correct and how to solve it without changing Sheet name (it is already predefined and mapped)?

[THIRU_NANI (NaNi)]

Hey!

Could you check the sheet name again? There might be a space before or after the sheet name

You can try with the get workbook sheets …

Take one for each and inside the for each use the read range…

Regards,
NaNi

[muhammedyuzuak]

Hi @Olivera_Kalinic,

Make sure there are no spaces in the Sheet name field. You can even pull all the sheet names using Get Workbook Sheets and compare it with the sheet name you actually gave.

Regards,
MY

[RK_0 (RK)]

Hi, @Olivera_Kalinic

I have found similar thread with a solution
Try this, it might work for you

Read Range: Identifier expected

I take the names of all the work sheets from a excel file and if the names match with a string, I’m trying to get the last row number of the worksheet. but as you see the pic, Identifier expeted. SEK to EUR is the sheet name and match with “SEK to EUR” string name. The sheet name matches exactly. I have no idea what the problem is. Also I tried that “Excel Application Scope” with “read range” and Sheet.toString but the error continue to occur. Also sometimes the first loop works well, but th…

[anon88744563]

Hi @Olivera_Kalinic
If you Want to Solve the Identifier Error for Ever you have to use
Excel Application Scope for Read Range Instead of Using Workbook Read Range Activity

Try and Let me know

Thanks
Harivishnu