phpexcel读取数据

require_once 'PHPExcel/IOFactory.php';

$inputFileName = 'example.xlsx';
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);

// 设置默认编码为 UTF-8
$objPHPExcel->setActiveSheetIndex(0)->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->setActiveSheetIndex(0)->getDefaultStyle()->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_TOP);

foreach ($objPHPExcel->getActiveSheet()->getRowIterator() as $row) {
    $cellIterator = $row->getCellIterator();
    $cellIterator->setIterateOnlyExistingCells(false); // 遍历所有单元格，包括空单元格
    foreach ($cellIterator as $cell) {
        echo $cell->getValue() . "\t";
    }
    echo "\n";
}

require_once 'PHPExcel/IOFactory.php';

$inputFileName = 'large_example.xlsx';
$objPHPExcelReader = PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcelReader->setReadDataOnly(true);

// 启用缓存
$objPHPExcelReader->setCacheStorageMethod(PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip);

$objPHPExcel = $objPHPExcelReader->load($inputFileName);

foreach ($objPHPExcel->getActiveSheet()->getRowIterator() as $row) {
    $cellIterator = $row->getCellIterator();
    $cellIterator->setIterateOnlyExistingCells(false);
    foreach ($cellIterator as $cell) {
        echo $cell->getValue() . "\t";
    }
    echo "\n";
}