Reading Excelfiles with PHP

[Erwin Moller]

Hi group,

Is it possible to read the content of Excelfiles with PHP?
I mean of course the rows and columns, not the binary-read of the file. :-)

I know a CSV-export is a possebility, but that is unwanted.

TIA!

Regards,
Erwin Moller

[CountScubula]

Re: Reading Excelfiles with PHP

"Erwin Moller"
<since_humans_r ead_this_I_am_s pammed_too_much @spamyourself.c om> wrote in
message news:3ffa83cc$0 $317$e4fe514c@n ews.xs4all.nl.. .[color=blue]
> Hi group,
>
> Is it possible to read the content of Excelfiles with PHP?
> I mean of course the rows and columns, not the binary-read of the file.[/color]
:-)[color=blue]
>
> I know a CSV-export is a possebility, but that is unwanted.
>
> TIA!
>
> Regards,
> Erwin Moller[/color]
reading any type of file is possible, you just need to know the internal
format of said file, just google it, and then parse away :)

--
Mike Bradley
http://www.gzentools.com -- free online php tools

[Dan Tripp]

Re: Reading Excelfiles with PHP

CountScubula wrote:[color=blue]
> "Erwin Moller"
> <since_humans_r ead_this_I_am_s pammed_too_much @spamyourself.c om> wrote in
> message news:3ffa83cc$0 $317$e4fe514c@n ews.xs4all.nl.. .
>[color=green]
>>Hi group,
>>
>>Is it possible to read the content of Excelfiles with PHP?
>>I mean of course the rows and columns, not the binary-read of the file.[/color]
>
> :-)
>[color=green]
>>I know a CSV-export is a possebility, but that is unwanted.
>>
>>TIA!
>>
>>Regards,
>>Erwin Moller[/color]
>
> reading any type of file is possible, you just need to know the internal
> format of said file, just google it, and then parse away :)
>
> --
> Mike Bradley
> http://www.gzentools.com -- free online php tools
>
>[/color]

If you choose to go that route, here's a link to OpenOffice's take on
the .xls file:

http://sc.openoffice.org/excelfileformat.pdf

Regards,

- Dan
dantripp.com

[Erwin Moller]

Re: Reading Excelfiles with PHP

Thanks for your reply's

I was more hoping somebody else made some friendly readingroutine.
I have the feeling I am not the first who wants to read excel-content in
php...

Thanks for the OO link, i'll use that!

Regards,
Erwin Moller

[Nikolai Chuvakhin]

Re: Reading Excelfiles with PHP

Erwin Moller <since_humans_r ead_this_I_am_s pammed_too_much @spamyourself.c om>
wrote in message news:<3ffa83cc$ 0$317$e4fe514c@ news.xs4all.nl> ...[color=blue]
>
> Is it possible to read the content of Excelfiles with PHP?[/color]

There are at least three file formats that different versions
of Excel have used since 1995 on Windows alone; I have no clue
what has been happening with Excel file formats on Macintosh.
This said, there are some PHP scripts that can read Excel files;
you should check out PEAR (http://pear.php.net/) and PHP Classes
(http://phpclasses.org/).

Cheers,
NC