Excel data changing after reading and writing in uipath

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.

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

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.

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

@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

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

@kkpatel

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

Thanks

sure.

Eq Outs.xlsx (9.1 KB)

@ksrinu070184 @ksrinu070184 FYR.

Hi @Kah_Liang @ksrinu070184 Any solutions ?

@kkpatel

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

Thanks

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.

@ksrinu070184 Any update on this thread?

@kkpatel

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

Thanks