PHP | Spreadsheet_Excel_Writer | Introduction

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.
  • Spitting 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:

filter_none

edit
close

play_arrow

link
brightness_4
code

<?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, 'GeeksforGeeks');
$worksheet->write(1, 1, 'https://www.geeksforgeeks.org/');
  
// Let's send the file
$workbook->close();
?>

chevron_right


Output:

Reference: https://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.intro.php



My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.