PHP | Spreadsheet_Excel_Writer | Introduction

0 0 1 minute read

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