Class DateFormatConverter


  • public class DateFormatConverter
    extends java.lang.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
    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static java.lang.String convert​(java.util.Locale locale, java.lang.String format)  
      static java.lang.String convert​(java.util.Locale locale, java.text.DateFormat df)  
      static java.lang.String getJavaDatePattern​(int style, java.util.Locale locale)  
      static java.lang.String getJavaDateTimePattern​(int style, java.util.Locale locale)  
      static java.lang.String getJavaTimePattern​(int style, java.util.Locale locale)  
      static java.lang.String getPrefixForLocale​(java.util.Locale locale)  
      • Methods inherited from class java.lang.Object

        equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • Constructor Detail

      • DateFormatConverter

        public DateFormatConverter()
    • Method Detail

      • getPrefixForLocale

        public static java.lang.String getPrefixForLocale​(java.util.Locale locale)
      • convert

        public static java.lang.String convert​(java.util.Locale locale,
                                               java.text.DateFormat df)
      • convert

        public static java.lang.String convert​(java.util.Locale locale,
                                               java.lang.String format)
      • getJavaDatePattern

        public static java.lang.String getJavaDatePattern​(int style,
                                                          java.util.Locale locale)
      • getJavaTimePattern

        public static java.lang.String getJavaTimePattern​(int style,
                                                          java.util.Locale locale)
      • getJavaDateTimePattern

        public static java.lang.String getJavaDateTimePattern​(int style,
                                                              java.util.Locale locale)