gf2007/excel

1.0.2 2019-07-10 05:59 UTC

Requires

• phpoffice/phpspreadsheet: ^1.8

MIT

• gf2007

README

简单的将php数组导出为excel

Normal Excel Exporter & Importer By PHP Array

✨ Features

• Easily export array to Excel 极简的将数组转化为Excel
• Easily add header or not add header 可选择添加行标题或者不添加
• the excel staight put to browser excel文件直接输出到浏览器

Exporter 导出

<?php

use gerfin\excel\Exporter;

$exporter = new Exporter();
/**
 * @param array $data 源数据 required
 * @param array $header 行标题 optional
 * @param string $excelName excel名称 optional
 * @param string $format 格式xls或xlsx optional
 * @param string $sheetName sheet名称 optional
 * @throws \PhpOffice\PhpSpreadsheet\Exception
 */
$exporter->export([["1","jack"],["2", "nancy"]], ["id", "name"], "excelName", "xls", "sheetName");