How to export a excel file using php script

Question

I am exporting a excel sheet using php script and my code is

<?php
    function excel_file(){     
    header("Content-Disposition: attachment; filename=\"demo.xls\"");
    header("Content-Type: application/vnd.ms-excel;");
    header("Pragma: no-cache");
    header("Expires: 0");
    $out = fopen("php://output", "w");
    foreach ($tabledata as $data)
    {
        fputcsv($out, $data,"\t");
    }
    fclose($out);
      } 
?>

HTML

<input type="button" name="excel_file" onclick="<?php excel_file(); ?>" value="Download File">

Problem is this:

This function excel_file() execute on loading the page not on click.
The excel file which i get, includes the data of whole page not the data of that perticular array "$tabledata"

$tabledata isn't available in the scope of your excel_file() function, and you need to suppress outputting your html markup if you're outputting the CSV — Mark Baker
– Mark Baker, Commented May 27, 2014 at 9:34

Stefan · Accepted Answer · 2014-05-27 10:12:09Z

2

You include in your button the output of the function. You cannot combine a javascript onclick with a php function.

HTML:

<a href="your_url.php?action=xls">Excel</a>

Then in your code

if(isset($_GET['action']) && $_GET['action'] == 'xls')
{
  excel_file();
  exit;
}

In this way you click on the Excel link and send that action to the server. You catch with PHP the $_GET['action'] and call the excel_file() function.

edited May 27, 2014 at 10:12

answered May 27, 2014 at 9:37

Stefan

1,2586 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Stefan Over a year ago

@MarkBaker I don't see the error here or I am really confused on the moment.. Please clarify the error you see.

user3607000 Over a year ago

in my case now its working... i am using <form name="form_name" method="post" action=""><input type="submit" value="Download Excel" name ="submit" /></form> .. as my php code is on same page :)

Mark Baker Over a year ago

@Stefan - there's always days like that :)

Mike Warren Over a year ago

This would bring up the prompt to download? /* that is the reason I am viewing this question */

Mike Warren Over a year ago

Also, is there a way to POST to that URL, instead of using query string?

|

Collectives™ on Stack Overflow

How to export a excel file using php script

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related