I have a small question for the php coders out there ;)
Did anyone managed to export a database tabel or just some data into an excel file witch has multiple sheets and i think some of the cells might have some formulas aswell.
I spend some time googling and i can export the data into a simple html table and excel is smart enough to read it, but i can't make multiple sheets.
An other aproach was using javascript Active X object, now on this side i can use multiple sheets i can insert data on whatever row/column i want, still not sure about the formulas . but as i read on IE has some problems as in ActiveX controls has to be enabled and FF doesn't handle it very well either.
I could use some outside script that will run from a command line. exec() function will do the job in calling the script that will receive the data as an argument or from a file.
If anyone knows any easier way let me know . till then back to google.