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. > >
fmc_sample.xls
Description: MS-Excel spreadsheet
