excel under linux/php/apache, can I ?

Anon

hi,
I'm wondering if there is a way for me to create an excel document and fill it with the fields that have been provided to me by the user using a form ? can it be done using dom even if I don't use windows/iis ?

I guess that under NT/IIS that whould be possible but I don't use NT/IIS I want to do this using Apache/PHP/Linux.

If not, then do you think that I could do this:
-create an empty excel document under windows
-copy it on linux
-now from linux/apache/php, every time instead of creating a new one I copy the empty excel doc to a new doc ex: empty.xls to form.xls
-create the sells I need, populate the excel doc and send it via mail ?

am I watching to much star trek ?

Thanks.

Anon

Just use the csv format (text file, fields separated by 😉 it's fully supported by excell, it's supported by (i guess) any software, files may be smaller, it's easy to create under php🙂

Patrick A wrote:

I guess that under NT/IIS that whould be possible but I don't use NT/IIS I want to do this using Apache/PHP/Linux.

am I watching to much star trek ?

Thanks.

nilesh

okay, here is another way to create excel files under unix platform. read the steps.

create a temp file with a random name and the suffix of the file is to be .csv - In this case lets use T123.csv as the file name.
write to the temp file values

nilesh,ny,usa,m
greg,nj,usa,m
patrick,tx,usa,m

(thats was just an example)
close the file (remember to name it *.csv)
ask the user to download the file.

What this has done is simply created a Comma Seperated Values file. Excel will open it without question.

cheers,
Nilesh.

Anon

i think that's exactly what i just said, but well.... nevermind 🙂

Anon

Can't you just put
<?
Header('Content-type: application/vnd.ms-excel');
?>
At the begining of a php file that has tables with all your info and create a link to this page and it will open it automatically in excel. Or you can right click on the link and save the exce worksheet locally.