mk-j / PHP_XLSXWriter

Lightweight XLSX Excel Spreadsheet Writer in PHP
MIT License
1.84k stars 663 forks source link

`widths` does not take effect #359

Open anlondon opened 4 months ago

anlondon commented 4 months ago

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

sayid commented 4 months ago

您好,我已经收到您的信件,将尽快回复您。