PHP_XLSXWriter
PHP_XLSXWriter copied to clipboard
`widths` does not take effect
在 writeSheetHeader
前,执行了writeSheetRow
,writeSheetHeader
中的widths
就会不生效
Before
writeSheetHeader
, ifwriteSheetRow
is executed,widths
inwriteSheetHeader
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