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