PHP | Spreadsheet_Excel_Writer | setHAlign() Function
source link: https://www.geeksforgeeks.org/php-spreadsheet_excel_writer-sethalign-function/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
- Difficulty Level : Easy
- 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:
filter_none
edit
close
play_arrow
link
brightness_4
code
<?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:
filter_none
edit
close
play_arrow
link
brightness_4
code
<?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:
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK