Package org.apache.poi.ss.util

Class DateFormatConverter

java.lang.Object

org.apache.poi.ss.util.DateFormatConverter

public final class DateFormatConverter
extends Object

Convert java DateFormat patterns into Excel custom number formats. For example, to format a date in excel using the "dd MMMM, yyyy" pattern and Japanese locale, use the following code:

      // returns "[$-0411]dd MMMM, yyyy;@" where the [$-0411] prefix tells Excel to use the Japanese locale
      String excelFormatPattern = DateFormatConverter.convert(Locale.JAPANESE, "dd MMMM, yyyy");

      CellStyle cellStyle = workbook.createCellStyle();

      DataFormat poiFormat = workbook.createDataFormat();
      cellStyle.setDataFormat(poiFormat.getFormat(excelFormatPattern));
      cell.setCellValue(new Date());
      cell.setCellStyle(cellStyle);  // formats date as '2012年3月17日'
  

TODO Generalise this for all Excel format strings

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	DateFormatConverter.DateFormatTokenizer

Method Summary

Modifier and Type	Method	Description
static String	convert(Locale locale, String format)
static String	convert(Locale locale, DateFormat df)
static String	getJavaDatePattern(int style, Locale locale)
static String	getJavaDateTimePattern(int style, Locale locale)
static String	getJavaTimePattern(int style, Locale locale)
static String	getPrefixForLocale(Locale locale)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

getPrefixForLocale

public static String getPrefixForLocale(Locale locale)

convert

public static String convert(Locale locale,
                             DateFormat df)

convert

public static String convert(Locale locale,
                             String format)

getJavaDatePattern

public static String getJavaDatePattern(int style,
                                        Locale locale)

getJavaTimePattern

public static String getJavaTimePattern(int style,
                                        Locale locale)

getJavaDateTimePattern

public static String getJavaDateTimePattern(int style,
                                            Locale locale)