Yii 2在使用PHPexcel时将文件保存到特定文件夹

composer require phpoffice/phpexcel

use PHPExcel;
use PHPExcel_IOFactory;

public function actionSaveExcel()
{
    // 创建一个新的Excel对象
    $objPHPExcel = new PHPExcel();

    // 设置Excel属性
    $objPHPExcel->getProperties()->setCreator('Your Name')
                                 ->setLastModifiedBy('Your Name')
                                 ->setTitle('Excel Title')
                                 ->setSubject('Excel Subject')
                                 ->setDescription('Excel Description')
                                 ->setKeywords('excel')
                                 ->setCategory('Excel Category');

    // 在Excel中填充数据
    $objPHPExcel->setActiveSheetIndex(0)
                ->setCellValue('A1', 'Data 1')
                ->setCellValue('B1', 'Data 2')
                ->setCellValue('C1', 'Data 3');

    // 保存Excel文件到特定文件夹
    $savePath = '/path/to/save/folder/';
    $saveFilename = 'excel_file.xlsx';
    $saveFullPath = $savePath . $saveFilename;

    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
    $objWriter->save($saveFullPath);

    // 返回保存的文件路径
    return $saveFullPath;
}