mk-j / PHP_XLSXWriter

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

Add border to merged cells? #296

Closed g-pane closed 1 year ago

g-pane commented 3 years ago

Hi, An example to how to add border to a merged cells? Is possible? ` $writer = new XLSXWriter(); //new writer $sheet_name = 'sheets'; //sheetname $header = array("string","string","string","string","string","string"); // header-made for six columns $row1 = array("A"," ","B"," ","C"); //column B1, D1 made blank to match formatting $styles1 = array( 'font'=>'Arial','font-size'=>10,'font-style'=>'bold', 'fill'=>'#eee', 'halign'=>'center', 'border'=>'left,right,top,bottom', 'border-style'=>'medium'); $writer->writeSheetHeader($sheet_name, $header, $suppress_header_row = true); //write header $writer->markMergedCell($sheet_name, $start_row = 0, $start_col = 0, $end_row = 1, $end_col = 1); //merge cells for A $writer->markMergedCell($sheet_name, $start_row = 0, $start_col = 2, $end_row = 0, $end_col = 3); //merge cells for B $writer->markMergedCell($sheet_name, $start_row = 0, $start_col = 4, $end_row = 0, $end_col = 5); //merge cells for C $writer->writeSheetRow($sheet_name, $row1, $styles1); //write data

$writer->writeToFile('test.xlsx'); `

Some part is missing... Thanks