Jump to content

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


nightkarnation

Recommended Posts

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,

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;

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.