nightkarnation Posted October 13, 2010 Share Posted October 13, 2010 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, Link to comment https://forums.phpfreaks.com/topic/215809-exporting-excel-instead-of-opensave-directly-create-and-save-on-location/ Share on other sites More sharing options...
PFMaBiSmAd Posted October 13, 2010 Share Posted October 13, 2010 WHERE do you want this file to be saved at? Link to comment https://forums.phpfreaks.com/topic/215809-exporting-excel-instead-of-opensave-directly-create-and-save-on-location/#findComment-1121905 Share on other sites More sharing options...
nightkarnation Posted October 13, 2010 Author Share Posted October 13, 2010 First of all, thanks for you help, At the same location where the php is located. Any ideas? Thanks! Link to comment https://forums.phpfreaks.com/topic/215809-exporting-excel-instead-of-opensave-directly-create-and-save-on-location/#findComment-1121908 Share on other sites More sharing options...
PFMaBiSmAd Posted October 13, 2010 Share Posted October 13, 2010 file_put_contents Link to comment https://forums.phpfreaks.com/topic/215809-exporting-excel-instead-of-opensave-directly-create-and-save-on-location/#findComment-1121910 Share on other sites More sharing options...
nightkarnation Posted October 13, 2010 Author Share Posted October 13, 2010 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; Link to comment https://forums.phpfreaks.com/topic/215809-exporting-excel-instead-of-opensave-directly-create-and-save-on-location/#findComment-1121911 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.