Date Time Values Are Converted Into Numeric Values - Excel Write Range

Hi,

I have an excel sheet data of attendance. I have to group the data in state-wise and write it into a separate excel sheet state-wise respectively.

After writing the excel sheet the date strings are converted to the numeric value. Can anyone have an idea to change the format? If I manually change the format then it comes for the correct format.

MasterAttendance.xlsx (Existing Sheet)
image

After grouping the output will be,
StateWiseAttendance.xlsx (State-wise sheet will be created)
image

Output Expected :
I need check-in and check-out cell values look like the below format as in the master attendance sheet.

07/15/2019 08:31 AM

Please find the AttendanceReport.zip (21.1 KB). Can you help me to get the expected outputs?

Thanks.

1 Like

hello @kuppu_samy

select the preserve format option while reading the excel,
bot will read the excel with the same format which you mentioned in the excel

Regards
Ajay

Hi @Ajju,

I enabled the PreserveFormat Property in Read Range activity. But I didn’t get the expected values. Please refer the attachment AttendanceReport.zip (21.1 KB).

@kuppu_samy

i am getting output like below

AttendanceReport (2).zip (30.1 KB)

1 Like

Thanks @Ajju,

It’s working only in newer Office Excel only. I have checked with Excel 2016, it works fine. Before I have executed with Excel 2010, I doesn’t gone well.

yeah cheers buddy :wink:

1 Like

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