aspose file tools*
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


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "JXL: Reading Time Format" Watch "JXL: Reading Time Format" New topic
Author

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:
sheet.getCell(7,i).getContents()

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.

 
 
subject: JXL: Reading Time Format