String of number is being rounded down in Excel

Help Studio
, , ,
1

Good afternoon,

I have the following problem:
My process is divided into a Dispatcher and a Performer.
The Dispatcher reads out information from a PDF and gives it to a queue.
The Performer enters the information from the queue to an Excel file.

The Dispatcher works fine, the read out information is correct.
For example:
2500000000121589
2500000000121588
2500000000121587
This is read out as String (because for other cases it’s not only the number, but also text is added). (->str_result)

BUT what is entered for all those cases into the Excel file is:
2500000000121580
2500000000121580
2500000000121580

So it’s basically rounding the number down.
But I don’t want that of course.

The column format in Excel is set to “Number” (so that it doesn’t show something like 2,7E+15).

UiPath Activity: Add data row (to a data table)
ArrayRow: {…some other stuff that is working fine, in_TransactionItem.SpecificContent(“Result”).ToString}

Then Append Range to Excel file.
(No option for preserve format as for “read range” etc)

Where is the error?

Thanks in advance for your help on this.

Best regards,
Juli

2

Hello @Juli

Can you set the excel format as Text and try it out? Else you can create a custom format for that column.

3

Hi @Rahul_Unnikrishnan

Well, that worked out fine… :slight_smile:
For the new entry at least. It will still convert old entries to 2,7E+15, though. Then I have to redo the entering process manually.

Thanks a lot!

1 Like
4

Good to hear that :grinning:

5

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