BOT is not able to capture 0 in case of formatted text or preceded by an apostrophe

Help Activities
, ,
1

Hi,

BOT is not able to capture 0 in case of formatted text or preceded by an apostrophe

image
test (2).xlsx (26.8 KB)

Forum Engagement Daily Reports
2

You need to read the values right ?
You apply format general to the column and then try to read the values.

3

thrugh UiPath how can i do that

4

Hi @sshitol

Can you try to enable Preserve Format option in Read Range Workbook activity

Regards,

5

@sshitol,

Which activity you are using to read this file?

6

This image shows a UiPath workflow with activities to read data from an Excel workbook named "test (2).xlsx" and display a specific cell value (053807103) in a message box. (Captioned by AI)

I should be able to read it if you are storing it to a string.

7

read is fine… try to paste in other excel or sheet, then u ll not able to see 0

8

yes but not working…

9

@sshitol

Can you please share the expected output or screenshot of workflow

Regards,

10

Maybe it’s excel feature that it removes 0 in the beginning. you may try the attached solution and let me know if it works.
ReadFormattedNumber.xaml (8.3 KB)

11

@sshitol

Before pasting use format cells to make the column as tect and then write

Or better use copy paste range and use formatting as well…so that the values are copied exactly

By default when you write a number to excel it takes in number or general format which removes leading zero …so we need to force it to text…on the first excel it is done using a apostrophe or the column format as text…the same should be done on the final file

Cheers