Exporting Excel: Instead of open/save, directly create and save on location

[nightkarnation]

Hey guys!

I have the following script to create an excel file, the thing is that I dont want to be asked if I want to open or save the file when accessing the php file...I just want the php file directly to save the excel file.

 

Heres the code:

 

$filename = "test.xls";
$contents = "testdata1 \ntestdata2 \ntestdata3 \n";
header('Content-type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename='.$filename);
echo $contents;

 

Is there a way instead of using the header function, use something like: fopen, fwrite, fclose ?

 

Thanks in advance!

Cheers,

[PFMaBiSmAd]

WHERE do you want this file to be saved at?

[nightkarnation]

First of all, thanks for you help,

 

At the same location where the php is located.

 

Any ideas?

Thanks!

[PFMaBiSmAd]

file_put_contents

[nightkarnation]

Awesome! Thanks a lot!

 

Here's the working script:

 

$filename = $selected_address.".xls";
$contents = "testdata1 \ntestdata2 \ntestdata3 \n";
//header('Content-type: application/vnd.ms-excel');
//header('Content-Disposition: attachment; filename='.$filename);
file_put_contents($filename, $contents);
echo $contents;