Write data from array to sheet using phpspreadsheet library

php excel phpspreadsheet
Gurpreet Kaur picture Gurpreet Kaur · Feb 8, 2018 · Viewed 22.3k times · Source

How can I create excel sheet column headers from array using phpspreadsheet library?

Below is the code I am trying but it's not working:

    // $header is an array containing column headers
    $header = array("Customer Number", "Customer Name", "Address", "City", "State", "Zip");
    $spreadsheet = new Spreadsheet();
    $sheet = $spreadsheet->getActiveSheet();
    $sheet->fromArray($header, NULL, 'A1');     

    // redirect output to client browser
    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment;filename="myfile.xlsx"');
    header('Cache-Control: max-age=0');

    $writer = new Xlsx($spreadsheet);
    $writer->save('php://output');

Answer

Denis picture Denis · Apr 28, 2018

You need to write

$sheet->fromArray([$header], NULL, 'A1');

Related questions

Composer require phpoffice/phpspreadsheet doesn't work

I want to write a Script using the package Phpspreadsheet. I am not experience in php. I am trying to add the reference to my script through sudo composer require phpoffice/phpspreadsheet. But it doesn't work. I am getting the …

Read More
PHPSpreadsheet: how to get the number of loaded rows?

How do I find out how many rows I have loaded using PHPSpreadsheet\Reader\Xlsx::load() method? I cannot find methods (or properties) for getting row count in Spreadsheet or Worksheet classes either. BTW I am using following code: $filename = …

Read More
Building very large spreadsheet with PHPSpreadsheet

I'm testing out how PHPSpreadsheet works with large excel spreadsheets. Initial tests indicate that for a large spreadsheet one will quickly run out of memory. Is there a way to write the spreadsheet progressively? I have an old piece of …

Read More