Glen, If this method was to be added to POI ( assuming you haven't already done it ) would you have any preference as to its location. Personally, I think it makes sense in HSSFCell, but wanted to get a blessing before creating the patch. Any thoughts?
Glen Stampoultzis wrote: >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. >>>> >>> >> >> > > >
