You know this may not work internationally.
Glen Stampoultzis wrote:
>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.
>>
>
>
>
