So that i dont have to worry about its format...just show me what's showing on the excel sheet.
-----Original Message----- From: Glen Stampoultzis [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 6:21 PM To: [EMAIL PROTECTED] Subject: Re: Dates!! No, why would you say that? ----- Original Message ----- From: "Agarwal, Vinay (Cognizant)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 03, 2002 9:08 PM Subject: RE: Dates!! > If its a custom format then shudn't it be > of type 'HSSFCell.CELL_TYPE_STRING'. > > -----Original Message----- > From: Glen Stampoultzis [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 03, 2002 4:20 PM > To: [EMAIL PROTECTED] > Subject: Re: Dates!! > > > Okay, I've done some investigation of this. Looks like your date has been > defined as a custom format. > > Not sure what you can do about that one. There's really nothing there > except the format string to tell whether it's a date or not and > unfortunately the format string can take many forms. > > Regards, > > Glen > > ----- Original Message ----- > From: "Agarwal, Vinay (Cognizant)" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, May 03, 2002 2:46 PM > Subject: RE: Dates!! > > > > Yeah sure.... > > It's fmc_sample.xls > > > > > > -----Original Message----- > > From: Glen Stampoultzis [mailto:[EMAIL PROTECTED]] > > Sent: Friday, May 03, 2002 9:58 AM > > To: [EMAIL PROTECTED] > > Subject: Re: Dates!! > > > > > > Must be an undocumented format. Are you able to send a sample > spreadsheet? > > (Either to the list or [EMAIL PROTECTED] if you don't want the whole world > > seeing your workbook). > > > > Thanks, > > > > Glen > > > > ----- Original Message ----- > > From: "Agarwal, Vinay (Cognizant)" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, May 03, 2002 2:27 PM > > Subject: RE: Dates!! > > > > > > > Date format in excel looks like '01-Jan-94' > > > > > > -----Original Message----- > > > From: Glen Stampoultzis [mailto:[EMAIL PROTECTED]] > > > Sent: Friday, May 03, 2002 9:44 AM > > > To: [EMAIL PROTECTED] > > > Subject: Re: Dates!! > > > > > > > > > What does your date format look like in Excel? > > > > > > -- Glen > > > > > > ----- Original Message ----- > > > From: "Agarwal, Vinay (Cognizant)" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Friday, May 03, 2002 2:13 PM > > > Subject: RE: Dates!! > > > > > > > > > > It doesn't work for me...... > > > > Interesting tning is when I add one more case to your list of cases > ,it > > > > works. > > > > > > > > I added case 165: and it worked.... > > > > > > > > Something like this... > > > > > > > > switch(i) { > > > > // Internal Date Formats as described on page 427 in > > > > Microsoft Excel Dev's Kit... > > > > case 0x0e: > > > > case 0x0f: > > > > case 0x10: > > > > case 0x11: > > > > case 0x12: > > > > case 0x13: > > > > case 0x14: > > > > case 0x15: > > > > case 0x16: > > > > case 0x2d: > > > > case 0x2e: > > > > case 0x2f: > > > > case 165: // IT WORKS HERE IN THIS CASE > > > > bDate = true; > > > > break; > > > > default: > > > > bDate = false; > > > > break; > > > > > > > > Any answers to this...... > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: Hoffman, Jason [mailto:[EMAIL PROTECTED]] > > > > Sent: Thursday, May 02, 2002 6:15 PM > > > > To: '[EMAIL PROTECTED]' > > > > Subject: RE: Dates!! > > > > > > > > > > > > Okay, here is a little code I used to determine if the cell was a > number > > > or > > > > date, and then format appropriately. I hope it helps. I keep meaning > > to > > > > submit a patch with the helper method below.... but just haven't had a > > > > chance. > > > > > > > > /////// code snippet //////////// > > > > case HSSFCell.CELL_TYPE_NUMERIC: > > > > double d = cell.getNumericCellValue(); > > > > // test if a date! > > > > if (isCellDateFormatted(cell)) { > > > > // format in form of M/D/YY > > > > cal.setTime(HSSFDateUtil.getJavaDate(d)); > > > > cellText = > > > > > > > (String.valueOf(cal.get(Calendar.YEAR))).substring(2); > > > > cellText = cal.get(Calendar.MONTH)+1 + "/" + > > > > cal.get(Calendar.DAY_OF_MONTH) + "/" + > > > > cellText; > > > > } > > > > /////// end code snippet //////////// > > > > > > > > // HELPER METHOD BELOW TO DETERMINE IF DATE > > > > > > > > // method to determine if the cell is a date, versus a number... > > > > public static boolean isCellDateFormatted(HSSFCell cell) { > > > > boolean bDate = false; > > > > > > > > double d = cell.getNumericCellValue(); > > > > if ( HSSFDateUtil.isValidExcelDate(d) ) { > > > > HSSFCellStyle style = cell.getCellStyle(); > > > > int i = style.getDataFormat(); > > > > switch(i) { > > > > // Internal Date Formats as described on page 427 in Microsoft > > > Excel > > > > Dev's Kit... > > > > case 0x0e: > > > > case 0x0f: > > > > case 0x10: > > > > case 0x11: > > > > case 0x12: > > > > case 0x13: > > > > case 0x14: > > > > case 0x15: > > > > case 0x16: > > > > case 0x2d: > > > > case 0x2e: > > > > case 0x2f: > > > > bDate = true; > > > > break; > > > > > > > > default: > > > > bDate = false; > > > > break; > > > > } > > > > } > > > > return bDate; > > > > } > > > > > > > > -----Original Message----- > > > > From: Agarwal, Vinay (Cognizant) [mailto:[EMAIL PROTECTED]] > > > > Sent: Thursday, May 02, 2002 5:22 AM > > > > To: [EMAIL PROTECTED] > > > > Subject: Dates!! > > > > > > > > > > > > Hi, I am not sure if this is a bug . > > > > I am trying to read a xls file which has a cell with Date format. > > > > I have used EventExample.java for this purpose. What is happening > is > > > > that > > > > instead of date it returns me a number. I looked at the APIs for > > > DateRecord > > > > but > > > > there isn't such class. I am just wondering how to get around this > > > problem,I > > > > am > > > > aware that Excel stores dates as numbers and probably i am getting > that > > > > number. > > > > > > > > Why dont we have DateRecord class similar to NumericRecord. > > > > > > > > > > > > > >
