php-excel-reader - UTF-8 问题

使用php-excel-reader库读取UTF-8编码的Excel文件时，可能会遇到一些问题。本文将介绍这个问题，并提供解决方案。首先，让我们来了解一下php-excel-reader是什么。

json
{
    "require": {
        "simplon/excel-reader": "^2.0"
    }
}

shell
composer install

php
require 'vendor/autoload.php';
use Simplon\Excel\ExcelReader;
$excel = new ExcelReader();

php
$excel->load('customers.xlsx');
$data = $excel->parse();

php
echo '';
foreach ($data as $row) {
    echo '';
    echo '';
    echo '';
    echo '';
    echo '';
}
echo '
' . $row['姓名'] . '
' . $row['年龄'] . '
' . $row['地址'] . '
';

php
$excel->load(iconv('UTF-8', 'GBK', 'customers.xlsx'));
$data = $excel->parse();

php
require 'vendor/autoload.php';
use Simplon\Excel\ExcelReader;
$excel = new ExcelReader();
$excel->load(iconv('UTF-8', 'GBK', 'customers.xlsx'));
$data = $excel->parse();
echo '';
foreach ($data as $row) {
    echo '';
    echo '';
    echo '';
    echo '';
    echo '';
}
echo '
' . $row['姓名'] . '
' . $row['年龄'] . '
' . $row['地址'] . '
';