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
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
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
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015