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

Sat, 10 December 2011 10:06

Denis McMahon
Messages: 634
Registered: September 2010

Karma:

Senior Member

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.

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 Sep 20 14:51:17 GMT 2024

Total time taken to generate the page: 0.05000 seconds