Getting Wrong Format Data In Excel

Help Activities
1

Hi Team,

Facing Issue While I was looping through the data in excel I was getting the number instead of date time.

Attached screenshot for reference.

Thanks

IMG_7431
IMG_74313024×4032 2.84 MB

1 Like
2

Hi @Thriesh_Naidu

In Read Range Workbook activity check Preserve format option

3

Hi @Thriesh_Naidu

If you are using Read range workbook activity, go to properties and check the Preserve format option.
image

If you are using the Use excel file activity open the properties of that activity and select the Raw value from the dropdown.
image

Hope it helps!!

1 Like
4

Hi @lrtetala @mkankatala

I have checked preserve format. below screenshot for reference

image
image4032×3024 3.94 MB

5

Hi @Thriesh_Naidu

Can you please share the sample excel file.

Regards

6

Instead of using the Workbook activity use the Excel activities, Use the Use excel file activity and insert the For each excel row activity to loop through the each row.

Change the property of Use excel file activity to raw value for Read formatting option.

Hope you understand!! @Thriesh_Naidu

2 Likes
7

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