Getting text from Excel

Help Activities
, ,
1

Hello! I have text cell with RANDBETWEEN formula, where everytime I refresh excel it gives different value in cell. UiPath is not reading this using basic row(0).Tostring in TypeInto activity

Any advice?

2

@Chris_Balance

When you used reach range activity…if using classic activity check the preserve formatting check box…

If using modern activity then use display value to read…so that it the value generated would be read

Hope this helps

Cheers

3

image
I am using Read Range Workbook. But after checking this box did not change anything.

4

@Chris_Balance

Can you try using excel read range please

As the formula might work only when its open you can try checking show excel also so that yhe formula gets updated

Hope this helps

Cheers

1 Like
5

Thank you! Worked with Excel Read Range :slight_smile:

1 Like
6

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