Situatie
The addWorksheet() function is an inbuilt function in PHP | Spreadsheet_Excel_Writer which is used to add a new worksheet to the Excel workbook.
Solutie
<?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, "Ceva Contributors", $format_bold); $worksheet->write(1, 0, "Altceva", $format_bold); $worksheet->write(1, 1, "Inca ceva", $format_bold); $worksheet->write(2, 0, "Altceva 2"); $worksheet->write(2, 1, "Inca ceva 2"); // Send .xlsx file to header $workbook->send('test.xls'); // Close Workbook Object $workbook->close(); ?>
Leave A Comment?