vikram
(Vikram)
1
Scenario: Excel Sheet with formula on one column (=LENB(D11)), trying to read that excel, but getting exception as “Syntax Error”
Steps to reproduce:Excel Sheet with formula on one column (=LENB(D11)), try to read that excel using Read Range activity
Current Behavior: Throwing Exception as “Message : Syntax error.” Source :- Read Range
Expected Behavior: Need to read data, if any formula or vlookup available
Studio/Robot/Orchestrator Version: 2016.2
Last stable behavior:
Last stable version:
OS Version:
Others if Relevant: (workflow, logs, .net version, service pack, etc):
ddpadil
(Dilip)
2
It’s working fine.
Could you please attach the excel.
vikram
(Vikram)
3
Hi,
Unable to upload excel due to some security issue.
My Excel version is MS 2010
Ui path :- 2016.2
Activity Name:- UiPath.Excel.Activities.ReadRange
i am not using excel application scope
=LENB(Column Number) is using to find character count
ddpadil
(Dilip)
4
Tried with Read Range under “Workbook” tab.
Its working fine too.
vikram
(Vikram)
5
gettng exception as below:
ReadExcel has thrown an exception
Message: Syntax error.
Source: Read range
Exception Type: Exception
System.Exception: Syntax error.
at UiPath.Excel.Activities.WorkbookActivity`1.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
ddpadil
(Dilip)
6
could you please attach screen shot of it.
you can keep range empty for read range activity.
ddpadil
(Dilip)
8
Can’t say much by this it would be good if you’d uploaded the workflow.
Side not: Please update excel package if any available from package manager.
