【php xlswriter 读取 $_FILES 文件】_php xlswriter读取文件-CSDN博客

本文链接：https://blog.csdn.net/dahei_comeback/article/details/139742021

laravel8使用PHP-Xlswriter 读取 $_FILES

Xlswriter
文档地址：https://xlswriter-docs.viest.me/zh-cn
下载地址 https://pecl.php.net/package/xlswriter

把 php_xlswriter.dll php_xlswriter.pdb 放在 php ext文件夹下
修改php.ini文件加入extension=xlswriter 重启php

因为 xlswriter本身不能读取 $_FILES
只能先用 move_uploaded_file 把上传成功的临时文件挪到指定位置

$uploadFile = $_FILES['excel_file'];
        // 检查是否有错误
        if ($uploadFile['error'] == UPLOAD_ERR_OK) {
            $newLocation = '../public/excel/' . basename($uploadFile['name']);
            $excelName = basename($uploadFile['name']);
            $file_path = substr($newLocation,0,16);
//            var_dump($file_path);exit;
            // 移动文件
            if (move_uploaded_file($uploadFile['tmp_name'], $newLocation)) {

                $config   = ['path' => $file_path];
                $excel    = new \Vtiful\Kernel\Excel($config);

                // 读取测试文件
                $data = $excel->openFile($excelName)
                    ->openSheet()
                    ->getSheetData();

                var_dump($data);die;
                echo "文件上传成功，并已移动到： " . $newLocation;
            } else {
                echo "文件上传失败。";
            }
        } else {
            echo "上传出错，错误码： " . $uploadFile['error'];
        }