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 #176246 is a reply to message #176245]

Sat, 10 December 2011 10:31

The Natural Philosoph
Messages: 993
Registered: September 2010

Karma:

Senior Member

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: Tue Nov 26 02:08:57 GMT 2024

Total time taken to generate the page: 0.27568 seconds