Problems exporting to XLS with PHP + Jquery

Question

I'm trying to export some tables generated with PHP from MySQL data. I'm trying to send the info via AJAX to a file with this code:

<?php
header("Content-type: application/vnd.ms-excel; name='excel'");  
header("Content-Disposition: filename=excel.xls");  
header("Pragma: no-cache");  
header("Expires: 0");  
echo $_POST['table'];
?>

The data comes from this function

function export_excel (id_table) {
    var table =  $("#" + id_table).html();
    $.ajax({
            type: 'POST',
            url: 'toexcel.php',
            data: 'table='+table
        });
}

Through Firebug I can see that the table is echoed correctly but it doesn't start any download. Which could be the problem?

Pekka · Accepted Answer · 2011-04-15 11:12:36Z

2

It is not possible to start a file download as a response to an Ajax request. You have to send the browser to fetch the resource like if you were navigating to a page.

If you need to use the POST method, I think the ideal way to do this would be:

Have a real <form> element into which you write the POST data
Have an invisible or small iframe. Give it a name
Give the form the iframe name as the target property
submit() the form

if all headers are set correctly (You may have to add some more, like Content-disposition: attachment), this should trigger a file download without affecting your current page.

If you can use GET, a simple

location.href="toexcel.php?param1=value1&param2=value2"

should do already.

edited Apr 15, 2011 at 11:12

answered Apr 15, 2011 at 11:06

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

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

Collectives™ on Stack Overflow

Problems exporting to XLS with PHP + Jquery

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related