HomeLanguagesPHP | Spreadsheet_Excel_Writer | Introduction

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:




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


Output:

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

RELATED ARTICLES

Most Popular

Dominic
32688 POSTS0 COMMENTS
Milvus
131 POSTS0 COMMENTS
Nango Kala
7057 POSTS0 COMMENTS
Nicole Veronica
12198 POSTS0 COMMENTS
Nokonwaba Nkukhwana
12293 POSTS0 COMMENTS
Shaida Kate Naidoo
7182 POSTS0 COMMENTS
Ted Musemwa
7447 POSTS0 COMMENTS
Thapelo Manthata
7160 POSTS0 COMMENTS
Umr Jansen
7150 POSTS0 COMMENTS