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