Introduction: Spreadsheet_Excel_Writer is a library written in PHP which helps to read from and write to different types of spreadsheet file formats with the help of given set of classes.
Advantages:
- Easy and effective comparisons.
- Powerful analysis of large amounts of data.
- Splitting out large (or not so large) amounts of information in the form of a spreadsheet, which is easy to manipulate with a fairly ubiquitous spreadsheet program such as Excel (or OpenOffice).
Installation (Composer):
composer require pear/spreadsheet_excel_writer
Usage:
<?php // require_once 'Spreadsheet/Excel/Writer.php'; // Creating a workbook $workbook = new Spreadsheet_Excel_Writer(); // Sending HTTP headers $workbook->send('gfg1.xls'); // Creating a worksheet $worksheet =& $workbook->addWorksheet('1st Worksheet'); // The actual data $worksheet->write(0, 0, 'Website'); $worksheet->write(0, 1, 'Address'); $worksheet->write(1, 0, 'neveropen'); // Let's send the file $workbook->close(); ?> |
Output:
Reference: https://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.intro.php
