The setVAlign() function is an inbuilt function in Spreadsheet_Excel_Writer which is used to set cell alignment of the spreadsheet. This is an alternative to the setAlign() function.
Syntax:
void Format::setVAlign( $location )
Parameters: This function accepts single parameter $location which is used to set the position, at which text is to be placed as ‘top’, ‘vcenter’, ‘bottom’, ‘vjustify’, ‘vequal_space’.\
Return Value: This function returns TRUE on success and PEAR_ERROR on failure.
Example 1:
PHP
<?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_center =& $workbook ->addFormat();
// Set color for the text $format_center ->setColor ( 'green' );
// Set alignment of text to the center of the cell $format_center ->setVAlign( 'vcenter' );
// 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
<?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_center =& $workbook ->addFormat();
// Set Color for the text $format_center ->setColor ( 'white' );
// Set Alignment of text to the top of the cell $format_center ->setVAlign( 'top' );
// 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: