java POI方式解析Excel 代码

private Workbook getWorkBook(String filePath) {
        //xls-2003, xlsx-2007
        FileInputStream is = null;
        try {
            is = new FileInputStream(filePath);
            if (filePath.toLowerCase().endsWith("xlsx")) {
                return new XSSFWorkbook(is);
            } else if (filePath.toLowerCase().endsWith("xls")) {
                return new HSSFWorkbook(is);
            } else {
                throw new RuntimeException("excel解析异常");
            }
        } catch (IOException e) {
            throw new RuntimeException("excel解析异常", e);
        } finally {
            IOUtils.closeQuietly(is);//需要common-io包
        }
    }

/**下标从0 开始*/
Sheet sheet = workBook.getSheet("sheet1");//一个Excel有多少个sheet
Row row = sheet.getRow(0);//获取指定sheet的行
Cell cell = row.getCell(0);//获取行上的单元格
 double value = cell.getNumericCellValue();
 String value = cell.getStringCellValue();