java读取Excel

通过java程序读取简单的Excel工作表

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Cell;
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 java.io.File;
import java.io.FileInputStream;
import java.io.IOException;

public class ReadExcel {
    public static void main(String[] args) throws IOException, InvalidFormatException {
        File file=new File("WriteExcel.xlsx");
        FileInputStream stream=new FileInputStream(file);
        Workbook book=new XSSFWorkbook(file);
//        Sheet sheet=book.getSheet("Sheet0");//读取“Sheet0”的工作簿
        Sheet sheet=book.getSheetAt(0);//默认读取第一个工作簿
        int FirstRowNum=0;
        int LastRowNum=sheet.getLastRowNum();//获取工作簿中的行数
        for (int i = FirstRowNum; i <LastRowNum ; i++) {
            Row row=sheet.getRow(i);
            int LastcellNum=row.getLastCellNum();//获取一行中单元格数
            for (int j = 0; j <LastcellNum ; j++) {
                Cell cell=row.getCell(j);
                String value=cell.getStringCellValue();//获取单元格的属性值
                System.out.print(value+"  ");
            }
            System.out.println();
        }
    }
}

相关jar包可以到https://poi.apache.org/download.html#POI-4.1.0下载