Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Code is working fine in Chrome, unable to download excel in Firefox and IE

pooja chourasia
Contributor
December 13, 2017

 

Below code is working fine in Chrome, unable to download excel in Firefox and IE:

<script language="text/javascript">

AJS.$(document).ready(function() {
console.log("Hello I am abc");
exportToExcel();
});
function exportToExcel(){

var uri = 'data&colon;application/vnd.ms-excel;base64,';
var template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>';
var base64 = function(s) {
return window.btoa(unescape(encodeURIComponent(s)))
};

var format = function(s, c) {
return s.replace(/{(\w+)}/g, function(m, p) {
return c[p];
})
};

var table1 = '<table>';

AJS.$('#customfieldmodule .property-list li').each(function() {
var temp = this.innerText;
console.log(temp);
var res1 = temp.substr(0,temp.indexOf(':'));
var res2 = temp.substr(temp.indexOf(':')+1);

table1 += '<td>';
table1 += res1;
table1 += '<br>';
table1 +=res2;
table1 += '</td>';

})
table1 += '</table>';

var issueKey = AJS.$("meta[name='ajs-issue-key']").attr("content");
var fileName = issueKey + ".xls";


var ctx = {
worksheet : issueKey,
table : table1
}


var link = document.createElement("a");
link.download = fileName;
link.href = uri + base64(format(template, ctx));
link.click();
}


</script>

 

Need Help!!

1 answer

0 votes
pooja chourasia
Contributor
December 14, 2017

Added the link element, 

document.body.appendChild(link);

Now able to download excel in firefox however still unable to download excel in IE.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events