PDA

View Full Version : PHP & Excel


gmorphus
09-07-2002, 05:27 PM
Hi, I have an Excel file which some stores a single table of names and numbers.
I'd like to read it using PHP without having to export it to a text file or into a DB (such as MySQL).

My guess is that I CAN'T, but I have to ask anyway.

Thank you in advance

freakysid
09-08-2002, 03:25 PM
sorry, but the native xls file is going to be full of binary character goobly-gook.

maes
09-08-2002, 06:17 PM
If the Excel file only contains text (or maybe formulas) then you can read it in with php. I think the content of a cel is between " and between cells it uses a tab.
Try saveing this as a .xls file and open it with excel:

"a1" "b1" "c1" "d1"
"a2" "b2" "c2" "d2"
"a3" "b3" "c3" "d3"
"a4" "b4" "c4" "d4"
"a5" "b5" "c5" "d5"
"a6" "b6" "c6" "d6"
"a7" "b7" "c7" "d7"
"a8" "b8" "c8" "d8"
"a9" "b9" "c9" "d9"