DataTables Buttons Excel Export Options代码实例

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)',
                        }
                        /////


                    }
                ]