Read Range Activity is not working, when formula is available in Excel

excel
uiautomation
activities
readrange

#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):


#2

It’s working fine.
Could you please attach the excel.


#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


#4

Tried with Read Range under “Workbook” tab.
Its working fine too.
:roll_eyes:


#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)


#6

could you please attach screen shot of it.
you can keep range empty for read range activity.


#7

8-22-2017 2-59-12 PM


#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.