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:
