PHPExcel download using ajax call

by

PHP

$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
ob_start();
$objWriter->save("php://output");
$xlsData = ob_get_contents();
ob_end_clean();

$response =  array(
        'op' => 'ok',
        'file' => "data:application/vnd.ms-excel;base64,".base64_encode($xlsData)
    );

die(json_encode($response));

JS

$.ajax({
    type:'POST',
    url:"MY_URL.php",
    data: {},
    dataType:'json'
}).done(function(data){
    var $a = $("<a>");
    $a.attr("href",data.file);
    $("body").append($a);
    $a.attr("download","file.xls");
    $a[0].click();
    $a.remove();
});

More Related Contents:

  1. How to inject javascript code that uses php variables into php page
  2. I want to use jquery nested sortable plugin with drag and drop in codeigniter using mysqli
  3. AJAX request callback using jQuery
  4. using jquery $.ajax to call a PHP function
  5. How do I close a connection early?
  6. Simple jQuery, PHP and JSONP example?
  7. Update data on a page without refreshing
  8. Passing JavaScript array to PHP through jQuery $.ajax
  9. jQuery – Call ajax every 10 seconds
  10. Creating jQuery AJAX requests to a PHP function
  11. PHP/Apache/AJAX – POST limit?
  12. Send multiple checkbox data to PHP via jQuery ajax()
  13. Update fee dynamically based on radio buttons in Woocommerce checkout
  14. jQuery AJAX form using mail() PHP script sends email, but POST data from HTML form is undefined
  15. Redirect with PHP after ajax call
  16. jquery using ajax to send data and save in php [duplicate]
  17. Sending multiple data parameters with jQuery AJAX
  18. jQuery $.ajax request of dataType json will not retrieve data from PHP script
  19. Refresh a table with jQuery/Ajax every 5 seconds
  20. Using AJAX to pass variable to PHP and retrieve those using AJAX again
  21. How to pass an array using PHP & Ajax to Javascript?
  22. How to make a Cascading Drop Down List in PHP using jQuery
  23. Jquery: Running AJAX locally without a webserver
  24. How to populate dependable drop-down using Ajax and php [closed]
  25. How can I pass variables from JavaScript to PHP?
  26. AJAX only access
  27. PHP + Ajax Login
  28. How to show ajax loading gif animation while the page is loading?
  29. Add a quantity field to Ajax add to cart button on WooCommerce shop page
  30. PhP Upload progress in PhP 5.4 is not working. Session variables not set

Leave a Comment