Export doesn't work in IE
Export doesn't work in IE
Hello,
I have an issue with exporting my Database to Excel in IE. I have used different version of IE 9,10,11 but still the same problem. Unfortunately I inherited this project and I have been assigned with the task of making it work. I am a newbie to jQuery and Javascripting so any help would be appreciated. Here is the link to the page
http://jci.quantumsds.com/cgi-bin/masood-master/report/CLControl/CEN1c3RvbWVyuPXIEA9DTERlY2ltYWxOdW1iZXLI4sMQAAxDTFVURjhTdHJpbmeI-5sVATIIQ0xTdHJpbmeo45oQEFF1YW50dW0uY3VzdG9tZXIUQ0xNdXRhYmxlU3RhY2tTdHJpbmfA9JO7_f8fHGNvbW1vbi9DdXN0b21lcl9kZXRhaWwuc2h0bWwACEN1c3RvbWVyuPXIEAA=
Below is the code.
$(".export-report").on("click", function(e) {
e.preventDefault();
$("body").modalmanager("loading");
$("#exportTableWrap").remove(); // In case user clicks export more than once.
$exportTable = $("");
$exportTableWrap = $("");
$("table").each(function() {
var title = $(this).attr("data-title");
var titleText = $("#" + title).text();
$exportTable.append(" " + titleText + "");
// Check if this is a DataTable
if ( $.fn.DataTable.fnIsDataTable( this ) ) {
$("thead tr", this).each(function() {
$exportTable.append(cleanRow(this));
});
$(this).dataTable().$("tr").each(function() {
$exportTable.append(cleanRow(this));
});
}
else {
$("tr", this).each(function() {
$exportTable.append(cleanRow(this));
});
}
});
fixupTable($exportTable);
$exportTableWrap.append($exportTable);
var tmpl = [
// tabindex is required for focus
'',
'',
'×',
'Export Report',
'',
'',
'This report can be exported either by copying it or saving it as a CSV file that can be opened in Excel.',
'',
'',
'',
'Close',
'',
''].join('');
$(tmpl).modal();
$("#exportModal").append($exportTableWrap);
$("#exportTable").dataTable({
"sDom": 'T<"clear">lfrtip',
"aaSorting": [ ], // Prevent initial sorting
"bPaginate": false,
"oTableTools": {
"sSwfPath": "theme/quantum/assets/plugins/pl-table/datatables/extras/TableTools/media/swf/copy_csv_xls_pdf.swf",
aButtons: ["copy", "xls"]
}
});
});
any help would be greatly appreciated.
I have an issue with exporting my Database to Excel in IE. I have used different version of IE 9,10,11 but still the same problem. Unfortunately I inherited this project and I have been assigned with the task of making it work. I am a newbie to jQuery and Javascripting so any help would be appreciated. Here is the link to the page
http://jci.quantumsds.com/cgi-bin/masood-master/report/CLControl/CEN1c3RvbWVyuPXIEA9DTERlY2ltYWxOdW1iZXLI4sMQAAxDTFVURjhTdHJpbmeI-5sVATIIQ0xTdHJpbmeo45oQEFF1YW50dW0uY3VzdG9tZXIUQ0xNdXRhYmxlU3RhY2tTdHJpbmfA9JO7_f8fHGNvbW1vbi9DdXN0b21lcl9kZXRhaWwuc2h0bWwACEN1c3RvbWVyuPXIEAA=
Below is the code.
$(".export-report").on("click", function(e) {
e.preventDefault();
$("body").modalmanager("loading");
$("#exportTableWrap").remove(); // In case user clicks export more than once.
$exportTable = $("");
$exportTableWrap = $("");
$("table").each(function() {
var title = $(this).attr("data-title");
var titleText = $("#" + title).text();
$exportTable.append(" " + titleText + "");
// Check if this is a DataTable
if ( $.fn.DataTable.fnIsDataTable( this ) ) {
$("thead tr", this).each(function() {
$exportTable.append(cleanRow(this));
});
$(this).dataTable().$("tr").each(function() {
$exportTable.append(cleanRow(this));
});
}
else {
$("tr", this).each(function() {
$exportTable.append(cleanRow(this));
});
}
});
fixupTable($exportTable);
$exportTableWrap.append($exportTable);
var tmpl = [
// tabindex is required for focus
'',
'',
'×',
'Export Report',
'',
'',
'This report can be exported either by copying it or saving it as a CSV file that can be opened in Excel.',
'',
'',
'',
'Close',
'',
''].join('');
$(tmpl).modal();
$("#exportModal").append($exportTableWrap);
$("#exportTable").dataTable({
"sDom": 'T<"clear">lfrtip',
"aaSorting": [ ], // Prevent initial sorting
"bPaginate": false,
"oTableTools": {
"sSwfPath": "theme/quantum/assets/plugins/pl-table/datatables/extras/TableTools/media/swf/copy_csv_xls_pdf.swf",
aButtons: ["copy", "xls"]
}
});
});
any help would be greatly appreciated.
This discussion has been closed.