php 導入excel數據
composer require phpoffice/phpspreadsheet
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
$reader = new Xlsx();
$spreadsheet = $reader->load($fileName);
$worksheet = $sheet = $spreadsheet->getActiveSheet();
$data = [];
$highestRow = $worksheet->getHighestRow(); // 總行數
//$highestColumn = $worksheet->getHighestColumn(); // 總列數
$data = [];
for ($row = 2; $row <= $highestRow; ++$row) {
$rowData = [];
$rowData[] = $worksheet->getCellByColumnAndRow(1, $row)->getValue();
$rowData[] = $worksheet->getCellByColumnAndRow(2, $row)->getValue();
$rowData[] = $worksheet->getCellByColumnAndRow(3, $row)->getValue();
$rowData[] = $worksheet->getCellByColumnAndRow(4, $row)->getValue();
$rowData[] = $worksheet->getCellByColumnAndRow(5, $row)->getValue();
$data[] = $rowData;
}
var_dump($data);
浙公網安備 33010602011771號