在php中读取Excel空白列

composer require phpoffice/phpexcel

require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\IOFactory;

$filename = 'path/to/your/excel/file.xlsx';

$spreadsheet = IOFactory::load($filename);
$worksheet = $spreadsheet->getActiveSheet();

$highestColumn = $worksheet->getHighestColumn();
$highestColumnIndex = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($highestColumn);

$data = [];

for ($col = 1; $col <= $highestColumnIndex; $col++) {
    $cellValue = $worksheet->getCellByColumnAndRow($col, 1)->getValue();
    $data[] = $cellValue;
}

// $data数组中存储了Excel文件第一行的所有列数据，包括空白列