Hello everyone!
I don’t know how to get large number from the excel, which is “379892013159762” and when I try to write it but it writes “3.79892E+14”
Does anyone knows how to handle this?
@Yoichi san, Onegaishimasu.
1 Like
Hi
There are two ways
-
Either change the type of that column to Text in excel file itself and then try to update the data to it so that it doesn’t convert to this format
-
Or if the file is getting generated dynamically and can’t be set as a template then you have again two options
-
you can use single quote before to the value like this “ ‘ “+ yourvalue.ToString something like this for your reference
-
or you can use Balareva activity - a custom component from UiPath marketplace to change the format of that column as text
Or in addition u can try with this method also which was discussed earlier in forum
Hope this helps
Cheers @Temuulen_Buyangerel
2 Likes
Hope this clarifies @Temuulen_Buyangerel
1 Like
Read the excel using workbook activities and uncheck preserveformatting option
This should solve
Even on normal read range try with raw values option instead of display values
Cheers
1 Like
Hi @Temuulen_Buyangerel ,
With large value you can use generic or object variable in output of activity read cell
to use it, we can convert to String
regards,
1 Like
@Temuulen_Buyangerel
Let us know for any further clarification
I tried this one and works fine
Thanks for solution!
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.