A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Other Open Source Projects
JXL: Reading Time Format
Joined: Feb 26, 2004
Jun 01, 2011 21:47:31
Hi. I am using JXL to read an
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.
It is sorta covered in the
JavaRanch Style Guide
subject: JXL: Reading Time Format
Using JDBC to insert into MS Excel file
JExcelApi - read a cell that contains a formula, but want to read the calculated value of the formul
Reading date from Excel Spreadsheet
finding the empty cell using jxl
non-printable special characters
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014