Excel button issue in Safari using datatable

Question

I got problem about my button, which allows to export data to .xlsx file. It works good for Edge, Mozilla and Chrome, but if I try Safari on iphone or Macbook it seems that button is just missing and invisible.

I really need help with this, because can't find a proper solution. Data export should fully work on Safari, Mozilla, Edge, Chrome.

Maybe someone faced similar problem? My code:

$(document).ready(function() {
var table = $('#tableOrders').DataTable( {
    "bFilter" : true,               
    "bLengthChange": true,
    "paging":   true,
    "ordering": true,
    "order": [[ @if ($user->role=='super_admin') 7 @else 6 @endif, "desc" ]],
    "info":true,
    dom: 'lBfrtip',
    lengthMenu: [
        [ 10, 25, 50, -1 ],
        [ '10', '25', '50', 'Show all' ]
    ],
    buttons: [
        {
            extend: 'copyHtml5',
            text: '<b>Copy all</b>',
            exportOptions: {
                columns: [@if($user->role=='super_admin') 0, 1, 2, 3, 4, 5, 6 @else 0, 1, 2, 3, 4 @endif]
            }
        },
        {
            extend: 'excelHtml5',
            text: 'Export all to <b>Excel</b>',
            exportOptions: {
                columns: [@if($user->role=='super_admin') 0, 1, 2, 3, 4, 5, 6 @else 0, 1, 2, 3, 4 @endif]
            }
        },
    ]
} );

} );

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

excelHtml5 button does not supported in Safari. There is a note in documentation about it (https://datatables.net/reference/button/excelHtml5):

Safari: No

Safari does not currently support the ability to download generated files (see WebKit bug 156056). As soon as this has been addressed in Safari it will be released here.

Try open their demo in Safari: https://datatables.net/extensions/buttons/examples/initialisation/export.html you won't see Excel button in Safari.

Furthermore based on forum discussion (https://datatables.net/forums/discussion/30444/datatables-built-in-buttons-not-working-with-safari-browser) csv button has limited support in Safari. New tab with generated csv is opened. Try it on demo page.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Oct 4, 2016 at 20:38

vl.lapikov

7967 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gabriel Rodz · Accepted Answer · 2017-03-02 14:57:49Z

0

faced the same problem, as stated above it is not supported. But if you want to maintain integrity between browsers you can validad via user-agent for safari and pass the string to a variable. since CSV works on Safari.

 var xls; // variable csv ó excel
    (navigator.userAgent.indexOf('Safari') != -1 && navigator.userAgent.indexOf('Chrome') == -1) ? xls = 'csv' : xls = 'excel'; //verify

then you extend:

  extend: xls, title: 'yourtitle', className: "btn-sm"

answered Mar 2, 2017 at 14:57

Gabriel Rodz

12 bronze badges

Comments

Le-roy Staines · Accepted Answer · 2019-01-11 00:42:52Z

0

The latest version of Datatables.Buttons works in Safari.

answered Jan 11, 2019 at 0:42

Le-roy Staines

2,0673 gold badges24 silver badges41 bronze badges

Collectives™ on Stack Overflow

Excel button issue in Safari using datatable

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related