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

Popular posts from this blog

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -

Nuget pack csproj using nuspec -