viest / php-ext-xlswriter

🚀 PHP Extension for creating and reader XLSX files.
https://xlswriter.viest.me
BSD 2-Clause "Simplified" License
2.24k stars 229 forks source link

【bug】问题比较严重,导出时候丢失部分列 #502

Open jobinli opened 8 months ago

jobinli commented 8 months ago

环境: php7.2(docker desktop on windows, win10)

问题:写入数据,最基础的设置headers跟data,大概2.3w行数据,每行46列。在500行左右出现丢失列内容问题,且丢失的列无规律。

示例代码:

$xlsx = (new \Vtiful\Kernel\Excel(['path' => './runtime']))->fileName('test.xlsx', '20231216');
// $rows 是整理好的数据
foeach ($rows as $key => $row) {
    echo ($key+1), ' > ', json_encode($row);
}
$xlsx->header($headers)->data($rows);
$xlsx->output();

打印的输出(部分截取) image

实际表格 image

连续一段出现丢失同一的列,后面又一堆丢失不同的列,没有规律

jobinli commented 8 months ago

php --ri xlswriter xlswriter

xlswriter support => enabled Version => 1.5.2 bundled libxlsxwriter version => 1.1.3 bundled libxlsxio version => 0.2.27

penn0312 commented 6 months ago

有解决吗

viest commented 2 months ago

Can you provide mock data and code to reproduce the problem?