The setAlign() function is an inbuilt function in PHP | Spreadsheet_Excel_Writer which is used to set cell alignment of the spreadsheet.
Syntax:
void Format::setAlign( $location )
Parameters: This function accepts single parameter $location which takes the position, as Horizontal Alignments (left, center, right, fill, justify, merge, equal_space) and Vertical Alignments (top, vcenter, bottom, vjustify, vequal_space). To implement a combination of Horizontal and Vertical Alignments, call this method two times.
Return Value: This function returns TRUE on success and PEAR_ERROR on failure.
Example 1:
<?php   // require_once 'Spreadsheet/Excel/Writer.php';   // Add object of class Spreadsheet_Excel_Writer $workbook = new Spreadsheet_Excel_Writer(); $worksheet =& $workbook->addWorksheet();   // Add format to the workbook $format_align =& $workbook->addFormat();   // Set color for the text $format_align->setColor ('green');   // Set alignment of text to the center of the cell $format_align->setAlign('center');   // Set alignment of text to the center // from the top of the cell $format_align->setAlign('vcenter');   // Add boldness to the text $format_align->setBold(1);   // Set size of the text $format_align->setSize(25);   // Add data to the cell $worksheet->write(0, 5, 'GeeksforGeeeks!', $format_align); $worksheet->write(1, 5, 'A Computer Science Portal For Geeks',                   $format_align);   // Send file to the browser $workbook->send('test.xlsx');   // Free the memory $workbook->close(); ?> |
Output:
Example 2:
<?php   // require_once 'Spreadsheet/Excel/Writer.php';   // Add object of class Spreadsheet_Excel_Writer $workbook = new Spreadsheet_Excel_Writer(); $worksheet =& $workbook->addWorksheet();   // Add Format to the workbook $format_align =& $workbook->addFormat();   // Set Color for the text $format_align->setColor ('white');   // Set Alignment of text to the top of the cell $format_align->setAlign('top');   // Set Alignment of text to the right of the cell $format_align->setAlign('right');   // Set background color $format_align->setBgColor('black');   // Set Pattern to the cell $format_align->setPattern(1);   // Add Boldness to the text $format_center->setItalic(1);   // Set Size of the text $format_align->setSize(20);   // Add data to the cell $worksheet->write(7, 5, 'Sarthak Prajapati', $format_align); $worksheet->write(8, 5, 'sarthak_ishu11', $format_align); $worksheet->write(9, 5, 'Chandigarh', $format_align);   // Send file to the browser $workbook->send('test.xlsx');   // Free the memory $workbook->close(); ?> |
Output:
