XLSXWriter::markMergedCell PHP Method

markMergedCell() public method

public markMergedCell ( $sheet_name, $start_cell_row, $start_cell_column, $end_cell_row, $end_cell_column )
    public function markMergedCell($sheet_name, $start_cell_row, $start_cell_column, $end_cell_row, $end_cell_column)
    {
        if (empty($sheet_name) || $this->sheets[$sheet_name]->finalized) {
            return;
        }
        self::initializeSheet($sheet_name);
        $sheet =& $this->sheets[$sheet_name];
        $startCell = self::xlsCell($start_cell_row, $start_cell_column);
        $endCell = self::xlsCell($end_cell_row, $end_cell_column);
        $sheet->merge_cells[] = $startCell . ":" . $endCell;
    }

Usage Example

<?php

include_once "xlsxwriter.class.php";
$header = array("string", "string", "string", "string", "string");
$row1 = array("Merge Cells Example");
$row2 = array(100, 200, 300, 400, 500);
$row3 = array(110, 210, 310, 410, 510);
$sheet_name = 'Sheet1';
$writer = new XLSXWriter();
$writer->writeSheetHeader($sheet_name, $header, $suppress_header_row = true);
$writer->writeSheetRow($sheet_name, $row1);
$writer->writeSheetRow($sheet_name, $row2);
$writer->writeSheetRow($sheet_name, $row3);
$writer->markMergedCell($sheet_name, $start_row = 0, $start_col = 0, $end_row = 0, $end_col = 4);
$writer->writeToFile('example.xlsx');