php-ext-xlswriter icon indicating copy to clipboard operation
php-ext-xlswriter copied to clipboard

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

Open jobinli opened this issue 1 year ago • 3 comments

环境: 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 avatar Dec 18 '23 04:12 jobinli

php --ri xlswriter xlswriter

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

jobinli avatar Dec 18 '23 04:12 jobinli

有解决吗

penn0312 avatar Feb 01 '24 07:02 penn0312

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

viest avatar Jun 04 '24 15:06 viest