phpexcel - Speed of PHP Excel -
i hope mark baker can me: seems redundant have simplest need of php excel , isn't working. need read in .xlsx , .xls files submitted user (internal admin site). library incredibly slow unusable right now. can read massive .csv files in no time (with own code) 20 row x 30 column excel file taking on 30 seconds , close minute read. i've tried using examples , in reading on many stack overflow questions, many people have same issue. isn't "loader" issue i'm not using loader.
i have 3 lines of code in particular:
$inputfiletype = phpexcel_iofactory::identify($inputfilename); $objreader = phpexcel_iofactory::createreader($inputfiletype); $objphpexcel = $objreader->load($inputfilename);
it 3rd line of code slow every time.
is there i'm missing? missing? there reason slow?
any appreciated.
thanks! -scott
if users can upload files of size, after optimizing current code (and others suggested bunch of things), you'll potentially end same problems have now.
you need read 600 cells if user uploads file that's way bigger this? 600,000 cells? happened me...
if that's want consider, i'd recommend take @ spout: https://github.com/box/spout. no need worry performance, memory or file size anymore :)
Comments
Post a Comment