com.obatis.office.excel.constant.ExcelConstant Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of obatis-office Show documentation

obatis-office, apply excel export project

There is a newer version: 1.0.3

package com.obatis.office.excel.constant;

import com.obatis.convert.date.DefaultDateConstant;
import com.obatis.tools.ValidateTool;

import java.text.SimpleDateFormat;
import java.util.Date;

/**
 * @author HuangLongPu
 * @date 2018年11月27日16:02:45
 */
public class ExcelConstant {

    public static final String COLUMN_HORIZONTAL_KEY_PREFIX = "ch";
    public static final String COLUMN_VERTICAL_KEY_PREFIX = "cv";

    public static final String ROW_COL_INDEX = "row";
    public static final String COLUMN_NUMBER_KEY = "column_number";

    public static final int DEFAULT_INDEX = 0;

    /**
     * @param format
     * @param date
     * @return
     */
    public static String getDateString(String format, Object date){

		SimpleDateFormat sdf = null;

		if(ValidateTool.isEmpty(date)) {
		    return null;
        } else if(ValidateTool.isEmpty(format) || DefaultDateConstant.DATE_TIME_PATTERN.equals(format)) {
            sdf = DefaultDateConstant.SD_FORMAT_DATE_TIME;
        } else if (DefaultDateConstant.TIME_MILLIS_PATTERN.equals(format)) {
            sdf = DefaultDateConstant.SD_FORMAT_TIME_MILLIS;
        } else if (DefaultDateConstant.DATE_PATTERN.equals(format)) {
            sdf = DefaultDateConstant.SD_FORMAT_DATE;
        } else if (DefaultDateConstant.YEAR_MONTH_JOINT_PATTERN.equals(format)) {
            sdf = DefaultDateConstant.SD_FORMAT_YEAR_MONTH_JOINT;
        } else if (DefaultDateConstant.DATE_JOINT_PATTERN.equals(format)) {
            sdf = DefaultDateConstant.SD_FORMAT_DATE_JOINT;
        }

        if(date instanceof Date){
            return sdf.format(date);
        }else{
            return date.toString();
        }
    }

}