PHP | Spreadsheet_Excel_Writer | addFormat() Function
The addFormat() function is an inbuilt function in PHP | Spreadsheet_Excel_Writer which is used to set the format of a spreadsheet.
Syntax:
Workbook::&addFormat( $properties = array() )
Parameters: This function accepts single parameter $properties which accepts the array value. In order to set various formats, we use their corresponding functions like setBold() for Bold, setBorder() for borders and many other functions.
Example 1:
<?php require_once 'Spreadsheet/Excel/Writer.php' ; // Add Workbook $workbook = new Spreadsheet_Excel_Writer(); // Add Format to spreadsheet $format_bold =& $workbook ->addFormat(); // Set Bold Format $format_bold ->setBold(); // Add Worksheet to Sprerdsheet $worksheet =& $workbook ->addWorksheet(); $format_bold ->setBorder(2); // Write to Worksheet $worksheet ->write(0, 0, "Details of GeeksforGeeks Contributors", $format_bold ); $worksheet ->write(1, 0, "Author" , $format_bold ); $worksheet ->write(1, 1, "User Handle" , $format_bold ); $worksheet ->write(2, 0, "Sarthak" ); $worksheet ->write(2, 1, "sarthak_ishu11" ); // Send .xlsx file to header $workbook ->send( 'test.xls' ); // Close Workbook Object $workbook ->close(); ?> |
Output:
Example 2:
<?php require_once 'Spreadsheet/Excel/Writer.php' ; // Add Workbook $workbook = new Spreadsheet_Excel_Writer(); // Add Format to spreadsheet $format_border =& $workbook ->addFormat(); // Add Worksheet to Sprerdsheet $worksheet =& $workbook ->addWorksheet(); // Set and Add Border Width $format_border ->setBorder(2); // Set and Add Color to Border $format_border ->setBorderColor( 'red' ); // Write to Worksheet $worksheet ->write(0, 0, "Details of GeeksforGeeks Contributors", $format_bold ); $worksheet ->write(1, 0, "Author" , $format_border ); $worksheet ->write(1, 1, "User Handle" , $format_border ); $worksheet ->write(2, 0, "Sarthak" ); $worksheet ->write(2, 1, "sarthak_ishu11" ); // Send .xlsx file to header $workbook ->send( 'test.xls' ); // Close Workbook Object $workbook ->close(); ?> |
Output:
Reference: https://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.intro-format.php
Recommended Posts:
- How to call a function that return another function in JavaScript ?
- How to get the function name from within that function using JavaScript ?
- How to get the function name inside a function in PHP ?
- p5.js | nf() Function
- p5.js | nfp() Function
- p5.js | nfs() Function
- D3.js | d3.min() function
- p5.js | nfc() function
- CSS | rgb() Function
- PHP | Ds\Set contains() Function
- PHP | Ds\Set first() Function
- PHP | Ds\Set last() Function
- D3.js | d3.hcl() Function
- PHP | pi( ) Function
- p5.js | box() Function
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.