时间戳

首页 > 解决方案 > 仅在数据表中导出列标题

jquery - 仅在数据表中导出列标题

问题描述

我正在使用数据表，它允许用户将数据导出为 csv。我的问题是如何仅在数据表中导出列标题？我已经搜索了互联网，但找不到任何可靠的来源。这是我以 csv 格式导出数据表的代码：

/**
         * Datatable
         */
        SML.table = SML.$tbl.DataTable({
            "dom": 'Bfrtip',
            "buttons": [
                {
                extend: 'csv',
                charset: 'UTF-16LE',
                fieldSeparator: ',',
                bom: true,
                exportOptions: {
                        columns: [1,2,3,4,5,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,44 ],
                    }
                }
            ],
            "order": [],
            "processing": true,
            "select": true,
            "iDisplayLength": 25,
            "searching": true,
            "bLengthChange" : true,
            "orderClasses": false,
            "language": {
                "url": "https://cdn.datatables.net/plug-ins/1.10.15/i18n/Japanese.json",
            },
            "columnDefs": [
                {
                "targets"  : [0,7],
                "orderable": false,
                },
                {
                    "targets": [8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,44 ],
                    //if you can suggest some way to shorten this too
                    "visible": false,
                    "searchable": false
                },
            ],
            "drawCallback": function( settings ) {
              SML.$chk_all.iCheck('uncheck');
            },
        });

所以我的输出应该有两个按钮，分别是将数据导出为 csv 和导出 csv 模板。

标签： jquerydatatablesexport-to-csv

解决方案

刚收到！我只是得到我的表格行的类并将其用于排除：

"buttons": [
  {
    extend: 'csv',
    text : 'Export Template',
    charset: 'UTF-16LE',
    bom: true,
    exportOptions : {
        columns: [1,2,3,4,5,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,44 ],
        rows: ':not([role=row])'
    },
  },
]

希望这对将来的人有所帮助。

推荐阅读