I am curious at what point the errors stop occurring while following along on MacBook. I believe I have added all the necessary subscriptions required to successfully use studio through parallel everything software related is currently updated to its latest versions I initially started the process of following along to build my first automation without having the excel file downloaded to my one drive but it was located in my downloads within my MacBook. Upon moving it to my one drive I copied and pasted the exact file required in different files all within my windows storage however when I click run after following the steps it says it can’t be found essentially. If I have something wrong guidance will be greatly appreciated.
As per the error message it was able to take the path only till sales and fron space it is not able to …just to make sure it works can you move the excel file directly under project folder which is excelreports consolicdation and then give the name of the file directly and check
Cheers
1 Like
I apologize can you break this down into smaller steps for clarity purposes.
I am not sure what the proper format will be if I am to change the file name in the Expression editor.
So I figured out the proper formatting and was able to make it to the end only to find that all the information within the original downloaded excel file was not pasted when I tried to run the process for the final attempt. Hope that makes sense not sure where the error occurred. Thinking my only solution is to delete everything and retry the steps. If there are any alternatives please inform me.
Looks like excel reports consolidation came twice in the error message path …looks like it should come only once…can you remove the extra one
Cheers
Im not sure I understand I apologize. What file are you referring to? The file I had to download from the UiPath course, or the file name that I saved it as?
I have ran through the process of building my first automation several times and have yet to get the proper outcome.
Hi
Check the excel scope and use excel file activity and see the output
Handle name
As per the error the sheet is not part of the handle
Check sheet name for casing
And empty space
If sheet name is having empty space in original excel file.
1 Like
Please check the Excel Sheet Name are any Spaces are there in sheet name .
Thanks ,
Purushotham
1 Like
Ok yes the error was a simple grammatical issue. However now that I have finally followed through both part one and two of the build your first process video my issue now is that the information within my input file is not getting extracted into the output file. I have run the process multiple times while following along and when I have the wrong information entered I receive an error message but after trial and error I believe I have entered the correct information because when I run the process I don’t receive those same error notifications and I’ll see that the execution ended. So I am confused as to why none of the information is being displayed within the excel file.
Check if file open normally not in read mode
Save the excel file again by additional step and
Add close excel or kill excel in the last and add delay between opening excel file and excel activity where u r reading or writing
I have the file saved the only thing I am unaware on how to do is how to add a delay within the automation process.
There is activity name delay search and you will get it and in format of Hh:mm:ss
Based on the 1/2 sec delay you can give like this
00:00:02
1 Like
Ok thank you ill try this and see how it goes.
ashokkarale
lrtetala
ppr
Yoichi
SorenB
alper_ozyurt
chauhan.rachita30
Phanvi99
torontothomas135