导入jar包
commons-collections4-4.1.jar
poi-3.17.jar
poi-ooxml-3.17.jar
poi-ooxml-schemas-3.17.jar
xmlbeans-2.6.0.jar
Workbook wb = new HSSFWorkbook(文件流\输入流或URL地址)___________后缀名为xls使用
Workbook wb = new XSSFWorkbook(文件流\输入流或URL地址)___________后缀名为xlsx使用
Workbook.getSheetAt(N)_________________________________________获取第N+1个工作区
Sheet.getPhysicalNumberOfRows() _______________________________获取行数
Sheet.getRow(N)________________________________________________获取第N+1行
Row.getPhysicalNumberOfCells()_________________________________获取列数
Row.getCell(N) ________________________________________________获取第N+1个单元块
Cell.getNumericCellValue()___________________________________