I need to read the Time value from excel sheet. I have used all the possible functions but whenever i run the job, i get the output as 0, or -1 . Is there any other solution by how i can read the time value from the excel cell?
Iam using the below syntax to read the data from excel cell.
cells.item(row, 1).value().time();
and
cells.item(row,1).bstr();
The Value that was stored in excel sheet is in Time Data type.
| Ex: 04:00:00 |
|---|
Thanks in advance.
Sreekant.