After working well for a while, suddenly ExcelReadRange issues 2 errors:
BC30800: Method arguments must be enclosed in parentheses.
BC30198: ‘)’ expected.

Please advise
After working well for a while, suddenly ExcelReadRange issues 2 errors:
BC30800: Method arguments must be enclosed in parentheses.
BC30198: ‘)’ expected.
Please advise
Hi @Udiar
Remove the spaces encounter in the range parameter.Delete and insert again.
Try by passing the Range path into a str variable and pass in the readrange.
Check by printing the path var before passing into it by using message box or log message.
If still you are facing issue,try by using modern excel read range activity.
Hope it helps!!
Thank you for your response.
Thank you!
To enable the Modern experience
GO to Project Panel->Settings->Enable Modern Experience
Give range in below format
Excel.Sheet("Sheet3").Range("A"+str_startLine.ToString+":AM"+str_end_line.ToString)
Thanks, but it also issues similar errors.
Hi @Udiar
Can you check and show the values of variables str_Start_Line and str_Last_Line_To_Read using Message box
Regards
Hi @Udiar
The expression looks good and is working fine for me.
Excel.Sheet(“Sheet1”).Range(“A”+str_StartLine+“:AM”+str_EndLine.ToString)
Can you evaluate it by passing it in variables, you can use Immediate window to window by placing breakpoint before the Read Range Activity
You can check the below video and the doc for getting more idea on the modern excel acitivties.
To read excel you can do as below:
Activities - Use Excel File (uipath.com)
Thanks,
Shabbir