How to specify the filename in ajax while exporting in excel format

Question

In this code I want to specify the filename when downloading the excel format.

if(comp_id != "Select Company")
{
  $.ajax({
    url: 'includes/export.php',
    data: {
      action: 'compreport', 
      'comp':comp_id,   
    },
    type: 'post',
    success: function (output) {
      $("#ereportview").html(output);
      window.open('data:application/vnd.ms-excel,' + encodeURIComponent( $('div[id$=ereportview]').html()));
      e.preventDefault();
    },
    async: false
  });  
}

try this: http://stackoverflow.com/a/25866873 if you can download without ajax as well. — Neha Choudhary, Mar 30 '16 at 05:45
I know there is HTTP header Content-Disposition to specify download file name. But this is HTTP Response header. I don't know how to set header in data url schema. One possible solution, you could add meta data in your 'div[id$=ereportview]'. Just add . I have try this solution. — Ricky Jiao, Mar 30 '16 at 05:56

score 1 · Accepted Answer · edited May 23 '17 at 12:07

1

use this download function in your success callback

function download(filename, text, mime) {
  var element = document.createElement('a');
  element.setAttribute('href', 'data:'+mime+',' + encodeURIComponent(text));
  element.setAttribute('download', filename);

  element.style.display = 'none';
  document.body.appendChild(element);

  element.click();

  document.body.removeChild(element);
}

you can use it like this:

if(comp_id != "Select Company") {
  $.ajax({
    url: 'includes/export.php',
    data: {
      action: 'compreport', 
      'comp':comp_id,   
    },
    type: 'post',
    success: function (output) {
      download("yourfile.xlsx", output, 'application/vnd.ms-excel');
    },
    async: false
  });  
}

you can specify MIME for the type of content you're downloading. You can get that from SitePoint

edited May 23 '17 at 12:07

Community

1
1

answered Mar 30 '16 at 05:47

NaN

485
3
12

i want to download in pdf format means how to edit this code – Kalaivani M Mar 30 '16 at 06:15
i need the output in pdf format your code is for excel file – Kalaivani M Mar 30 '16 at 09:59
2

@KalaivaniM The question is "How to specify the filename in ajax while exporting in **excel format**". If you have a new question, please ask as a new question. – freedomn-m Mar 30 '16 at 10:00

How to specify the filename in ajax while exporting in excel format

1 Answers1