my clients are not very clever, and they tell me that we press button save and any other formats we do not want to know

my clients give me only xls(excel) file , and now i want to now it is possible on server side with the help of php convert xls to csv and after this all do with function fgetcsv()

thanks

    I was/am faced with a similar problem. It's possible using the COM functions within PHP, but only if you're running on a windows server I believe. I'm having to save any xls files as CSV first.

      you don't need to use COM. (although it would be easiest to just resave it as csv..)

      the article posted above is a pretty good intro to COM

      look on sourceforge.com for some php excel code.

        Hmm, that excel conversion in linux without COM is definitely nice 🙂. A pity the project I need it for is a uni thing and we don't have 200 bucks to play with 😉. I'd be interested to know how they did it though, in terms of writing my own excel -> data under linux.

          Write a Reply...