phpexcel 导入实例

<?php
require_once 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\IOFactory;

// 加载 Excel 文件
$inputFileName = './excelsample.xlsx';
$spreadsheet = IOFactory::load($inputFileName);

// 获取活动工作表
$worksheet = $spreadsheet->getActiveSheet();

// 读取数据
foreach ($worksheet->getRowIterator() as $row) {
    $cellIterator = $row->getCellIterator();
    $cellIterator->setIterateOnlyExistingCells(false); // 遍历所有单元格，包括空单元格

    foreach ($cellIterator as $cell) {
        echo $cell->getValue() . "\t";
    }
    echo "\n";
}
?>

$spreadsheet = IOFactory::load($inputFileName, 'UTF-8');

$value = $cell->getFormattedValue();

ini_set('memory_limit', '256M');

use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
use PhpOffice\PhpSpreadsheet\Cell\Coordinate;

$reader = new Xlsx();
$reader->setReadDataOnly(true);

$spreadsheet = $reader->load($inputFileName);

foreach ($spreadsheet->getRowIterator() as $row) {
    $cellIterator = $row->getCellIterator();
    $cellIterator->setIterateOnlyExistingCells(false);

    foreach ($cellIterator as $cell) {
        echo $cell->getFormattedValue() . "\t";
    }
    echo "\n";
}