PHPExcel导入模板并修改数据

        $objReader = new \PHPExcel_Reader_Excel2007(); //xlsx
        //$objReader = new \PHPExcel_Reader_Excel5();
        $objPHPExcel = $objReader->load('文件路径');
        
        //获取sheet
        $objActSheet = $objPHPExcel->getActiveSheet();
        //$objActSheet = $objPHPExcel->getSheet(1);
        
        //设置模板数据
        $objActSheet->setCellValue ('A2', "test");
        //在原有模板的基础上创建一个新模板
        $objWriter =\PHPExcel_IOFactory::createWriter ($objPHPExcel, 'Excel2007');
        //保存文件
        $objWriter->save("test.xlsx");