Opening a ecxel file with php...

[sWo0p]

hi im curently working onsite on a site that has to have a restpost area.. the source file is made with excel... i cant do anything to that file.. but is there any way to enter the file in php en retreef the information i need...

[λ]

Excel is a proprietrary POS format, which means it'll cause you a whole load of pain to parse. If you export it as CSV it would be very easy to parse though.

[sWo0p]

Excel is a proprietrary POS format, which means it'll cause you a whole load of pain to parse. If you export it as CSV it would be very easy to parse though.

so this is not realy a good idea to use excel files..? any idea what can be a gooed programe to use or is there a way in excel to save the files.. in some orther format maybe..?

[CyanBlue]

njs12345 just answered your question... :)
You can save CSV(Comma Separated Values) from the Excel and manipulate it and save it back to CSV which you can read from Excel...

[ol4pr0]

This will do it, Enjoy (http://www.badblue.com/helpphpo.htm)

[CyanBlue]

Ah... That sounds like a sweet library, ol4pr0... Only if I know PHP well enough to use it... Time to study more... :D