Excel - Visual Errors

Help Studio
1

Hi everyone !!

I am facing a issue, Where resultant Excel of my bot is with some visual errors,

image

Here if you see in the cell ,The data is incorrect but in the function bar, the data is Accurate, What’s happening?, Why the data is represented like that ?!

Kindly Help !!

Thanks in advance !!

2

Hi @Rakesh_Sampath - This has nothing do with UiPath.
please check with Video.

Or You can write your value as “String” or Insert ’ (single Quote) in front the number…

if you open Excel type a 12 digit number, it will automatically turns into E+11

image

3 Likes
3

before you write to that excel, open the excel manually and then:

1- highlight column A, go to Data-> Text to columns
note: (column A must have at least 1 non-empty cell before you can click “text to columns”)

image
image1415×684 46.5 KB

  1. keep pressing next until this page, when in this page, click “Text” then click finish

    image
    image781×551 14.8 KB

  2. highlight column A, right click and click format cells
    image

  3. choose text
    image

  4. next time you write to this excel it should appear fine like this

    image
    image242×536 2.84 KB

2 Likes
4

Hi @Rakesh_Sampath

Welcome to UiPath Comunity!!!

This issue is with the Excel itself, if you type a number more than 11 digits it will automatically convert into E+11 (exponent form).
Make the excel column in Text format.
Or if you are fetching this and saving it into Excel then create a template (having a column in Text format) for storing the data.

Thank You, Happy Coding!!!

1 Like