PHP | Spreadsheet_Excel_Writer | send() Function
The send() function is an inbuilt function in PHP | Spreadsheet_Excel_Writer which is used to send HTTP headers with the correct content-type (application/vnd.ms-excel), cache control and filename for the file.
Syntax:
void Spreadsheet_Excel_Writer::send( $filename )
Parameters: This function accepts single parameter as $filename which takes the name of the file to be send to the headers.
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 a 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 HTTP headers with the content-type (application/vnd.ms-excel)$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 HTTP headers with the content-type (application/vnd.ms-excel)$workbook->send('test.xlsx'); // Free the memory$workbook->close();?> |
Output:
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.


