ExcelMapper：简化 PHP 项目中的 Excel 数据导入

composer require esmaeil/excelmapper

| first name | last name | phone number |

|------------|-----------|--------------|

| john       | doe       | ۱۲۳۴۵۶۷۸۹۰   |

| jane       | smith     | 9876543210   |

namespace excelmapper\parsers;

use excelmapper\interfaces\columnparserinterface;

use excelmapper\utils\datahelper;

class diGitconversionparser implements columnparserinterface

{

    public function parse($value)

    {

        return datahelper::convertdigits($value);

    }

}

use excelmapper\dataprocessor\exceldataprocessor;

use excelmapper\readers\excelreader;

use excelmapper\parsers\defaultparser;

use excelmapper\parsers\digitconversionparser;

// define custom column mapping

$mapping = [

    ['first_name', defaultparser::class],

    ['last_name', defaultparser::class],

    ['phone_number', digitconversionparser::class], // convert digits to english

];

// Read Excel file

$reader = new ExcelReader();

$sheetData = $reader->read('path_to_file.xlsx');

// Process the data

$processor = new ExcelDataProcessor();

$processor->process($sheetData, $mapping, function($mappedData) {

    // Handle the mapped data (e.g., save to database)

    print_r($mappedData);

});