JAVA读取Excel文件

读取Excel文件内容

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import java.io.File;
import java.io.IOException;
import java.util.ArrayList;

  @Test
    void test() throws IOException, BiffException {
        //读取Excel
        File file = new File("C:\\Users\\LZW\\Desktop\\test.xls");
        //获取工作薄
        Workbook workbook = Workbook.getWorkbook(file);
        //获取第0个sheet
        Sheet sheet = workbook.getSheet(0);
        //获取行数
        System.out.println("行：" + sheet.getRows());
        //获取列数
        System.out.println("列：" + sheet.getColumns());
        //循环读取并存入list，从第二行开始
        ArrayList<String> list = new ArrayList<>();
        for (int i = 1; i < sheet.getRows(); i++) {
            for (int j = 0; j < sheet.getColumns(); j++) {
                Cell cell = sheet.getCell(j, i);
                System.out.print(cell.getContents() + " ");
                list.add(cell.getContents());
            }
        }
    }

依赖

    <dependency>
        <groupId>net.sourceforge.jexcelapi</groupId>
        <artifactId>jxl</artifactId>
        <version>2.6.12</version>
    </dependency>