Export from PHP to Excel/Google Spreadsheets?

Question

PHP

Is it possible to export from a form submitted on the site to an existing Excel or Google Spreadsheet file (template)? I saw several ways to create a file on the fly, but the situation is that the file is too complicated to create with php.
Or maybe there are other programs / services for creating spreadsheets, in addition to the above, to which it will be easier to export? I have never dealt with office software before.

Answer 1

I'll ask quite, probably, the expected question
What is hidden under the phrase "the file is too complex to be created using php"?

Answer 2

php excel? phpexcel.codeplex.com/

Answer 3

If by Excel we mean the csv format, then this is not difficult + a bunch of examples on the net.

Answer 4

In one rather special case, I used the PHP + CLI + Excel combination for just such a job. Of course, this requires MS Office to be installed on the server, but in principle it is possible and works.

Answer 5

Once upon a time there was a BiffWriter class that could generate fairly simple excel files.
But he was paid, did not know how to merge cells and paint over them, and there were also problems with Russian encoding in OpenOffice.
I don’t know how things are with him now, but perhaps he will help you with something.

Answer 6

this is what Google gave out on request “excel com interface php”
I think there are other solutions somewhere on the Internet.