Data scraping - No data in data table after data scraping


Can some one check this and help me out please…

  1. I have tried read the data using data scraping:


2.Whila data scraping it was shown as below:

  1. When i have written this to excel… getting the below error and excel is empty…


Source: Excel Application Scope

Message: Excel cannot access ‘Data’. The document may be read-only or encrypted.

Exception Type: UiPath.Excel.ExcelException

RemoteException wrapping UiPath.Excel.ExcelException: Excel cannot access ‘Data’. The document may be read-only or encrypted. —> RemoteException wrapping System.Runtime.InteropServices.COMException: Excel cannot access ‘Data’. The document may be read-only or encrypted.
at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)
at UiPath.Excel.WorkbookApplication.InitializeCurrentWorkbook(WorkbookArguments workbookArguments, Workbooks workbooks)
at UiPath.Excel.WorkbookApplication.Initialize(WorkbookArguments args, Boolean onlyIfWorkbookExists)
— End of inner exception stack trace —
at UiPath.Excel.WorkbookApplication.Initialize(WorkbookArguments args, Boolean onlyIfWorkbookExists)
at UiPath.Excel.WorkbookApplication.Initialize(Application excelApp, WorkbookArguments args, Boolean onlyIfWorkbookExists)
at UiPath.Excel.Activities.ExcelApplicationScope.<>c.<.ctor>b__48_0(WorkbookArguments args)
at UiPath.Excel.Activities.ExcelApplicationScope.Execute(NativeActivityContext context)
at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)


Did you use an output variable to get the extracted data table?
There should be no limitation to read a uipath variable.


Yes, I did. I have used datatable and used to write to excel. Even I have tried to display datatable which was showing empty


I am having the same problem. I am using the Studio 2019.10.0-beta.155.

If doing a Data Scraping inside a REFramework, it does show a preview of results. However, when the button Finish is clicked, it does not create any activity in Studio. Can you help me with this error?

I would like to mention, if the above steps are done into a Blank project, it will work perfectly.

Thank you.

Please check if the excel is not in use, opened or if even really exists.