I was performing an automation where everything seemed normal but this error popped up. I added the read range workbook activity and also added my input but now it says the “workbook does not exist”. Also while adding the data in advance expression there was no drop-down of variables, is there any key to see the drop-down?
Thank You in advance.
Hey @Anirudh_Tugawe ,
Can you please just check the path and the sheet is given correctly
It should be probably a path error cause i had replicated Ur scenario and got the same error
yes checked it twice the path given is correct, I have added that path as an asset .
By any chance did you add inverted comma in asset value?
If so remove it we should not be giving
Also can you print the path and check and use same one which is copied in file explorer
While adding the path of the excel and sheet name to an asset make sure not to give double quotes within the path.
Read Range Workbook: Value cannot be null. (Parameter ‘path1’) I resolved the last error now its showing me value is null. i checked the range its (“”) but still
Do not give double quotes while adding assets. It will resolve your issue.
Can you show a acreenshot of your log
And also as specified earlier in my comments …in assets we should not add double quotes
i have checked there is no double quotes wile writing assets. please find screenshots of log as well as properties.
Remove the double quotes in the Range property and run the workflow. It might solve the error.
Please check the variables as well…looks like some value is empty…keep a break point and when pause check the locals panel and perform step into to check if there is any value change
And in logs I dont see a path beingb logged
The error looks like the excel path is null please check it once
Can you check the excel path which you have given in the asset by placing a log message before read range workbook activity
The error clearly says the path is the issue, not range. You think you’re giving it a valid path but you’re not.
This error will appears when the excel file is not exist in the given path. Recheck the excel file path and provide the proper path in Read Range workbook activity.
Hope it helps!!
Yes!! the extension was missing, I was working with Excel so it needed “.xlsx” so I changed and it worked smoothly.
i am still trying to understand the exceptions and errors, Thank you
Thank you @Anirudh_Tugawe
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.