composer require phpoffice/phpspreadsheet

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

use PhpOffice\PhpSpreadsheet\IOFactory;

$path = ROOT_PATH . '/public/test.xlsx';

$reader = IOFactory::createReader('Xlsx'); // 创建读操作

$excel = $reader->load($path); // 载入excel表格

$sheets = $excel->getAllSheets();

$sheets_count = count($sheets);

echo "共 {$sheets_count} 个工作薄 \n";

foreach ($sheets as $sheet_idx=>$sheet){

    $sheet_idx1 = $sheet_idx + 1;

    $rows_count = $sheet->getHighestRow();

    echo "工作薄 {$sheet_idx1} 共 {$rows_count} 行 \n";

    for ($i = 2; $i <= $rows_count; $i++){

        $account = $sheet->getCell("G{$i}")->getValue();

        $num = $sheet->getCell("I{$i}")->getValue();

        $rate = $sheet->getCell("J{$i}")->getValue();

        echo "工作薄 {$sheet_idx1} {$account} {$num} {$rate} \n";

    }

}

//设置活跃的工作薄，下标从0开始

$excel->setActiveSheetIndex(0);

//获取活跃的工作薄

$sheet = $spreadsheet->getActiveSheet();

//获取第2列第3行单元格的值

$value = $sheet->getCellByColumnAndRow(2, 3)->getValue();

//等价于

$value = $sheet->getCell("B3")->getValue();