Load file xlsx is very slow

[nguyenthao1988]

`<?php

require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\IOFactory; $filename = 'data/danhsach.xlsx'; //$filename = 'data/nhanvien.xlsx'; $spreadsheet = IOFactory::load($filename);`

I use this code load file "danhsach.xlsx" with 16k record, file size excel: 7MB. +> this code load finish taken time: 32s

how to optimize this, i load full column and row, not limit.

I used: PHP: 8.2.4 PhpSpreadsheet: 2.0

Thanks bro,

[tvillafane]

I have an XLSX that is 1.4MB and my code just hangs when I use the same method, doesn't even finish.

[nguyenthao1988]

@tvillafane please use https://github.com/aVadim483/fast-excel-reader is better faster

[henno]

Same problem.

[nineday90]

相同问题，2.2mb的文件，执行IOFactory::load()竟然需要四五十秒，有优化的方案吗？