how to export excel file in same server

Posted on 16th Feb 2014 07:03 pm by admin

My first post - php newbie, so appreciate your support.

I'm currently using headers to save web page as excel file.

$filename="sms.xls";
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: public");
header("Content-Description: File Transfer");
header("Content-Type: application/vnd.ms-excel");
$header="Content-Disposition: attachment; filename=".$filename.";";
header($header);
header("Content-Transfer-Encoding: binary");
@readfile($file);

I want to be able to save a copy to the server not to opening dialog save?
Not sure what I need to change or add to achieve this?

Have looked around and tried searching on here? - can't see the search threads feature if there is one?

Many thanks

Your Answer:

Login to answer

Other forums

need help with mail()
hi i want to send an email with attaching pdf file using php. i have the following script but the pr

Create multiple (n) arrays
Hi there,

I have the following need:

I have 2 arrays (coming from a databases)

Code Help.. If txt input box empty search X instead..
I am having a problem with my search script. At current it will simply search by a selected date whi

error with opendir
when i do this

if ($handle = opendir($dir)) {
while (false !== ($file = readdir($han

Replacing a string on click of a button
Hi! Is there a way to replace a string on a click of a text link?

This is what I've come up w

Multiple includes losing variables
Hey all,

just starting out w php and ran into a problem pretty quickly. I'm
including seve

Using system() and bringing back the results
I am aware that you can use system() within PHP to execute system commands, but I was wondering if t

mr8m - reverse document
Friends,

I'm trying to reverse a document held by MIRO, but it reports the message balan

mySQL and PHP search
Hello,
I am trying to code a project and ran into a brick wall with one of my pages. I am pretty

Not Inserting into DB
I can't get my Add new Division form to submit to the database. Anyone see my issue?

Code: &a