Posted by Arjun on Tuesday 29th March 2016

How to generate excel from array using PHPExcel

How to PHPExcel Array generate excel

This tutorial will describe usage of PHPExcel library to generate an Excel file from PHP array. Usage of PHPExcel library is very simple and easy. Just follow the below steps.

1. First thing first - Download PHPExcel from - http://phpexcel.codeplex.com/

2. After downloading files Unzip the PHPExcel.zip files and we only need files and directories under Class directory. So just copy past the file from class folder to your project folder. Below image show that my folder structure.

3. Now include the PHPExcel.php file and create an object, just follow the comments.

How to generate excel from array using PHPExcel
<?php

require_once('third_party/PHPExcel.php');

$dataArray = array(
    array(
        'PHP7',
        'Java Script',
        'Java',
        'Node JS',
    )
);

// create php excel object
$doc = new PHPExcel();

// set active sheet 
$doc->setActiveSheetIndex(0);

// read data to active sheet
$doc->getActiveSheet()->fromArray($dataArray);

//save our workbook as this file name
$filename = 'just_some_random_name.xls';
//mime type
header('Content-Type: application/vnd.ms-excel');
//tell browser what's the file name
header('Content-Disposition: attachment;filename="' . $filename . '"');

header('Cache-Control: max-age=0'); //no cache
//save it to Excel5 format (excel 2003 .XLS file), change this to 'Excel2007' (and adjust the filename extension, also the header mime type)
//if you want to save it as .XLSX Excel 2007 format

$objWriter = PHPExcel_IOFactory::createWriter($doc, 'Excel5');

//force user to download the Excel file without writing it to server's HD
$objWriter->save('php://output');
?>