try {
$inputFileType = PHPExcel_IOFactory::identify($filePath);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($filePath);
} catch(Exception $e) {
}
// 确定要读取的sheet
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();
$excelData = [];
// 获取excel文件的数据,$row=2代表从第二行开始获取数据
for ($row = 1; $row <= $highestRow; $row++){
$data = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);
$excelData[] = $data[0];
}
读取excel文件
最新推荐文章于 2024-06-26 20:30:00 发布