PHP | Spreadsheet_Excel_Writer | setHAlign() Function
Last Updated :
21 Dec, 2018
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
$workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook ->addWorksheet();
$format_center =& $workbook ->addFormat();
$format_center ->setColor ( 'green' );
$format_center ->setHAlign( 'center' );
$format_center ->setBold(1);
$format_center ->setSize(25);
$worksheet ->write(0, 5, 'GeeksforGeeeks!' , $format_center );
$worksheet ->write(1, 5, 'A Computer Science Portal For Geeks' ,
$format_center );
$workbook ->send( 'test.xlsx' );
$workbook ->close();
?>
|
Output:
Example 2:
<?php
$workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook ->addWorksheet();
$format_center =& $workbook ->addFormat();
$format_center ->setColor ( 'white' );
$format_center ->setHAlign( 'right' );
$format_center ->setBgColor( 'black' );
$format_center ->setPattern(1);
$format_center ->setItalic(1);
$format_center ->setSize(20);
$worksheet ->write(7, 5, 'Sarthak Prajapati' , $format_center );
$worksheet ->write(8, 5, 'sarthak_ishu11' , $format_center );
$worksheet ->write(9, 5, 'Chandigarh' , $format_center );
$workbook ->send( 'test.xlsx' );
$workbook ->close();
?>
|
Output:
Reference: https://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-format.sethalign.php
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...