PHPExcel 阅读器——需要帮助

使用PHPExcel阅读器解析Excel文件的PHP指南

json
{
    "require": {
        "phpoffice/phpexcel": "^1.8"
    }
}

bash
composer install

php
require 'vendor/autoload.php';
use PhpOffice%%PhpSpreadsheet%%IOFactory;
$excelReader = IOFactory::createReader('Xlsx'); // 使用Xlsx格式的阅读器
$spreadsheet = $excelReader->load('path/to/your/excel/file.xlsx');
$sheet = $spreadsheet->getActiveSheet();

php
foreach ($sheet->getRowIterator() as $row) {
    foreach ($row->getCellIterator() as $cell) {
        $value = $cell->getValue();
        echo $value . "%%t";
    }
    echo PHP_EOL;
}

php
$targetKeyword = "PHP";
foreach ($sheet->getRowIterator() as $row) {
    foreach ($row->getCellIterator() as $cell) {
        $value = $cell->getValue();
        if (stripos($value, $targetKeyword) !== false) {
            echo $value . "%%t";
        }
    }
    echo PHP_EOL;
}