DataTables Buttons Excel Export Options



导出excel
                dom: 'Bfrtip',

                buttons: [
                    {

                        ///
                        //$("自定义按钮").on("click",function((){
                        //$("table的导出按钮").trigger("click");
                        //})                      
                       
                        extend: 'excel',
                        className: "btn-sm",
                        text: "导出",
                        ///乱码的话设置为true
                        bom: true,

                        导出固定列
                        exportOptions: {
                            columns: ':visible:not(.noExport)',
                        }
                        /

                    }
                ]