virgo/excel-aether

excel-aether

dev-main 2026-04-23 02:24 UTC

Requires

• php: >=7.2
• phpoffice/phpspreadsheet: 1.19.0

Apache-2.0

README

简单的excel 生成器 (偷懒用)

安装

composer require virgo/excel-aether

写入

//文件名称
$name = 'demo.xls';
//or
$name = 'demo';

//地址
$dir = './excel';
//or
$dir = './excel/';

//标题
$title = 'demo';

//表头
$header = [
    'name' => '姓名',
    'phone' => '电话',
    'address' => '地址'
];

//数据格式
$list = [       //key=>value 格式可以打乱
    [
        'name' => 'zhang',
        'address' => 'beijing',
        'phone' => '1821',
        'tt' => '333' //与表头字段不同，会自动过滤
    ],
    [
        'name' => 'wen',
        'address' => 'shanghia',
        'phone' => '1822'
    ],
    [
        'name' => 'liu',
        'phone' => '1823'
        'address' => 'chengdu',
    ]
];

//或者

//表头
//-------------------
$header = [
    '姓名', '电话', '地址'
];

//数据格式
$list = [
    ['zhang', '1825', 'beijing'],
    ['wen', '1823', 'shengzhen'],
    ['liu', '1822', 'shanghai'],
    ['xu', '1827', 'nancong'],
    ['qian', '1821', 'dongjing'],
];

//------------------

//样式配置
$config = [
        //竖列 宽度
        'width' => [5, 10, 10],
        //高度
        'height' => '20',
        //表头样式
        'headerStyle' => [
            'alignment' => [
                'horizontal' => Alignment::HORIZONTAL_CENTER, //水平居中
                'vertical' => Alignment::VERTICAL_CENTER, //垂直居中
            ],
            'borders' => [  //黑框
                'outline' => [
                    'borderStyle' => Border::BORDER_THIN,
                    'color' => ['argb' => '000000'],
                ],
                'inside' => [
                    'borderStyle' => Border::BORDER_THIN,
                    'color' => ['argb' => '000000'],
                ],
            ],
            'font' => [
                'bold' => true,
            ]]
        ,
        //非表头高度
        'cellStyle' => [
            'alignment' => [
                'horizontal' => Alignment::HORIZONTAL_CENTER, //水平居中
                'vertical' => Alignment::VERTICAL_CENTER, //垂直居中
            ],
        ],
    ];

    $re = \ExcelAether\ExcelAether::ExcelCreateBySpreadsheet($header, $list, $name, $dir, $title, $config);

    var_dump($re->getDir() . $re->getFileName());

读取

PS：弃用 phpspreadsheet 会造成内存占用过大，等到内存回收，导致程序错误

使用python 将xls xlxs 转成csv 再用PHP 读取

linux 下执行

#python install
apt-get install python3
apt-get install python3-pip
pip install --upgrade pip


pip3 install -r ./requirements.txt -i  https://pypi.mirrors.ustc.edu.cn/simple

#添加到 /etc/profile
#export PATH=$PATH:/var/www/swoft/vendor/virgo/excel-aether/src/ExcelAether/Reader
#权限
chmod 0755 /var/www/swoft/vendor/virgo/excel-aether/src/ExcelAether/Reader/ExcelReader
chmod 0755 /var/www/swoft/vendor/virgo/excel-aether/src/ExcelAether/CsvToExcel/CsvToExcel
#执行
#source /etc/profile

#软连接
ln -s /var/www/swoft/vendor/virgo/excel-aether/src/ExcelAether/Reader/ExcelReader /usr/bin/
ln -s /var/www/swoft/vendor/virgo/excel-aether/src/ExcelAether/CsvToExcel/CsvToExcel /usr/bin/

读取demo

$inputFile = './excel/t1(3).xlsx';
$reader = new ExcelReader();
$reader->load($inputFile);

$reader->count(); //获取大致条数，csv有换行存在

foreach ($reader->read() as $v) {
    var_dump($v[0]);
}

csv to excel

$inputFile = 'D:\work\ExcelAether\excel\t1.csv';
$outfile  = 'D:\work\ExcelAether\excel\t1.xlsx';

$csv2Excel = new \ExcelAether\CsvToExcel\CsvToExcel();

$csv2Excel->csv2Excel($inputFile,$outfile);

更新

1 自动读取csv 为utf8编码

2 linux 需要权限