Register / Login
File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
Win a copy of
Clojure in Action
this week in the
Other Open Source Projects
JXL: Reading Time Format
posted 4 years ago
Hi. I am using JXL to read an
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.
I agree. Here's the link:
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