The setHAlign() function is an inbuilt function in PHP | Spreadsheet_Excel_Writer which is used to set cell alignment of the spreadsheet.
Syntax:
void Format::setHAlign( $location )
Parameters: This function accepts single parameter as $location which takes the position, at which text is to be placed as ‘left’, ‘center’, ‘right’, ‘fill’, ‘justify’, ‘merge’, ‘equal_space’.
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 a format to the workbook $format_center =& $workbook->addFormat(); // Set color for the text $format_center->setColor ('green'); // Set alignment of text to the center of the cell $format_center->setHAlign('center'); // Add boldness to the text $format_center->setBold(1); // Set size of the text $format_center->setSize(25); // Add data to the cell $worksheet->write(0, 5, 'GeeksforGeeeks!', $format_center); $worksheet->write(1, 5, 'A Computer Science Portal For Geeks', $format_center); // 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 a Format to the workbook $format_center =& $workbook->addFormat(); // Set Color for the text $format_center->setColor ('white'); // Set Alignment of text to the right of the cell $format_center->setHAlign('right'); // Set background color $format_center->setBgColor('black'); // Set Pattern to the cell $format_center->setPattern(1); // Add Boldness to the text $format_center->setItalic(1); // Set Size of the text $format_center->setSize(20); // Add data to the cell $worksheet->write(7, 5, 'Sarthak Prajapati', $format_center); $worksheet->write(8, 5, 'sarthak_ishu11', $format_center); $worksheet->write(9, 5, 'Chandigarh', $format_center); // Send file to the browser $workbook->send('test.xlsx'); // Free the memory $workbook->close(); ?> |
Output:
