Date in excel format is correct when file opened manually but gets bad when uipath opens it with excel scope

I am using excel where i need to copy data from one csv file to other excel file. However, when i open the excel manually i see every row has a date format. But when UiPath opens it in excel application scope, some of the rows are date format but some are general as shown below.

Below is the format when i open the file manually

Below is the file opened by UiPath (Both are exactly same file). Dates aligned to right are date format and to left are general format which is causing problem

this is the second screenshot

@dixit.sachin380

Welcome to the community

when you say when opened are you reading data and writing to it then it changes?

cheers

Hi @dixit.sachin380

Could you please show properties of your excel application scope?

Also when you open file manually select the dates column and right click and format cells, do you see date format selected there?