-
Notifications
You must be signed in to change notification settings - Fork 663
Open
Description
在 writeSheetHeader 前,执行了writeSheetRow,writeSheetHeader中的widths就会不生效
Before
writeSheetHeader, ifwriteSheetRowis executed,widthsinwriteSheetHeaderwill 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
Metadata
Metadata
Assignees
Labels
No labels