Forum Discussion

Preetha's avatar
Preetha
Occasional Contributor
6 years ago

Not able to retrive the date from the excel sheet.

Not able to retrive the date from the excel sheet.

 

Excel I am using is professional 2013.

 

When I read a date from excel it is retriving as text hence for date 18/03/2019

it retrives as 43542.  How can can I get it in the date format?

  • Issue resolved 

    I had updated the excel from standard to pro 2013. When I made changes and saved the excel and rerun the scripts the issue got some how solved.

  • Preetha's avatar
    Preetha
    Occasional Contributor

    Issue resolved 

    I had updated the excel from standard to pro 2013. When I made changes and saved the excel and rerun the scripts the issue got some how solved.