PHP | Spreadsheet
Introduction: PHPSpreadsheet is a library written in PHP which helps to read from and write to different types of spreadsheet file formats with the help of a given set of classes. The various format which support spreadsheet are Excel(.xlsx), Open Document Format(.ods),SpreadsheetML(.xml), CSV and many more.
Advantages:
- Easy and effective comparisons.
- Powerful analysis of large amounts of data.
Usability:
- Agendas
- Budgets
- Calendars
- Cards
- Charts and Diagrams
- Financial Tools (Loan calculators etc.)
- Flyers
- Forms
- Inventories
- Invoices
- Lists and to-do checklists
- Planners
- Plans and proposals
- Reports
- Schedules
- Timesheets
Requirements: The following software is developed using PHPSpreadsheet:
- PHP version 5.6 or newer
- PHP extension php_zip enabled
- PHP extension php_xml enabled
- PHP extension php_gd2 enabled
Installation: The PHPSpreadsheet can be installed with the help of Composer.
On Terminal: The following command runs on the terminal to install PHPSpreadsheet:
composer require phpoffice/phpspreadsheet
Example 1:
PHP
<?php // require_once('vendor/autoload.php'); use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; // Creates New Spreadsheet $spreadsheet = new Spreadsheet(); // Retrieve the current active worksheet $sheet = $spreadsheet ->getActiveSheet(); // Set the value of cell A1 $sheet ->setCellValue( 'A1' , 'w3wiki!' ); // Sets the value of cell B1 $sheet ->setCellValue( 'B1' , 'A Computer Science Portal For Beginner' ); // Write an .xlsx file $writer = new Xlsx( $spreadsheet ); // Save .xlsx file to the current directory $writer ->save( 'gfg.xlsx' ); ?> |
Output:
Example 2:
PHP
<?php // require_once('path/vendor/autoload.php'); // Load an .xlsx file $spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load( 'gfg.xlsx' ); // Store data from the activeSheet to the variable // in the form of Array $data = array (1, $spreadsheet ->getActiveSheet() ->toArray(null,true,true,true)); // Display the sheet content var_dump( $data ); ?> |
Output:
array(2) { [0]=> int(1) [1]=> array(1) { [1]=> array(2) { ["A"]=> string(14) "w3wiki!" ["B"]=> string(35) "A Computer Science Portal For Beginner" } } }
Contact Us