Lightweight Excel(xls/xlsx) php library needed

Question

Possible Duplicate:
Alternative for PHP_excel

A friend would like to use a Php Excel library to read/write files on formats xls and xlsx, he knows about the one called "PhpExcel" but apparently is way too big of a library for him.

I would like you to suggest if there is any other phplib you could recommend him.

Update

Please people vote this question up if you think this post is useful even when some have considered it not good enough to give it negative points (very strange since it has a lot of views and seems it has actually helped to some users). Thank you very much.

We know it Zulk, but he is on an urge and wanted to try straight to the point help and it worked =) — CoderRoller, Dec 19 '11 at 22:09
Thanks for the post Gordon, gonna check the alternatives listed there. — CoderRoller, Dec 19 '11 at 22:23
in a side not: the PHPExcel Library is much lighter (in bytes) if you remove PHPExcel/PDF/ , which is safe unless you use the PDF generators — Jonathan DS, Apr 03 '12 at 14:29
Thanks jonathan, lets see how light it gets after removing what you suggest. Have a good day!. — CoderRoller, Apr 22 '12 at 07:27
Just found https://github.com/mk-j/PHP_XLSXWriter it appears to have 90% less memory usage than phpexcel from some of my basic performance tests. — velcrow, Sep 16 '13 at 15:38

score 2 · Accepted Answer · answered Dec 19 '11 at 21:53

2

Reading only: http://sourceforge.net/projects/phpexcelreader/ 21.5kb Create your own very simply: http://www.ibm.com/developerworks/opensource/library/os-phpexcel/

answered Dec 19 '11 at 21:53

Thanks a lot Nur, we gonna check them out and let you know! – CoderRoller Dec 19 '11 at 22:07
Create your own very simply => link is not working – M A K Nov 04 '20 at 06:39

score 2 · Answer 2 · edited May 23 '17 at 12:08

2

You won't find a lightweight library that can both read and write both xls and xlsx files other than PHPExcel. However, if you want a list of the available options for working with Excel files in PHP, you can find it here.

edited May 23 '17 at 12:08

Community

1
1

answered Dec 19 '11 at 22:47

Mark Baker

209,507
32
346
385

already gave that as possible duplicate. still the best list we have on SO ;) – Gordon Dec 19 '11 at 22:55
Sorry Gordon, missed your comment... typical user, wants a __lightweight__ library that does everything :) – Mark Baker Dec 19 '11 at 22:57
He ended up using Mark's library. Heavy in size but highly efficient. – CoderRoller Dec 20 '11 at 19:19

Skrol29 · Answer 3 · 2016-01-30T22:55:33.037

0

OpenTBS can generate XLSX files using the technic of templates.

It can also read any sub XML file in the XLSX.

OpenTBS can do the same with any Ms Office (docx, xlsx, pptx) and OpenOffice documents.

edited Jan 30 '16 at 22:55

answered Dec 19 '11 at 22:25

Skrol29

5,402
1
20
25

Lightweight Excel(xls/xlsx) php library needed

3 Answers3