java解析excel方法(包括.xlsx格式和.xls格式)

package test;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;


import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;






/**
 * java解析excel方法(包括.xlsx格式和.xls格式)
 * 
 * */

public class Test {

    //主方法

    public static void main(String[] args) throws Exception {

          String filePath = "D:\\新建 Microsoft Excel 工作表.xlsx";
          String[] columns = {"全宗号","全宗名称","序号","档号","年度","月份","成文日期","文件标题","保管期限","密                           级","备注"};
         unExcel(filePath,columns);

    }

  /**
     * 调用解析excel方法
     * 参数：filePath excel文件路径
     */    
    public static void unExcel(String filePath,String[] columns) {
        Workbook wb =null;
        Sheet sheet = null;
        Row row = null;
        List list = null;
        String cellData = null;
       
        wb = readExcel(filePath);
        if(wb != null){
            //用来存放表中数据
            list = new ArrayList();
            //获取第一个sheet
            sheet = wb.getSheetAt(0);
            //获取最大行数
            int rownum = sheet.getPhysicalNumberOfRows();
            //获取第一行
            row = sheet.getRow(0);
            //获取最大列数
            int colnum = row.getPhysicalNumberOfCells();
            for (int i = 1; i