Cannot read the values from excel

Help Studio
, ,
1

hello friends i have an excel sheet and im trying to read that but im not able to read manuf date properly. there is some formula present there and it is not getting extracted as date.

image
image773Ă—163 20.6 KB

image
image919Ă—208 18.6 KB

batch report week 16_ 10339220_ 10339221.xlsx (141.1 KB)
excel sheet is attached for reference.
im using readrange workbook activity. Anyone know what is the actual issue

2

While reading excel, in properties select the preserve format option

3

Hey @Ramya_25
Tried, not working

4

Hi @aslam_ali1

It is reading the values properly in my machine

image
image1001Ă—677 23.5 KB

Can you try to upgrade excel package

image

Regards,

1 Like
5

Hello @aslam_ali1

There are a couple of reasons why you might not be extracting the actual value from a formula column in UiPath. Here’s what you can check:

UiPath reads formula text, not calculated value:

  • By default, the “Read Range” or “Read Cell” activities in UiPath return the formula itself, not the calculated value.

Solutions:

  1. Use Excel Application Scope: Wrap your data reading activities (like Read Range or Read Cell) inside an “Excel Application Scope” activity. This ensures Excel recalculates formulas before UiPath reads them, providing the actual values.

  2. Write Formula Output to Another Cell: In your Excel sheet, use a helper column with a formula that references the original formula cell. This helper column will display the calculated value. Then, use UiPath to read the data from the helper column containing the actual values.

Here are some additional resources that you might find helpful:

6

Hi @aslam_ali1

In read range activity properties check the Preserve format option box.
Or
Copy the entire data and do paste special over there to get the exact values.

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.