ApachePOI入门案例——读取Excel文件的内容

翰戈.summer

已于 2023-12-04 12:21:27 修改

阅读量446

点赞数 14

于 2023-12-04 12:07:49 首次发布

本文链接：https://blog.csdn.net/qq_74312711/article/details/134780694

版权

其他内容专栏收录该内容

51 篇文章 0 订阅

订阅专栏

依赖

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>4.1.2</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.2</version>
</dependency>

解决上述依赖警告问题

<dependency>
    <groupId>org.apache.commons</groupId>
    <artifactId>commons-compress</artifactId>
    <version>1.22</version>
</dependency>

文件内容

案例

import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;

public class Demo {
    public static void main(String[] args) throws IOException {
        read();
    }

    public static void read() throws IOException {

        //读取Excel文件
        InputStream input = new FileInputStream("D:\\develop\\demo.xlsx");
        XSSFWorkbook excel = new XSSFWorkbook(input);

        //读取第一个Sheet页
        XSSFSheet sheet = excel.getSheetAt(0);

        //获取最后一行的行号
        int lastRowNum = sheet.getLastRowNum();

        for (int i = 1; i <= lastRowNum; i++) {
            //获取行
            XSSFRow row = sheet.getRow(i);
            //获取单元格对象
            String cellValue1 = row.getCell(1).getStringCellValue();
            String cellValue2 = row.getCell(2).getStringCellValue();
            System.out.println(cellValue1 + " " + cellValue2);
        }

        //关闭资源
        input.close();
        excel.close();
    }
}