javacommon.excel.ExcelConstants.java Source code

Introduction

Here is the source code for javacommon.excel.ExcelConstants.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package javacommon.excel;

import org.apache.commons.io.FilenameUtils;

/**
 * Excel ?
 *
 * @author xc
 * @version 1.0
 * @since 2013-12-03
 */
public class ExcelConstants {

    /**
     * 03?? Excel
     */
    public static final int EXCEL_XLS_VERSION = 0;
    /**
     * 07?? Excel
     */
    public static final int EXCEL_XLSX_VERSION = 1;

    /**
     * ?
     */
    public static String[] DATE_PATTERNS = new String[] { "yyyy-MM-dd", "yyyy-MM-dd HH:mm", "yyyy-MM-dd HH:mm:ss", //        "yyyy/MM/dd","yyyy/MM/dd HH:mm", "yyyy/MM/dd HH:mm:ss",
    };

    /**
     * ?Excel
     *
     * @param filename
     * @return Excel  0 : 1997Excel(?xls);1 : 2007Excel(?xlsx)
     */
    public static int getExcelType(String filename) {
        String extension = FilenameUtils.getExtension(filename);
        if (extension.equalsIgnoreCase("xls")) {
            return EXCEL_XLS_VERSION;
        } else if (extension.equalsIgnoreCase("xlsx")) {
            return EXCEL_XLSX_VERSION;
        }
        return EXCEL_XLS_VERSION;
    }
}