471,046 Members | 1,286 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,046 software developers and data experts.

Can I read an Excel spreadsheet?

Is it possible to read cells from an Excel spreadsheet, and what is the
code for this?

Many thanks.

Rob.

Oct 27 '06 #1
4 1546
Rik
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
Oct 27 '06 #2
"Rob Coventry" <ro*****@yahoo.com.aupíse v diskusním príspevku
news:11*********************@k70g2000cwa.googlegro ups.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.)
Oct 27 '06 #3
On Fri, 27 Oct 2006 16:25:49 +0200, "Petr Vileta" <st****@practisoft.czwrote:
>"Rob Coventry" <ro*****@yahoo.com.aupíse v diskusním príspevku
news:11*********************@k70g2000cwa.googlegr oups.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...
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 :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Oct 27 '06 #4
lu************@hotmail.com says...
Rob Coventry wrote:
Is it possible to read cells from an Excel spreadsheet, and what is
the code for this?

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/displa...group_id=99160

Geoff M
Oct 29 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by barbara_dave | last post: by
2 posts views Thread by wstsoi | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.