Hi:
I am using JExcel to read an excel file published on the internet. There's a cell that appears to be a date (6/2/2007). But when I tried to get its content by doing the following what I got is an integer-like string.
String mystring = cell[1].getContents(); //a cell appears to be 6/2/2007
System.out.println(mystrin
I tried: (DateCell)cells[1]).getDat
How should I resolve the problem?
Thank you.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
When you divide 39235 by 365.25 it gives you 107.42, which seems to suggest that the number you got is the number of days since 1/1/1900 and thus you can do the following to get a java.util.Date from it:
int days = Integer.parseInt( cell[1].getContents() );
Calendar cal = new GregorianCalendar( 1990, 0, 1 ); // 0 means january here
cal.add( Calendar.DAY_OF_YEAR, days );
Date date = cal.getDate();
System.out.println( "the date is: " + date );
Thanks guys.
I've found that if I put 39235 in an excel worksheet and format its data type to Date then I get 6/2/2007. Does JExcel provides any API for formating the datatype of a cell? I think x4u's approach would work. But I am just curious if there's an alternative.
I tried parsing the String with SimpleDateFormat but got an ParseException...
Business Accounts
Answer for Membership
by: sciuriwarePosted on 2007-07-06 at 21:38:40ID: 19436327
Get it as a String and convert it by SimpleDateFormat("MM/dd/yy
;JOOP!