不添加导出csv和xls

Question

我使用DataTables作为动态sql连接的方式。我想添加按钮导出csv和xml，但它没有出现。还是我弄错了。

oTable = $('#tbl_result').dataTable( 
        {
            "sDom": 'T<"top"fl>rt<"bottom"pi>' ,
            "sPaginationType": "full_numbers",
            "bAutoWidth"    : false,    
            "bProcessing": true,
            "bSortClasses"  : false, 
            "iDisplayLength": 15,
            "bStateSave"    : false,    
            "bServerSide": true,
            "oLanguage": {
                "sUrl": "/includes/js/DataTables.fr.js"
            },
            "sAjaxSource": "sql-objects.php",
           "oTableTools": {
                "aButtons": [ "csv", "xls" ],
                {
                    "aButtons":    [ "csv", "xls", "" ]
                    "sExtends":    "collection",
                }
            }, 
            "fnRowCallback": function( nRow, aData, iDataIndex ) 
            {
                $('td:eq(1)', nRow).html( DateFr(aData['date']) ) ;
                $('td:eq(2)', nRow).html( ( aData['etat'] == '0' ? 'Inscrit' :  'En attente') ) ;
                $('td:eq(3)', nRow).html( '<a user="' + aData['mail'] + '" class="delete" href="?id_abonne='+ aData['mail'] +'"><img border="0" class="icon16 infobulle" src="/back_office/images/template/icon16-delete.png"></a>');
            },
            "aoColumns"     :
            [
                { "mData": "mail" },
                { "mData": "date" },
                { "mData": "etat" },
                { "mData": "cle", "bSortable": false}
            ],
            "aaSorting"     :
            [
                [0,'desc']
            ]
        });

非常感谢。

Answer 1

您是否已将插件js文件添加到页面中？下载链接

此外，我认为您需要包括swf文件，因为这是按钮的图像。

"oTableTools": {
            "sSwfPath": "/swf/copy_csv_xls_pdf.swf"
        }