java 解析Excel 并判断解析的数据类型__Eclipse工程

package com.alex.excel; import java.io.File; import java.io.IOException; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.usermodel.XSSFWorkbook; public class ExcelTest { private Workbook book = null; /** * 从指定位置读取Excel文件，未对文件的格式进行校验 */ private void getExcel(){ try { File file = new File(""); //获取工程全路径 String filePath = file.getCanonicalPath(); //需要解析的Excel名称 String fileName = "用户权限录入模版.xlsx"; //将路径与文件名称拼接在一起 String path = filePath+File.separator+fileName; //将excel转换为XSSFWorkbook对象 book = new XSSFWorkbook(path); } catch (IOException e) { e.printStackTrace(); } //sheet表单验证 getSheetData(book); } private void getSheetData(Workbook book) { //按sheet名称获取sheet Sheet moduleSheet = book.getSheet("用户角色配置表"); //本sheet 共有多少行 int moduleRows = moduleSheet.getPhysicalNumberOfRows(); for(int i=0; i<moduleRows; i++){ //每一行共有多少列 int num = moduleSheet.getRow(i).getPhysicalNumberOfCells(); //循环处理每个单元格的内容 for(int j =0; j<num; j++){ Cell cell = moduleSheet.getRow(i).getCell(j); String cellValue = checkCellDataType(cell); System.out.print(" "+cellValue); } System.out.println(); } } /** * 校验数据类型，并统一转换为String * @param cell * @return String */ private String checkCellDataType(Cell cell){ String cellValue = ""; if(cell == null){ return cellValue; } //判断数据的类型 switch (cell.getCellType()){ case Cell.CELL_TYPE_NUMERIC: //数字 cellValue = String.valueOf(cell.getNumericCellValue()); break; case Cell.CELL_TYPE_STRING: //字符串 cellValue = String.valueOf(cell.getStringCellValue()); break; case Cell.CELL_TYPE_BOOLEAN: //Boolean cellValue = String.valueOf(cell.getBooleanCellValue()); break; case Cell.CELL_TYPE_FORMULA: //公式 cellValue = String.valueOf(cell.getCellFormula()); break; case Cell.CELL_TYPE_BLANK: //空值 cellValue = ""; break; case Cell.CELL_TYPE_ERROR: //故障 cellValue = "非法字符"; break; default: cellValue = "未知类型"; break; } return cellValue; } /** * 本地测试 * @param args * @throws Exception */ public static void main(String[] args) throws Exception{ ExcelTest et = new ExcelTest(); //方法调用 et.getExcel(); } }