Work Arounds for Retrieve Excel Formated Data

'While you read from excel, cells which contain formula's like =Today(), =Date()
'may not reflect the same text when you retreive them.

'Workarounds
'1. So you might change in the cells in Excel as follows:
'=Text(TODAY())

dtmCellValue=Datatable.GetSheet("sheetname").getParameter("ColumnName").RAWVALUE