Hi all, I am using for each loop from a list of string, i am finding the date in excel using loop, when I pass currentitem/currentitem.tostring it thrown an error of “Assign: Value cannot be null. (Parameter ‘input’)” and when i pass the date manually in the value to find it works. I don’t know what’s the problem with the code i have checked an validate every step.
Please check the properties panel of the activities and check whether you have passed all the mandatory values.
Regards
Hi @connect360
excel_sheet_name variable is empty please check
No its not empty i have checked it again.
Hi @connect360
Check this format:
Excel.Sheet("Sheet3").Range("")
Yes i have checked all the values are provided. i dnont know why its not working.
@connect360
Try this
Excel.Sheet(excel_sheet_name).Range(“A1:IV70”)
Excel.Sheet(“Sheet3”).Range(“”) this format is already used and i have used this format in another process where this format is working properly.
debug and inspect
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.