search

mk-j / PHP_XLSXWriter

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

How to set format for multiple row on same column #328

Closed i-am-nikola closed 1 year ago

i-am-nikola commented 2 years ago

Example A1 -> #,##0.00 A2 -> 0

lebedze commented 1 year ago

Is there a solution?

mk-j commented 1 year ago

You should be able to specify multiple calls to writeSheetHeader now on the same sheet (if you use the latest from master). Maybe that will help? $writer->writeSheetHeader("Sheet1", $header1); $writer->writeSheetRow("Sheet1", $data1); $writer->writeSheetHeader("Sheet1", $header2); $writer->writeSheetRow("Sheet1", $data2);