File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Open Source Projects and the fly likes JXL: Reading Time Format Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "JXL: Reading Time Format" Watch "JXL: Reading Time Format" New topic

JXL: Reading Time Format

Joseph Siao
Ranch Hand

Joined: Feb 26, 2004
Posts: 32
Hi. I am using JXL to read an Excel file using Java.

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:
subject: JXL: Reading Time Format
It's not a secret anymore!