Excel to Data Table, specific cell problem

Help Studio
1

Hello!
I hope to get some advice on this issue illustrated by these pictures.

Somehow the value for row “8410” is set to “0” instead of the shown value in Excel.
The formulas are the same for all values in the excel-column “E”.

formula
formula660×136 6.32 KB

A screenshot of the "Read Range Workbook" activity from UiPath, configured to read data from a file specified by CurrentFile.FullName and the sheet named "CSV". (Captioned by AI)
Data Table
Data Table536×581 11.6 KB

Excel
Excel496×612 14.1 KB

2

I tried using a Excel scope and reading only the values, and it worked. Yet, still bothered as why some cells were read fine with the Workbook option and some not. The formulas were the same. I prefer to use the Workbook-read when possible.

3

@johan.lanne,

Did you try enabling Preserve format?

The image displays the properties window of the UiPath Excel Read Range activity, highlighting the "PreserveFormat" option with a red circle. (Captioned by AI)
The image displays the properties window of the UiPath Excel Read Range activity, highlighting the "PreserveFormat" option with a red circle. (Captioned by AI)461×478 16.1 KB

4

Thank you. I did, but it gave me the same outcome.