laravel读取excel数据

1. 安装：box/spout、

• gitHub地址：GitHub - box/spout: Read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way

• 使用文档地址：开始 (box.com)
• conposer安装命令

composer require box/spout

2.控制器内使用

<?php
namespace App\Http\Controllers;

use Box\Spout\Reader\Common\Creator\ReaderEntityFactory;

class ToolsController extends Controller
{
    public function getExcelData()
    {
        $filePath = public_path('excel/CD编码库.xlsx');
        $reader = ReaderEntityFactory::createXLSXReader();

        $reader->open($filePath); // excel文件路径
        $headers = ['cdGalid', 'artist', 'album', 'region', 'style', 'issue_time'];                    
        // excel数据title
        $data = [];               // excel数据

        foreach ($reader->getSheetIterator() as $sheet) {

            foreach ($sheet->getRowIterator() as $row) {
                $cells = $row->getCells();
                $rowData = []; // excel所有数据
                foreach ($cells as $cell) {
                    $rowData[] = $cell->getValue();
                }
                
                 // 获取其余行数据
                 $rowAssoc = [];
                 foreach($headers as $index => $header){
                     $rowAssoc[$header] = $rowData[$index] ?? null;
                 }
                 $data[] = $rowAssoc;
            }
        }
        
        $reader->close();
        array_shift($data);
        return response()->json($data);
    }
}

 3.创建路由

Route::any('/getExcelData', 'ToolsController@getExcelData');

 4.运行效果