What are the differences between setAlign('merge') and setMerge() functions in PEAR Spreadsheet_Excel_Writer in PHP?

The setAlign('merge') function in PEAR Spreadsheet_Excel_Writer is used to merge cells in a specific range, while the setMerge() function is used to merge cells in a specific row or column. To merge cells in a specific range, use setAlign('merge'). To merge cells in a specific row or column, use setMerge().

// Using setAlign('merge') to merge cells in a specific range
$worksheet->setAlign('merge', $startRow, $startCol, $endRow, $endCol);

// Using setMerge() to merge cells in a specific row or column
$worksheet->setMerge($startRow, $startCol, $endRow, $endCol);