PHP_XLSXWriter icon indicating copy to clipboard operation
PHP_XLSXWriter copied to clipboard

`widths` does not take effect

Open anlondon opened this issue 10 months ago • 1 comments

writeSheetHeader 前,执行了writeSheetRowwriteSheetHeader中的widths就会不生效

Before writeSheetHeader, if writeSheetRow is executed, widths in writeSheetHeader will not take effect.

$writer  = new XLSXWriter();
$widths = [12, 16, 35, 18, 9, 9, 7, 10, 10, 15, 15, 9, 14, 14, 15, 19, 19];
$style_content = ['height'=>14,'valign'=>'center','font-size'=>11,'font'=>'Calibri,宋体'];
$style_header = ['height'=>14,'halign'=>'center','valign'=>'center','font-size'=>11,'font'=>'Calibri,宋体','widths'=>$widths];

$preheader = [
    ['<服务工作单> 记录','','', '', '', '', '', '', '', '', '', '', '', '', '', '', ''],//A1
    ['日期:',$param['startDate'] . ' to ' . $param['endDate'],'', '', '', '', '', '', '', '', '', '', '', '', '', '', ''],//A2 B2
];
$header = ['工作日期'=>'string', '客户编号'=>'string', '客户公司'=>'string', '合约编号'=>'string', '服务类型'=>'string', '服务状态'=>'string', '期数'=>'string', '费用'=>'string', '单次服务费'=>'string', '首次加做项目'=>'string', '首次加做金额'=>'string', '加班'=>'string', '主要技术员'=>'string', '协作技术员'=>'string', '备注'=>'string', '建立时间'=>'string', '更新时间'=>'string'];
foreach ($preheader as $item)
    $writer->writeSheetRow('WorkSheet',$item,$style_content);
$writer->writeSheetHeader('WorkSheet',$header,$style_header);

希望能获得帮助

hope to get help

anlondon avatar Apr 19 '24 09:04 anlondon