在symfony 4中使用PhpOffice\PhpSpreadsheet从excel文件中读取数据

composer require phpoffice/phpspreadsheet

use PhpOffice\PhpSpreadsheet\IOFactory;

class ExcelReader
{
    public function readDataFromExcel($filePath)
    {
        $spreadsheet = IOFactory::load($filePath);
        $worksheet = $spreadsheet->getActiveSheet();
        
        $data = [];
        foreach ($worksheet->getRowIterator() as $row) {
            $rowData = [];
            foreach ($row->getCellIterator() as $cell) {
                $rowData[] = $cell->getValue();
            }
            $data[] = $rowData;
        }
        
        return $data;
    }
}

use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\Routing\Annotation\Route;

class ExcelController
{
    /**
     * @Route("/read-excel", methods={"POST"})
     */
    public function readExcelAction(Request $request, ExcelReader $excelReader)
    {
        $filePath = $request->files->get('excel_file')->getPathname();
        $data = $excelReader->readDataFromExcel($filePath);
        
        // 处理数据，例如将数据存储到数据库中或者进行其他操作
        
        return new Response('Excel data has been read successfully.');
    }
}