Home > Archive > PHP Programming > October 2006 > Can I read an Excel spreadsheet?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Can I read an Excel spreadsheet?
|
|
| Rob Coventry 2006-10-30, 7:04 pm |
| Is it possible to read cells from an Excel spreadsheet, and what is the
code for this?
Many thanks.
Rob.
| |
|
| Rob Coventry wrote:
> Is it possible to read cells from an Excel spreadsheet, and what is
> the code for this?
Simple versions: if you output them as csv offcourse.
Mor complicated: only on Windows, with OLE compatible COM class:
http://www.php.net/manual/en/class.com.php
If you're not on a Windows server, there have been several tries with
reverse-engineering, none of which really satisfy.
--
Rik Wasmus
| |
| Petr Vileta 2006-10-30, 7:04 pm |
| "Rob Coventry" <robcov2@yahoo.com.au> píse v diskusním príspevku
news:1161935866.583033.92370@k70g2000cwa.googlegroups.com...
> Is it possible to read cells from an Excel spreadsheet, and what is the
> code for this?
>
> Many thanks.
>
It is possible in Perl, not in Php. Learn and use Perl instead of PHP ;-)
P.S. Please no flamewar...
--
Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)
| |
| Andy Hassall 2006-10-30, 7:04 pm |
| On Fri, 27 Oct 2006 16:25:49 +0200, "Petr Vileta" <stoupa@practisoft.cz> wrote:
>"Rob Coventry" <robcov2@yahoo.com.au> píse v diskusním príspevku
>news:1161935866.583033.92370@k70g2000cwa.googlegroups.com...
>It is possible in Perl, not in Php. Learn and use Perl instead of PHP ;-)
>
>P.S. Please no flamewar...
No flames, just a link:
http://www.google.co.uk/search?q=php+excel
The Perl solutions may well be more comprehensive, but I've not tried either.
--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
| |
| Geoff Muldoon 2006-10-30, 7:04 pm |
| luiheidsgoeroe@hotmail.com says...
> Rob Coventry wrote:
>
> Mor complicated: only on Windows, with OLE compatible COM class:
> http://www.php.net/manual/en/class.com.php
>
> If you're not on a Windows server, there have been several tries with
> reverse-engineering, none of which really satisfy.
For read (only) as opposed to read/write, I have for some time been using
a class that seems to work perfectly well on Apache/PHP/Linux.
http://sourceforge.net/docman/displ...&group_id=99160
Geoff M
|
|
|
|
|