我必须遍历XLS文档的前两列的所有行。问题是该特定文档的第一列是" G",索引为7。
。有什么方法可以获取第一列索引,因为我不想对其进行硬编码。
我的循环:
$spreadsheet =PhpOfficePhpSpreadsheetIOFactory::load($path);
$worksheet = $spreadsheet->getActiveSheet();
$highestRow = $worksheet->getHighestRow();
$rows = [];
for ($row = 1; $row <= $highestRow; ++$row) {
// I WANT TO REPLACE HARD-CODED VALUES OF 7 AND 8
// WITH $firstCol and $firstCol+1
for ($col = 7; $col <= 8; ++$col) {
$value = $worksheet->getCellByColumnAndRow($col, $row)->getValue();
$rows[$row][$col] = $value;
}
}
您可以添加一个时,循环跳过空单元格。尝试以下操作:
$rows = [];
for ($row = 1; $row <= $highestRow; ++$row) {
$col = 1;
$cell = $worksheet->getCellByColumnAndRow($col, $row);
// Skip empty cells
while (in_array($cell->getValue(), [null, ''], true)) {
$col++;
$cell = $worksheet->getCellByColumnAndRow($col, $row);
}
$maxCol = $col + 1;
for ( ; $col <= $maxCol; ++$col) {
$value = $worksheet->getCellByColumnAndRow($col, $row)->getValue();
$rows[$row][$col] = $value;
}
}