java读取excal内容

import java.io.File;import java.io.FileInputStream;import java.io.IOException;import java.io.InputStream;import java.util.ArrayList;import java.util.List;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.ss.usermodel.Cell;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;public class ImportExecl {private String errorInfo;// @描述：main测试方法     public static void main(String[] args) throws Exception {System.out.println((System.currentTimeMillis()+ "").length());ImportExecl poi = new ImportExecl();List<Pointcard> list = poi.read("E:/book.xlsx");if (list != null) {for (int i = 0; i < list.size(); i++) {System.out.print("第" + (i) + "行");Pointcard cellList = list.get(i);     System.out.print("    " + cellList.getUserkey());  System.out.print("    " + cellList.getToken());    System.out.print("    " + cellList.getSearNo());   System.out.print("    " + cellList.getCardNo());   System.out.print("    " + cellList.getPsw());      System.out.print("    " + cellList.getSourceKey());  System.out.print("    " + cellList.getNum());      System.out.print("    " + cellList.getStartTime());  System.out.print("    " + cellList.getEndTime());  System.out.print("    " + cellList.getTvId());   System.out.println();}}}// @描述：读取数据private List<Pointcard> read(Workbook wb) {List<Pointcard> dataLst = new ArrayList<Pointcard>();/** 得到第一个shell */Sheet sheet = wb.getSheetAt(0);/** 得到Excel的行数 */final int totalRows = sheet.getLastRowNum();int totalCells = 0; System.out.println("Excel的行数::::" + sheet.getLastRowNum());/** 得到Excel的列数 */if (totalRows >= 1 && sheet.getRow(0) != null) {totalCells = sheet.getRow(0).getPhysicalNumberOfCells();}/** 循环Excel的行 */for (int r = 1; r <= totalRows; r++) {Row row = sheet.getRow(r);if (row == null) {continue; }   //定义点卡对象  每一行代表一个对象   Pointcard pointcard = new Pointcard();/** 循环Excel的列 */ inner: for (int c = 0; c < totalCells; c++) {Cell cell = row.getCell(c);String cellValue = "";// 如果为空 本行数据不合法if (null == cell) {System.out.println("数据不合法:::理由::数据为空::第"+r+"行"); // 跳出内层循环break inner;}else {   if (c < 6) {// 每列前六个数据 为String类型// 如果类型匹配 则加入到Pointcard对象中 否则终止内层循环if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {cellValue = cell.getStringCellValue();if (cellValue.length() <= 32) {switch (c) {case 0: pointcard.setUserkey(cellValue);break;case 1:pointcard.setToken(cellValue);break;case 2:pointcard.setSearNo(cellValue);break;case 3:   pointcard.setCardNo(cellValue);break;case 4:pointcard.setPsw(cellValue);break;case 5:pointcard.setSourceKey(cellValue);break; }   }else {System.out.println("数据不合法:::理由::数据类型不匹配 c<6");break inner;}   }else{System.out.println("数据不合法:::理由::数据类型匹配  但是字段过长  c<6");break inner;}    }else if (c == 6) {// 每列的第七个数据为int类型 if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) { int amount = (int)(cell.getNumericCellValue());pointcard.setNum(amount);  } else {System.out.println("数据不合法:::理由::数据类型不匹配 不为int类型  c=6");break inner;}   }else if (c > 6 && c < 9) {//数据类型为Date类型if (cell.getCellType() == HSSFCell.ENCODING_COMPRESSED_UNICODE) {java.util.Date date =  cell.getDateCellValue();System.out.println(date.getTime());if (c == 7) {pointcard.setStartTime(date.getTime());} else {pointcard.setEndTime(date.getTime());  }}else {System.out.println("数据不合法:::理由::数据类型不匹配 不为long类型  c > 6 && c < 9");break inner;}}else if (c==9) {if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {cellValue = cell.getStringCellValue();pointcard.setTvId(cellValue);}else { System.out.println("数据不合法:::理由::数据类型不匹配 不为long类型  c =9");break inner;}}}}/** 保存第r行pointcard对象 */if(pointcard.getUserkey()!=null&&pointcard.getToken()!=null&&pointcard.getSearNo()!=null&&pointcard.getCardNo()!=null&&pointcard.getPsw()!=null&&pointcard.getSourceKey()!=null&&pointcard.getNum()!=0&&pointcard.getStartTime()!=null&&pointcard.getEndTime()!=null    &&pointcard.getTvId()!=null){dataLst.add(pointcard);   }   }   return dataLst;}// @描述：根据文件名读取excel文件public List<Pointcard> read(String filePath) {List<Pointcard> dataLst = new ArrayList<Pointcard>();InputStream is = null;try {/** 验证文件是否合法 */if (!validateExcel(filePath)) {System.out.println(errorInfo);return null;}/** 判断文件的类型，是2003还是2007 */boolean isExcel2003 = true;if (WDWUtil.isExcel2007(filePath)) {isExcel2003 = false;}/** 调用本类提供的根据流读取的方法 */File file = new File(filePath);is = new FileInputStream(file);dataLst = read(is, isExcel2003);is.close();} catch (Exception ex) {ex.printStackTrace();} finally {if (is != null) {try {is.close();} catch (IOException e) {is = null;e.printStackTrace();}}}/** 返回最后读取的结果 */return dataLst;}   // @描述：根据流读取Excel文件public List<Pointcard> read(InputStream inputStream,boolean isExcel2003) {List<Pointcard> dataLst = null;try {/** 根据版本选择创建Workbook的方式 */Workbook wb = null;if (isExcel2003) {wb = new HSSFWorkbook(inputStream);} else {wb = new XSSFWorkbook(inputStream);}dataLst = read(wb);} catch (IOException e) {e.printStackTrace();}return dataLst;}// @描述：验证excel文件public boolean validateExcel(String filePath) {/** 检查文件名是否为空或者是否是Excel格式的文件 */if (filePath == null|| !(WDWUtil.isExcel2003(filePath) || WDWUtil.isExcel2007(filePath))) {errorInfo = "文件名不是excel格式";return false;}/** 检查文件是否存在 */File file = new File(filePath);if (file == null || !file.exists()) {errorInfo = "文件不存在";return false;}return true;}}// @描述：工具类class WDWUtil {// @描述：是否是2003的excel，返回true是2003public static boolean isExcel2003(String filePath) {return filePath.matches("^.+\\.(?i)(xls)$");}// @描述：是否是2007的excel，返回true是2007public static boolean isExcel2007(String filePath) {return filePath.matches("^.+\\.(?i)(xlsx)$");}}

excel 格式为