Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #4044

Re: Upload xlsx /xls and save to DB using minimum memory?

Show all headers | View raw

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

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Upload xlsx /xls and save to DB using minimum memory? Amit Prakash Pawar <amitppawar2007@gmail.com> - 2011-12-09 10:49 -0800
  Re: Upload xlsx /xls and save to DB using minimum memory? Denis McMahon <denismfmcmahon@gmail.com> - 2011-12-10 10:06 +0000
    Re: Upload xlsx /xls and save to DB using minimum memory? The Natural Philosopher <tnp@invalid.invalid> - 2011-12-10 10:31 +0000
      Re: Upload xlsx /xls and save to DB using minimum memory? Amit Prakash Pawar <amitppawar2007@gmail.com> - 2011-12-12 10:09 -0800

csiph-web