PhpSpreadsheet_php获取表单数据

$abs_excel_path = $_SERVER['DOCUMENT_ROOT'] . '/data.xlsx';
$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($abs_excel_path);
$worksheet = $spreadsheet->getActiveSheet();
$highestRow = $worksheet->getHighestRow(); // 总行数1, 2，3
$rows = [];
for ($rowIndex = 2; $rowIndex <= $highestRow; $rowIndex++) { 

$row['code'] = $worksheet->getCell("B{ 
$rowIndex}")->getValue();
$row['name'] = $worksheet->getCell("C{ 
$rowIndex}")->getValue();
$row['unit'] = strval($worksheet->getCell("D{ 
$rowIndex}")->getValue());
$row['price'] = $worksheet->getCell("E{ 
$rowIndex}")->getValue();
$row['quantity'] = $worksheet->getCell("F{ 
$rowIndex}")->getCalculatedValue(); // 获得公式计算值
$row['amount'] = $worksheet->getCell("G{ 
$rowIndex}")->getCalculatedValue(); // 获得公式计算值
$row['date'] = $worksheet->getCell("G{ 
$rowIndex}")->getFormattedValue(); // 获得日期的格式化数值
if (!$row['code'] || $row['code'] == 'NULL') { 

$row['code'] = $row['name'];
}
$rows[] = $row;
}