Muralia311
(Murali Akkaraju)
October 16, 2019, 11:39am
1
Hi,
Can some one check this and help me out please…
I have tried read the data using data scraping:
.
2.Whila data scraping it was shown as below:
When i have written this to excel… getting the below error and excel is empty…
19.10.0-beta.111+Branch.release-v2019.10.0.Sha.5972d03192e06f8179804a57fa5cb43db221b000
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)
VDEBAC
(Valérian Debacker )
October 16, 2019, 11:45am
2
Hello,
Did you use an output variable to get the extracted data table?
There should be no limitation to read a uipath variable.
2 Likes
Muralia311
(Murali Akkaraju)
October 16, 2019, 11:48am
3
Yes, I did. I have used datatable and used to write to excel. Even I have tried to display datatable which was showing empty
Fer
October 21, 2019, 3:39pm
4
Hello,
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.
bcorrea
(Bruno Correa)
October 21, 2019, 4:25pm
5
Please check if the excel is not in use, opened or if even really exists.