Excel data changing after reading and writing in uipath

Learn Certification
, ,
1

Hi All

We have some data in excel which are percentage data like 23%. But when we are reading the data from excel like row(“Value”).toString then its changing to 0.23.

We need in the same format like 23%. Kindly help.

2

Hi @kkpatel,

I assume your data in excel is Percentage format like “23%”.
If so, ticking PreserveFormat in Read Range Properties Panel should fix this.

Regards,
Kah Liang

3

Yes it may do that. But i am writing a generic code. And if i tick Preserve Format then if there is any date column then the date format is changing to some abnormal date which is again throwing error.

4

Date 4/2/2021 12:00:00 AM changes to 59/02/21.

5

@kkpatel

I believe you are converting the date string

For Month to mention, can you check did you keep MM or mm

MM - Month
mm - Minutes

Hope this may help you

Thanks

6

I am just doing row(0).toString. so ideally it should fetch whatever data is there in the excel.

7

@kkpatel

Can you share you sample excel file which you are facing issue?

Thanks

8

sure.

9

Eq Outs.xlsx (9.1 KB)

@Srini84 @Srini84 FYR.

10

Hi @Kah_Liang @Srini84 Any solutions ?

11

@kkpatel

By Enabling Preserve format only it is having issue, can you tell me which source are you generating the excel?

Thanks

12

Excel was downloaded from a site called QlikView. Actually the reports were in graphical format but we can right click and save the same in excel.

13

@Srini84 Any update on this thread?

14

@kkpatel

As I told you in a previous post, why don’t you try without using Preserve Format?

Thanks

15