Re: reading excell and writing to text file..
| From: | Matt Matijevich | Date: | Mon, 22 Dec 2003 18:54:26 +0000 |
| Subject: | Re: reading excell and writing to text file.. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-173173@lists.php.net to get a copy of this message | ||
[snip]
I was wondering a good place I could get started on reading excel
spreadsheets in PHP ive seen a couple of things out there that will
take
data from the web and transform it into a .xls file. I was wondering if
I
could take a XLS file with php and read it, and rip out certain data
from it
:-) but just knowing how to read it to the screen would be enough to
get me
going. Thanks!
[/snip]
you could use the excel com object if you are on windows
http://fi.php.net/manual/en/ref.com.php
I know there is a pear package to write excel files but not sure if
there is one to read them yet.
If you can use perl you can use Spreadsheet::ParseExcel, I have used it
before and it works really well.
http://search.cpan.org/~kwitknr/Spreadsheet-ParseExcel-0.2602/ParseExcel.pm