Wrong format typing from data table

Using read range I have converted an excel to data table.
While using type into activity date format typed as 445641. Even I checked preserve format in read range.
I need to type each row to website.
Could you please help me…

Hi @Rakshi ,

The date value coming from your excel is a serial number. Its the format of excel which ia converting the date to serial number.

Try using this formula in your for each loop for the date column value.

DateTime.FromOADate(Double.Parse(dateValue))

Hi Thank you,

I am getting error on this input string not valid.
Please see the attached coding example. Is this correct?
image