import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.io.InputStream;import java.util.Date;import java.util.HashMap;import java.util.Map;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.DateUtil;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;import org.slf4j.Logger;import org.slf4j.LoggerFactory;/** * 讀取Excel * * @author zengwendong */public class ReadExcelUtils {private Logger logger = LoggerFactory.getLogger(ReadExcelUtils.class);private Workbook wb;private Sheet sheet;private Row row;public ReadExcelUtils(String filepath) {if(filepath==null){return;}String ext = filepath.substring(filepath.lastIndexOf('.'));try {InputStream is = new FileInputStream(filepath);if('.xls'.equals(ext)){wb = new HSSFWorkbook(is);}else if('.xlsx'.equals(ext)){wb = new XSSFWorkbook(is);}else{wb=null;}} catch (FileNotFoundException e) {logger.error('FileNotFoundException', e);} catch (IOException e) {logger.error('IOException', e);}}/** * 讀取Excel表格表頭的內容 * * @param InputStream * @return String 表頭內容的數組 * @author zengwendong */public String[] readExcelTitle() throws Exception{if(wb==null){throw new Exception('Workbook對象為空！');}sheet = wb.getSheetAt(0);row = sheet.getRow(0);// 標題總列數int colNum = row.getPhysicalNumberOfCells();System.out.println('colNum:' + colNum);String[] title = new String[colNum];for (int i = 0; i < colNum; i++) {// title[i] = getStringCellValue(row.getCell((short) i));title[i] = row.getCell(i).getCellFormula();}return title;}/** * 讀取Excel數據內容 * * @param InputStream * @return Map 包含單元格數據內容的Map對象 * @author zengwendong */public Map<Integer, Map<Integer,Object>> readExcelContent() throws Exception{if(wb==null){throw new Exception('Workbook對象為空！');}Map<Integer, Map<Integer,Object>> content = new HashMap<Integer, Map<Integer,Object>>();sheet = wb.getSheetAt(0);// 得到總行數int rowNum = sheet.getLastRowNum();row = sheet.getRow(0);int colNum = row.getPhysicalNumberOfCells();// 正文內容應該從第二行開始,第一行為表頭的標題for (int i = 1; i <= rowNum; i++) {row = sheet.getRow(i);int j = 0;Map<Integer,Object> cellValue = new HashMap<Integer, Object>();while (j < colNum) {Object obj = getCellFormatValue(row.getCell(j));cellValue.put(j, obj);j++;}content.put(i, cellValue);}return content;}/** * * 根據Cell類型設置數據 * * @param cell * @return * @author zengwendong */private Object getCellFormatValue(Cell cell) {Object cellvalue = '';if (cell != null) {// 判斷當前Cell的Typeswitch (cell.getCellType()) {case Cell.CELL_TYPE_NUMERIC:// 如果當前Cell的Type為NUMERICcase Cell.CELL_TYPE_FORMULA: {// 判斷當前的cell是否為Dateif (DateUtil.isCellDateFormatted(cell)) {// 如果是Date類型則，轉化為Data格式// data格式是帶時分秒的：2013-7-10 0:00:00// cellvalue = cell.getDateCellValue().toLocaleString();// data格式是不帶帶時分秒的：2013-7-10Date date = cell.getDateCellValue();cellvalue = date;} else {// 如果是純數字// 取得當前Cell的數值cellvalue = String.valueOf(cell.getNumericCellValue());}break;}case Cell.CELL_TYPE_STRING:// 如果當前Cell的Type為STRING// 取得當前的Cell字符串cellvalue = cell.getRichStringCellValue().getString();break;default:// 默認的Cell值cellvalue = '';}} else {cellvalue = '';}return cellvalue;}public static void main(String[] args) {try {String filepath = 'F:test.xls';ReadExcelUtils excelReader = new ReadExcelUtils(filepath);// 對讀取Excel表格標題測試//String[] title = excelReader.readExcelTitle();//System.out.println('獲得Excel表格的標題:');//for (String s : title) {//System.out.print(s + ' ');//}// 對讀取Excel表格內容測試Map<Integer, Map<Integer,Object>> map = excelReader.readExcelContent();System.out.println('獲得Excel表格的內容:');for (int i = 1; i <= map.size(); i++) {System.out.println(map.get(i));}} catch (FileNotFoundException e) {System.out.println('未找到指定路徑的文件!');e.printStackTrace();}catch (Exception e) {e.printStackTrace();}}}