Java读取Excel文件

xlsx文件

public static void main() throws IOException, InvalidFormatException {
    File file = new File("E:\\excel.xlsx");
	// HSSFWorkbook sheets = new HSSFWorkbook(file); // xls文件 用HSSFWorkbook
    // xlsx 用XSSFWorkbook
    XSSFWorkbook xWB = new XSSFWorkbook(file);
   	System.out.println(xWB.getNumberOfSheets());
   	// Excel中存在多个sheet，指定第一个sheet
    XSSFSheet sheetAt = xWB.getSheetAt(0);
    // rowIndex = 2；从第三行开始读
    for (int rowIndex = 2; rowIndex <= sheetAt.getLastRowNum(); rowIndex++) {
       	XSSFRow row = sheetAt.getRow(rowIndex);
       	// 输出第4列的数据
        System.out.println(row.getCell(3));
        // 往数据库存 或者 其他操作
    }
}

xls文件

public static void main() throws IOException, InvalidFormatException {
    File file = new File("E:\\excel.xlsx");
	BufferedInputStream bufferedInputStream = new BufferedInputStream(new FileInputStream(file));
	POIFSFileSystem poifsFileSystem = new POIFSFileSystem(bufferedInputStream);
	HSSFWorkbook hWB= new HSSFWorkbook(poifsFileSystem); // xls文件 用HSSFWorkbook
    
    // XSSFWorkbook xWB = new XSSFWorkbook(file); // xlsx 用XSSFWorkbook
   	System.out.println(hWB.getNumberOfSheets());
   	// Excel中存在多个sheet，循环遍历
   	for(int sheetIndex = 0; sheetIndex < hWB.getNumberOfSheets(); sheetIndex++) {
   		HSSFSheet sheetAt = hWB.getSheetAt(0);
   		// 第一行为标题默认不取
	    for (int rowIndex = 0; rowIndex <= sheetAt.getLastRowNum(); rowIndex++) {
	       	HSSFRow row = sheetAt.getRow(rowIndex);
	       	// row.getCell(第几列，从0开始)
	        System.out.println(row.getCell(0));
	        // 往数据库存 或者 其他操作
	    }
	}
    
}