Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Amit Prakash Pawar
December 9, 2011, 6:49 pm
rate this thread
I am trying to upload file and save data to DB.
IN File only 10 row and 5 column data.(normal sample data)
File has only 24.0 KB (24,576 bytes)
I am using..reader.php and oleread.php
to upload file
But It taking More than 650MB memory (681574400 bytes)
Is any other library Or method Which takes less memory to upload more
and compatible for xlsx and xls
How to solve this .Please guide me.
Re: Upload xlsx /xls and save to DB using minimum memory?
My reader.php file is this:
My oleread.php file is this:
You might now understand why your question in it's current form is
somewhat difficult to answer.
If you have an xls file of 10 rows and 5 columns, I suggest you save it
as a csv file, upload the csv file and write php to parse the csv file
into your database.
I don't know of any native php support for microsoft proprietary file
formats, and if you're using proprietary php add-ons, you need to speak
to the suppliers of those add-ons for help with your problem.
- The Natural Philosopher
December 10, 2011, 10:31 am