Utils

IO:

/**
 * 读取二进制文件并且写入数组里
 * @param filePath 文件全路径
 * @return
 * @throws IOException
 * @throws FileNotFoundException
 */
public static byte[] getBytes4File(String filePath) throws IOException {

    InputStream in = null;
    BufferedInputStream buffer = null;
    DataInputStream dataIn = null;
    ByteArrayOutputStream bos = null;
    DataOutputStream dos = null;
    byte[] bArray = null;
    try {
        in = new FileInputStream(filePath);
        buffer = new BufferedInputStream(in);
        dataIn = new DataInputStream(buffer);
        bos = new ByteArrayOutputStream();
        dos = new DataOutputStream(bos);
        byte[] buf = new byte[1024];
        while (true) {
            int len = dataIn.read(buf);
            if (len < 0)
                break;
            dos.write(buf, 0, len);
        }
        bArray = bos.toByteArray();

    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
        return null;

    } finally {

        if (in != null)
            in.close();
        if (dataIn != null)
            dataIn.close();
        if (buffer != null)
            buffer.close();
        if (bos != null)
            bos.close();
        if (dos != null)
            dos.close();
    }

    return bArray;
}

/**
 * 根据全路径获取文件名
 * @param path 文件全路径
 * @return 文件名
 */
public static String getFileNameByPath(String path){
    if (StringUtils.isEmpty(path)){
        return null;
    }
    String[] arr = StringUtils.split(path,'\\');
    return arr[arr.length - 1];
}

/**
 * 获取文件长度
 * @param file 文件
 */
public static Long getFileSize(File file) {
    if (file.exists() && file.isFile()) {
        return file.length();
    }
    return null;
}

EXCEL 2007

package com.zw.nph.core.utils.ExcelUtils;

import com.sun.org.apache.xerces.internal.pa