1.创建文件流,打开EXCEL文件
FileInputStream excelFile = newFileInputStream(excelPath);
XSSFWorkbook workbook= new XSSFWorkbook(excelFile);
2.切换到对应文件名
XSSFSheet excelSheet = workbook.getSheet(sheetName);
3.获取实际行数和列数
int rows = excelSheet.getPhysicalNumberOfRows(); //行数
int cols = excelSheet.getRow(0).getPhysicalNumberOfCells();//列数
4.读取数据
public static String ReadData(XSSFSheet excelSheet, int row, intcol){try{
String CellData= "";
XSSFCell cell=excelSheet.getRow(row).getCell(col);if(cell.getCellType() ==HSSFCell.CELL_TYPE_NUMERIC){
cell.setCellType(Cell.CELL_TYPE_STRING);
CellData=cell.getStringCellValue();
}
elseif(cell.getCellType() ==HSSFCell.CELL_TYPE_STRING){
CellData=cell.getStringCellValue();
}
elseif(cell