Java DateUtil.isADateFormat方法代碼示例

import org.apache.poi.ss.usermodel.DateUtil; //導入方法依賴的package包/類
/**
 * 判斷是否是日期，若是返回日期字符串，否則返回數字字符串
 *
 * @param value
 * @param formatIndex
 * @param formatString
 * @return
 */
private String formatRawCellContents(double value, int formatIndex, String formatString) {

    // Is it a date?
    if (DateUtil.isADateFormat(formatIndex, formatString)) {
        if (DateUtil.isValidExcelDate(value)) {

            Date d = DateUtil.getJavaDate(value);
            SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.S");
            return f.format(d);
        }
    }
    String _value = NumberToTextConverter.toText(value);
    if (_value.indexOf('E') > -1) {
        //若是科學計數法,則轉換為非科學計數法
        return new BigDecimal(value).toString();
    }
    return _value;
}
 

import org.apache.poi.ss.usermodel.DateUtil; //導入方法依賴的package包/類
/**
 * Helper method to determine the output types based on the explicit type given as attribute in "cell" element
 * and the type through "style" definition.
 * @param type Value of attribute type {@link ExcelUtil#TYPE} on cell.
 * @param style Value of attribute style {@link ExcelUtil#STYLE} on cell.
 */
private void determineOutputTypes(String type, String style) {
  // Determine the type from attribute
  valueTypeFromAttribute = MinorType.FLOAT8;
  if (type != null) {
    if (TYPE_MAP.containsKey(type)) {
      valueTypeFromAttribute = TYPE_MAP.get(type);
    }
  }

  valueTypeFromStyle = MinorType.FLOAT8;
  if (style != null) {
    if (styleToTypeCache.containsKey(style)) {
      valueTypeFromStyle = styleToTypeCache.get(style);
      return;
    }

    int styleId = Integer.valueOf(style);
    CTXf styleDef = styles.getCellXfAt(styleId);
    if (styleDef != null) {
      long numFmtId = styleDef.getNumFmtId();
      String format = styles.getNumberFormatAt((short) numFmtId);

      if (DateUtil.isADateFormat((int) numFmtId, format)) {
        valueTypeFromStyle = MinorType.TIMESTAMP;
      }
    }
  }
  styleToTypeCache.put(style, valueTypeFromStyle);
}
 

import org.apache.poi.ss.usermodel.DateUtil; //導入方法依賴的package包/類
@Override
public void startElement( String uri, String localName, String name,
		Attributes attributes ) throws SAXException {
	if ( null != name ) {
		switch ( name ) {
			case "row":
				rownum = Integer.parseInt( attributes.getValue( "r" ) ) - 1;
				currentrowdata.clear();
				break;
			case "c": // c is a new cell
				String celltypestr = attributes.getValue( "t" );
				celltype = ( formats.containsKey( celltypestr )
						? formats.get( celltypestr ) : Cell.CELL_TYPE_BLANK );
				// dates don't always have a type attribute
				if ( Cell.CELL_TYPE_NUMERIC == celltype || null == celltypestr ) {
					celltype = Cell.CELL_TYPE_NUMERIC;

					// check if it's a date
					String styleidstr = attributes.getValue( "s" );
					int styleid = ( null == styleidstr ? 0
							: Integer.parseInt( styleidstr ) );

					XSSFCellStyle style = styles.getStyleAt( styleid );
					int formatIndex = style.getDataFormat();
					String formatString = style.getDataFormatString();
					isdate = DateUtil.isADateFormat( formatIndex, formatString );
				}

				String colname = attributes.getValue( "r" );
				colnum = getColNum( colname.substring( 0,
						colname.lastIndexOf( Integer.toString( rownum + 1 ) ) ) );
				break;
			case "v": // new value for a cell
				setReading( true );
				resetContents();
				break;
		}
	}
}
 

import org.apache.poi.ss.usermodel.DateUtil; //導入方法依賴的package包/類
/**
 * DateUtilがLocalizeされたフォーマット(年,月,日等を含むフォーマット)に対応していないため、
 * フォーマットの""で囲まれた文字列を除去するようにして対応。
 * DateUtilが対応されたらそっちを使用する。 
 * Bug 47071として報告済み
 * 
 * @param cell 対象セル
 */
public static boolean isCellDateFormatted( Cell cell) {
    if ( cell == null) {
        return false;
    }
    boolean bDate = false;

    double d = cell.getNumericCellValue();
    if ( DateUtil.isValidExcelDate( d)) {
        CellStyle style = cell.getCellStyle();
        if ( style == null) {
            return false;
        }
        int i = style.getDataFormat();
        String fs = style.getDataFormatString();
        if ( fs != null) {
            // And '"any"' into ''
            while ( fs.contains( "\"")) {
                int beginIdx = fs.indexOf( "\"");
                if ( beginIdx == -1) {
                    break;
                }
                int endIdx = fs.indexOf( "\"", beginIdx + 1);
                if ( endIdx == -1) {
                    break;
                }
                fs = fs.replaceFirst( Pattern.quote( fs.substring( beginIdx, endIdx + 1)), "");
            }
        }
        bDate = DateUtil.isADateFormat( i, fs);
    }
    return bDate;
}
 

import org.apache.poi.ss.usermodel.DateUtil; //導入方法依賴的package包/類
@Override
  public String formatRawCellContents(double value, int formatIndex, String formatString)
  {
    if (DateUtil.isADateFormat(formatIndex, formatString))
    {
      return super.formatRawCellContents(value, formatIndex, DATE_TIME_FORMAT);
    }
    else
    {
      return new Double(value).toString();
//      return super.formatRawCellContents(value, formatIndex, formatString);
    }
  }
 

import org.apache.poi.ss.usermodel.DateUtil; //導入方法依賴的package包/類
private boolean isDateCell( String cellStyle ) {
  if ( cellStyle != null ) {
    int styleIdx = Integer.parseInt( cellStyle );
    CTXf cellXf = styles.getCellXfAt( styleIdx );
    if ( cellXf != null ) {
      // need id for builtin types, format if custom
      int formatId = (int) cellXf.getNumFmtId();
      String format = styles.getNumberFormatAt( formatId );
      return DateUtil.isADateFormat( formatId, format );
    }
  }
  return false;
}
 

import org.apache.poi.ss.usermodel.DateUtil; //導入方法依賴的package包/類
private boolean checkForDateFormat(int numberFormatId, String formatCode) {
	return DateUtil.isADateFormat(numberFormatId, formatCode);
}
 

import org.apache.poi.ss.usermodel.DateUtil; //導入方法依賴的package包/類
@Override
public boolean isMatchingCellType(StreamingCell cell) {
    return DateUtil.isADateFormat(cell.getNumericFormatIndex(), cell.getNumericFormat());
}
 

import org.apache.poi.ss.usermodel.DateUtil; //導入方法依賴的package包/類
boolean isDateFormat(CellValueRecordInterface cell) {
  final int formatIndex = getFormatIndex(cell);
  return DateUtil.isADateFormat(formatIndex, getFormatString(formatIndex));
}
 

import org.apache.poi.ss.usermodel.DateUtil; //導入方法依賴的package包/類
boolean isDateFormat(PoiCellStyle cellStyle) {
    org.apache.poi.ss.usermodel.CellStyle style = cellStyle.poiCellStyle;
    int i = style.getDataFormat();
    String f = style.getDataFormatString();
    return DateUtil.isADateFormat(i, f);
}
 

import org.apache.poi.ss.usermodel.DateUtil; //導入方法依賴的package包/類
private boolean isCellDateFormatted( Cell cell ) {

    	if (cell == null) return false;

        if ( ! DateUtil.isValidExcelDate(cell.getNumericCellValue()) ) return false;

        CellStyle style = cell.getCellStyle();
        if( style == null ) return false;

        int    formatIndex = style.getDataFormat();
        String format      = style.getDataFormatString();

        // Apache poi's missing logic
        format = format.replaceAll( "([^\\\\])\".*?[^\\\\]\"", "$1" );

        return DateUtil.isADateFormat( formatIndex, format) ;

    }