Workbook read cell does not work

[abdel (Robot usa)]

Hello Friends,

I have an excel sheet, where i want to extract a cell, the cell contain a formula, with read cell it gives always 0, with read formula it gives the formula.
I’m using Workbook activities, i can’t use Excel one for security purpose.

attached the file.sample.xlsx (30.5 KB)

[THIRU_NANI (NaNi)]

Hi! can you tell me which cell you want to read?

Regards,
NaNi

[abdel (Robot usa)]

@abdel

with read cell it gives always 0

the cell F16

[prasath_S]

Hi @abdel

Seems the problem is not solved yet,

Workbook read cell return always 0 for formula result

Hi, It’s able to read it as String. However cannot read as numeric like double as the following. [img20210922-5] If data is input as numeric correctly, Read Cell activity can handle it as numeric. So, probably this is reason why the formula returns 0 by Workbook - Read Cell activity. Regards,

For an alternate solution,

Use an invoke VBA activity and macro and pass the value from Excel to UiPath.

Refer this post

Excel Macro Output: How to send an output to UiPath?

When I run Execute Macro, how do I set an output in my macro to be retrieved by UiPath in Macro Output?

Thanks