Description
my code
foreach ($goodsLists as $goods) { $energy_in=SupervisionEnergyConsumptionModel::query() ->select('energy_name as goods_energy_in_name','unit as goods_unit','quantity_of_goods as goods_quantity_of_goods', 'coefficient_folding as goods_coefficient_folding','discount_coal_quantity as goods_discount_coal_quantity') ->where([['supervision_id','=',$supervision_id], ['type','=',1], ['type_name','=',$goods['type_name']], ['energy_name','!=','能源输入总量'], ['index_name','=','能源输入']]) ->get()->toArray(); $templateprocessor->cloneRowAndSetValues('goods_energy_in_name', $energy_in); $energy_out=SupervisionEnergyConsumptionModel::query() ->select('energy_name as goods_energy_in_name','unit as goods_unit','quantity_of_goods as goods_quantity_of_goods', 'coefficient_folding as goods_coefficient_folding','discount_coal_quantity as goods_discount_coal_quantity') ->where([['supervision_id','=',$supervision_id], ['type','=',1], ['type_name','=',$goods['type_name']], ['energy_name','!=','能源输入总量'], ['index_name','=','能源输出']]) ->get()->toArray(); $templateprocessor->cloneRowAndSetValues('goods_energy_out_name', $energy_out); $goods_energy_consumption= SupervisionEnergyConsumptionModel::query() ->where(['supervision_id'=>$supervision_id,'type'=>1,'type_name'=>$goods['type_name'],'energy_name'=>'综合能源消费量']) ->value('discount_coal_quantity'); $goods_energy_unit= SupervisionEnergyConsumptionModel::query() ->where(['supervision_id'=>$supervision_id,'type'=>1,'type_name'=>$goods['type_name'],'energy_name'=>'单位产品综合能耗']) ->value('discount_coal_quantity'); $goods_energy_out_quantity= SupervisionEnergyConsumptionModel::query() ->where(['supervision_id'=>$supervision_id,'type'=>1,'type_name'=>$goods['type_name'],'energy_name'=>'能源输入总量']) ->value('discount_coal_quantity'); $goods_energy_in_quantity= SupervisionEnergyConsumptionModel::query() ->where(['supervision_id'=>$supervision_id,'type'=>1,'type_name'=>$goods['type_name'],'energy_name'=>'能源输出总量']) ->value('discount_coal_quantity'); $templateprocessor->cloneRowAndSetValues('goods_name',[[ 'goods_name'=>$goods['type_name'], 'goods_energy_consumption'=>$goods_energy_consumption, 'goods_energy_unit'=>$goods_energy_unit, 'goods_energy_out_quantity'=>$goods_energy_out_quantity, 'goods_energy_in_quantity'=>$goods_energy_in_quantity]]); } errors
PhpOffice\PhpSpreadsheet\Reader\Exception: 预文档失败:Can not clone row, template variable not found or variable contains markup.
How can I modify the code？？