使用phpspreadsheet库将数据从数组写入表 [英] Write data from array to sheet using phpspreadsheet library

问题描述

如何使用 phpspreadsheet 库从数组创建Excel工作表列标题?

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');

推荐答案

您需要编写

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

这篇关于使用phpspreadsheet库将数据从数组写入表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！