Register / Login
this forum made possible by our volunteer staff, including ...
Stephan van Hulst
Other Open Source Projects
JXL: Reading Time Format
posted 6 years ago
Hi. I am using JXL to read an Excel file using
One of the columns on the file is in a Time Format.
What is displayed in the Excel cell is (24-hr format): 0:01
When I highlight the cell, the value is different in the formula bar. It reads 12:01:00 AM
Using the code:
returns a value of 12:01
My problem is, using the value extracted, there is no way for me know if 12:01 is AM or PM.
How can I extract the value from excel getting the displayed value? the 0:01.
or, how can I extract the value, that I can get the AM/PM?
Please advice. thank you.
It is sorta covered in the
JavaRanch Style Guide
Boost this thread!
non-printable special characters
JExcelApi - read a cell that contains a formula, but want to read the calculated value of the formul
finding the empty cell using jxl
Using JDBC to insert into MS Excel file
Reading date from Excel Spreadsheet