HomeLanguagesPHP | Spreadsheet_Excel_Writer | addWorksheet() Function

PHP | Spreadsheet_Excel_Writer | addWorksheet() Function

The addWorksheet() function is an inbuilt function in PHP | Spreadsheet_Excel_Writer which is used to add a new worksheet to the Excel workbook.

Syntax: 

Workbook::&addWorksheet( $name='' )

Parameters: This function accepts single parameter $string as worksheet name which can’t be greater than 31 characters.

Return Value: This function returns reference to a worksheet object on success and PEAR_ERROR on failure.

Example 1:  

PHP




<?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 Spreadsheet
$worksheet =& $workbook->addWorksheet();
 
$format_bold->setBorder(2);
 
// Write to Worksheet
$worksheet->write(0, 0, "Details of neveropen
                      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




<?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 Spreadsheet
$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 neveropen
                     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.spreadsheet-excel-writer-workbook.addworksheet.php
 

RELATED ARTICLES

Most Popular

Dominic
32726 POSTS0 COMMENTS
Milvus
131 POSTS0 COMMENTS
Nango Kala
7105 POSTS0 COMMENTS
Nicole Veronica
12241 POSTS0 COMMENTS
Nokonwaba Nkukhwana
12329 POSTS0 COMMENTS
Shaida Kate Naidoo
7219 POSTS0 COMMENTS
Ted Musemwa
7477 POSTS0 COMMENTS
Thapelo Manthata
7200 POSTS0 COMMENTS
Umr Jansen
7176 POSTS0 COMMENTS