本文介绍了使用phpspreadsheet库将数据从数组写入表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何使用 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库将数据从数组写入表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!