473,398 Members | 2,335 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Reading Excelfiles with PHP

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
Jul 17 '05 #1
4 2410
"Erwin Moller"
<si******************************************@spam yourself.com> wrote in
message news:3f*********************@news.xs4all.nl...
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

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
Jul 17 '05 #2
CountScubula wrote:
"Erwin Moller"
<si******************************************@spam yourself.com> wrote in
message news:3f*********************@news.xs4all.nl...
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


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


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
Jul 17 '05 #3
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

Jul 17 '05 #4
Erwin Moller <si******************************************@spam yourself.com>
wrote in message news:<3f*********************@news.xs4all.nl>...

Is it possible to read the content of Excelfiles with PHP?


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
Jul 17 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Andy | last post by:
Hi, In the code below (not pretty I know but it's an early version :-P) I'm having problems reading the data object back in. If I move the reading code to immediately after the section where it...
6
by: Raymond Hettinger | last post by:
Found in a pamphlet at a pre-school: --------------------------------------- Reading improves vocabulary Reading raises cultural literacy through shared knowledge Reading develops writing skills...
4
by: Xah Lee | last post by:
# -*- coding: utf-8 -*- # Python # to open a file and write to file # do f=open('xfile.txt','w') # this creates a file "object" and name it f. # the second argument of open can be
24
by: Hendrik Schober | last post by:
Hi, I have a 'std::istream' and need to read its whole contents into a string. How can I do this? TIA; Schobi
19
by: Lionel B | last post by:
Greetings, I need to read (unformatted text) from stdin up to EOF into a char buffer; of course I cannot allocate my buffer until I know how much text is available, and I do not know how much...
4
by: Oliver Knoll | last post by:
According to my ANSI book, tmpfile() creates a file with wb+ mode (that is just writing, right?). How would one reopen it for reading? I got the following (which works): FILE *tmpFile =...
6
by: KevinD | last post by:
assumption: I am new to C and old to COBOL I have been reading a lot (self teaching) but something is not sinking in with respect to reading a simple file - one record at a time. Using C, I am...
9
by: Mike Reed | last post by:
I must be having a "senile" day! I cannot recall, nor get to work, code to read a cookie's expiration date/time in an ASP page/VBScript. What am I missing? *** Sent via Developersdex...
4
by: Gaijinco | last post by:
I had a file named nap.in which looks like this: 4 10:00 12:00 Lectures 12:00 13:00 Lunch, like always. 13:00 15:00 Boring lectures... 15:30 17:45 Reading 4 10:00 12:00 Lectures 12:00 13:00...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.