Probelm while importing timefiled excel data into Ax

Hi All,

while importing data from Excel to Ax i am unable to read timefiled in excel to ax using this following code can anyone can help me?

pylEmplTimeSheetEntryLineTable.ActualTimeIn= xlsCells.item(Row,6).value().time();

Hi Vijay…

Check the excel shell which you are trying to pick the time xlsCells.item(Row,6). – it may have shell type isdifferent (may customer type or number type)… so change it time type ,then it will take the value automatically…

You might need to format the field. Does xlsCells.item(Row,6).value().time() return a result? If yes, what format is it? What data type is xlsCells?