FUDforum: comp.lang.php » Upload xlsx /xls and save to DB using minimum memory?

Home » Imported messages » comp.lang.php » Upload xlsx /xls and save to DB using minimum memory?

Show: Today's Messages :: Polls :: Message Navigator

Re: Upload xlsx /xls and save to DB using minimum memory? [message #176257 is a reply to message #176246]

Mon, 12 December 2011 18:09

Amit Prakash Pawar
Messages: 10
Registered: October 2010

Karma:

Junior Member

Hi,
Can you please guide me to read only
1000 row and 30 column from sheet 1?

On Dec 10, 3:31 pm, The Natural Philosopher <t...@invalid.invalid>
wrote:
> Denis McMahon wrote:
>> On Fri, 09 Dec 2011 10:49:54 -0800, Amit Prakash Pawar wrote:
>
>>> Hi,
>
>>> 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
>>> data.
>
>>> and compatible for xlsx and xls
>
>>> How to solve this .Please guide me.
>
>> My reader.php file is this:
>
>> <?php
>> echo "reader.php\n";
>> ?>
>
>> My oleread.php file is this:
>
>> <?php
>> echo "oleread.php\n";
>> ?>
>
>> 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.
>
> it takes 650MB just to read even a null content Microsoft format,
> obviously. :-)
>
>
>
>
>
>
>
>> Rgds
>
>> Denis McMahon

Report message to a moderator

[Message index]

		Upload xlsx /xls and save to DB using minimum memory? By: Amit Prakash Pawar on Fri, 09 December 2011 18:49
		Re: Upload xlsx /xls and save to DB using minimum memory? By: Denis McMahon on Sat, 10 December 2011 10:06
		Re: Upload xlsx /xls and save to DB using minimum memory? By: The Natural Philosoph on Sat, 10 December 2011 10:31
		Re: Upload xlsx /xls and save to DB using minimum memory? By: Amit Prakash Pawar on Mon, 12 December 2011 18:09

Previous Topic:	Edit a record?
Next Topic:	Blogs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 21:37:13 GMT 2024

Total time taken to generate the page: 0.04640 seconds