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

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.



Improved By : shubham_singh