If the format applied to the date value within the cell already ensures that it is displayed as mm/dd/yyyy then all you need to do is use the formatCellValue(Cell) method of the DataFormat class. This will return a String that encapsulates the date formatted as it would have been within the cell.
On the other hand, if you are working with dates that are formatted differenetly and which you always want to convert into that format, use the date support - Date\Calendar\GregorianCalendar - that is built into the core Java API. Here, you would recover a Date value from the Excel cell (getDateCellValue() if the cell is a numeric type and if the isCellDateFormattedMethod(Cell) of the DateUtil class returns true) and then use the Calendar classes methods to recover the day, month and year values from it. Next, simply create a String using these values and the appropriate separator. Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/how-to-print-the-exact-date-cell-value-in-the-excel-sheet-date-format-like-mm-dd-yyyy-using-apache-p5-tp3270275p3270378.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
