thinkphp phpexcel导入

composer require phpoffice/phpexcel

use PHPExcel;
use PHPExcel_IOFactory;

class ExcelController extends Controller
{
    public function import()
    {
        $file = request()->file('excel');
        if (!$file) {
            return json(['code' => 0, 'msg' => '请选择文件']);
        }

        $filePath = $file->getRealPath();
        $objPHPExcel = PHPExcel_IOFactory::load($filePath);
        $sheet = $objPHPExcel->getSheet(0); // 获取第一个工作表
        $highestRow = $sheet->getHighestRow(); // 获取总行数
        $highestColumn = $sheet->getHighestColumn(); // 获取总列数

        $data = [];
        for ($row = 2; $row <= $highestRow; $row++) { // 从第二行开始读取数据
            $rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, null, true, false);
            $data[] = $rowData[0];
        }

        // 处理导入的数据
        foreach ($data as $item) {
            // 这里可以添加将数据插入数据库的逻辑
            print_r($item);
        }

        return json(['code' => 1, 'msg' => '导入成功']);
    }
}