Running into issues with Course "Build Your First Process With Studio" Specifically with Excel Consolidation Runtime Error

Learning Hub Academy Feedback
, ,
1

Hi UiPath sorry if this post is out of the guidelines as it’s my first time posting and I am running into issues with the “Build Your First Process With Studio” Specifically with Excel Consolidation Part 1 exercise. I have been following the video to a T and encountering “Run Time Execution Error” this is about 3:00 minutes into the tutorial video. Please see my attached photo for reference and this is the error I am getting.

" UiPath.Excel.ExcelException: Failed opening the Excel file C:\Users\StevenVinci\Documents\UiPath\Excel reports consolidation\ \SalesResults-2024-03-08.xlsx. Possible reasons: the file is corrupt, the file is already used by another process or you don’t have permissions to open the file. —> System.Runtime.InteropServices.COMException: Microsoft Excel cannot access the file ‘C:\Users\StevenVinci\Documents\UiPath\Excel reports consolidation\ \64FEC500’. There are several possible reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook. at Microsoft.Office.Interop.Excel._Workbook.SaveAs(Object Filename, Object FileFormat, Object Password, Object WriteResPassword, Object ReadOnlyRecommended, Object CreateBackup, XlSaveAsAccessMode AccessMode, Object ConflictResolution, Object AddToMru, Object TextCodepage, Object TextVisualLayout, Object Local)
at UiPath.Excel.WorkbookApplication.CreateNewWorkbookIfNeeded(String workbookPath, Boolean createNew, Workbooks workbooks)
at UiPath.Excel.WorkbookApplication.InternalOpenWorkbook(WorkbookArguments args, Boolean onlyIfWorkbookExists)
— End of inner exception stack trace —
at UiPath.Excel.WorkbookApplication.InternalOpenWorkbook(WorkbookArguments args, Boolean onlyIfWorkbookExists)
at UiPath.Excel.ExtendedWorkbookFactory.Create(Boolean attachOnly)
at UiPath.Excel.WorkbookQuickHandle.SafeGetWorkbook(Boolean attachOnly)
at UiPath.Excel.WorkbookQuickHandle.OpenWorkbook()
at UiPath.Excel.Activities.Business.ExcelApplicationCard.InitializeQuickHandle(RuntimeLoggingService runtimeLogging, IWorkbookQuickHandle workbookQuickHandle, IExcelProcess excelProcess, WorkbookDefaultOptions workbookDefaultOptions, String path, String password, String editPassword, Boolean createIfNotExist, Boolean keepExcelOpen, Nullable`1 readFormatting, Boolean readOnly, ResizeWindowOptions resizeWindow, Boolean saveChanges)
at UiPath.Excel.Activities.Business.ExcelApplicationCard.Execute(NativeActivityContext context)
at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)"

Feedback about the ** Build Your First Process With Studio** Academy course.
Please type your feedback below.

1 Like
2

Hi @Steven_Vinci and welcome to our community! I’m wondering if @Bianca.Dragu can give a hand here. Thank you for your patience.

3

Thanks and looking forward for some assistance been going crazy trying to figure this one out.

4

First thing i would check

  • Do you have the file currently open? if so > close it and run UiPath again
  • What if you open the filepath in your windows file explorer. Will it open the file?
    • No? > Your path is not correct. Change the path to the correct one and run UiPath again.

Second thing
Why do you have two backslashes in your filepath? C:\Users\StevenVinci\Documents\UiPath\Excel reports consolidation\ \SalesResults-2024-03-08.xlsx

Try to avoid spaces in filenames and directories.

Workaround
Copy the file to another location for example to C:\tmp\SalesResults-2024-03-08.xlsx and see if that works from UiPath.

Make sure not to open the file. UiPath will do that by itself.

If it still doesn’t work, please provide some screenshots

5

Hi @loredana_ifrim would it be possible to remove the temporary restrictions so I can include a screenshot for this post ?