Excel button get Uncaught TypeError: this.each is not a function

rognales

My Excel button throws this error jquery.dataTables-1.10.19.min.js:83 Uncaught TypeError: this.each is not a function
No issue on CSV button.

FYI, i use requireJS.

<script type="application/javascript">
require(['jquery','datatables.net','datatables.net-bootstrap4','jszip','datatables.net-buttons','datatables.net-buttons-html5','datatables.net-buttons-flash'], function($, JSZip) {
    window.JSZip = JSZip;
    $(document).ready(function() {
        var table = $('table#market').DataTable({
            dom: 'Bflrtip',
            buttons: [ { extend: 'excel', text:'<i class="fa fa-file-excel-o"></i> Save as Excel', titleAttr:'Excel', className: 'btn btn-default btn-sm', }, ],
        });
    });
});

</script>

Config uploaded by debug tools --> https://debug.datatables.net/eqehas

allan

Does the error identify which each call in Buttons is causing the issue? Can you link to the page showing the issue, as it appears to work okay here?

Thanks,
Allan

rognales

Hi Allen, thx for responding.
I solved the issue.

Actually the jszip is the one throwing the error.

Referring to line 3 (in original post), the JSZip namespace is not available. The assigning does nothing.

This is the solution. the namespace returned should matched with the require order.
jquery -> $
jszip -> JSZip

<script type="application/javascript">
require(['jquery','jszip', 'datatables.net','datatables.net-bootstrap4',,'datatables.net-buttons','datatables.net-buttons-html5','datatables.net-buttons-flash'], function($, JSZip) {
    window.JSZip = JSZip;
    $(document).ready(function() {
        var table = $('table#market').DataTable({
            dom: 'Bflrtip',
            buttons: [ { extend: 'excel', text:'<i class="fa fa-file-excel-o"></i> Save as Excel', titleAttr:'Excel', className: 'btn btn-default btn-sm', }, ],
        });
    });
});
 
</script>

rognales

How do i mark this as closed?

allan

Its done now