org.zkoss.poi.ss.util

Class DateFormatConverter

java.lang.Object

org.zkoss.poi.ss.util.DateFormatConverter

public 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日'

  

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	DateFormatConverter.DateFormatTokenizer

Constructor Summary

Constructors

Constructor and Description
DateFormatConverter()

Method Summary

Modifier and Type	Method and Description
static String	convert(Locale locale, DateFormat df)
static String	convert(Locale locale, String format)
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

Constructor Detail

DateFormatConverter

public DateFormatConverter()

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)