• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JXL: Reading Time Format

 
Joseph Siao
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic