Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

 

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

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
Community showcase
Published in Jira

December to Remember: 12 Jira features from 2021

At Atlassian, we are committed to delivering a delightful customer experience, which means our engineering and product teams are frequently shipping a flurry of new features. Between all of those rel...

403 views 1 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you