blocks|key|5105049|text|您希望在定义buttons时使用mColumns。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5105050|文档中的一个示例：|5105051|$(document).ready(+function+()+{
++++$('#example').dataTable(+{
++++++++"sDom":+'T<"clear">lfrtip',
++++++++"oTableTools":+{
++++++++++++"aButtons":+[
++++++++++++++++{
++++++++++++++++++++"sExtends":+"csv",
++++++++++++++++++++"sButtonText":+"Special+columns",
++++++++++++++++++++"mColumns":+[+0,+1,+4+]
++++++++++++++++},
++++++++++++++++{
++++++++++++++++++++"sExtends":+"csv",
++++++++++++++++++++"sButtonText":+"Visible+columns",
++++++++++++++++++++"mColumns":+"visible"
++++++++++++++++}
++++++++++++]
++++++++}
++++}+);
}+);|code-block|syntax|javascript|5105052|这定义了两个将导出为CSV文件的按钮。第一个标记为Special+columns，将只导出列0,1,4。标记为Visible+columns的第二个按钮将导出所有可见的列。|5105053|文档中对mColumns参数的描述如下：|5105054|5105055|参数可以是值为'all‘、'visible’、'hidden‘或'sortable’的字符串，也可以是包含要导出的列索引的整数数组。|blockquote|5105056|5105057|5105058|此功能在1.10版本中并不是新功能。如果你还没有升级，它也可以在older+version中使用。|5105059|entityMap|0|LINK|mutability|MUTABLE|url|http://datatables.net/extensions/tabletools/button_options|1|http://legacy.datatables.net/extras/tabletools/button_options^0|G|8|6|7|0|0|0|0|P|F|1A|5|1J|F|0|4|8|0|0|0|0|0|W|D|1|0^^$0|@$1|2|3|4|5|6|7|18|8|@$9|19|A|1A|B|C]]|D|@$9|1B|A|1C|1|1D]]|E|$]]|$1|F|3|G|5|6|7|1E|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|1F|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1G|8|@$9|1H|A|1I|B|C]|$9|1J|A|1K|B|C]|$9|1L|A|1M|B|C]]|D|@]|E|$]]|$1|O|3|P|5|6|7|1N|8|@$9|1O|A|1P|B|C]]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|R|3|S|5|T|7|1R|8|@]|D|@]|E|$]]|$1|U|3|-4|5|6|7|1S|8|@]|D|@]|E|$]]|$1|V|3|-4|5|6|7|1T|8|@]|D|@]|E|$]]|$1|W|3|X|5|6|7|1U|8|@]|D|@$9|1V|A|1W|1|1X]]|E|$]]|$1|Y|3|-4|5|6|7|1Y|8|@]|D|@]|E|$]]]|Z|$10|$5|11|12|13|E|$14|15]]|16|$5|11|12|13|E|$14|17]]]]

You want to use the <code>mColumns</code> when defining your <a href="http://datatables.net/extensions/tabletools/button_options" rel="noreferrer">buttons</a>.

An example from the documentation:

<pre><code>$(document).ready( function () {
 $('#example').dataTable( {
 "sDom": 'T&lt;"clear"&gt;lfrtip',
 "oTableTools": {
 "aButtons": [
 {
 "sExtends": "csv",
 "sButtonText": "Special columns",
 "mColumns": [ 0, 1, 4 ]
 },
 {
 "sExtends": "csv",
 "sButtonText": "Visible columns",
 "mColumns": "visible"
 }
 ]
 }
 } );
} );
</code></pre>

This defines two buttons that will export to a CSV file. The first one, labeled <code>Special columns</code>, will only exports columns <code>0,1,4</code>. The second button, labeled <code>Visible columns</code> will export all columns that are visible. 

The <code>mColumns</code> parameter is described like this in the documentation: 

<blockquote>
 The parameter can either be a string with a value of 'all', 'visible',
 'hidden' or 'sortable' - or an array of integers with the column
 indexes to be exported.
</blockquote>

This functionality is not new in the 1.10 version. It was also available in the <a href="http://legacy.datatables.net/extras/tabletools/button_options" rel="noreferrer">older version</a>, if you have no yet upgraded.

blocks|key|5105069|text|只是为了完成。在最新版本的DataTables上，它略有不同(这里是documentation)：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|5105070|$(document).ready(function()+{
++$('#example').DataTable(+{
++++++dom:+'Bfrtip',
++++++buttons:+[
++++++++++{
++++++++++++++extend:+'print',
++++++++++++++exportOptions:+{
++++++++++++++++++columns:+':visible'
++++++++++++++}
++++++++++},
++++++++++'colvis'
++++++],
++++++columnDefs:+[+{
++++++++++targets:+-1,
++++++++++visible:+false
++++++}+]
++}+);
}+);|code-block|syntax|javascript|5105071|entityMap|0|LINK|mutability|MUTABLE|url|https://datatables.net/extensions/buttons/examples/print/columns.html^0|Y|D|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Just for completion... on the last version of DataTables, it's slightly different (here's the <a href="https://datatables.net/extensions/buttons/examples/print/columns.html" rel="noreferrer" title="Documentation">documentation</a>):

<pre><code>$(document).ready(function() {
 $('#example').DataTable( {
 dom: 'Bfrtip',
 buttons: [
 {
 extend: 'print',
 exportOptions: {
 columns: ':visible'
 }
 },
 'colvis'
 ],
 columnDefs: [ {
 targets: -1,
 visible: false
 } ]
 } );
} );
</code></pre>

blocks|key|5105092|text|只是为了添加更多的选项，我需要在我的场景中使用这些选项，这可能对某些人有用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5105093|向列传递多个参数，并使用not()排除包含类的列：|offset|length|style|BOLD|5105094|extend:+'csv',+++++++++++++++++++
exportOptions:+{
+++columns:+':not(.noShow):visible'
}|code-block|syntax|javascript|5105095|entityMap^0|0|C|5|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|S|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Just to add a couple more options, which I needed for my scenario, which may be useful to someone.

Passing more than one parameter to columns, and using not() to exclude columns with a class:

<pre><code>extend: 'csv', 
exportOptions: {
 columns: ':not(.noShow):visible'
}
</code></pre>

I did some tests using the TableTools plugin for Datatables on saving CSV.

I noticed that it saves everything. It does not care if you filtered the rows nor if you hide some columns. 

Is there a way to only save the data from visible columns?

Datatables TableTools - Is it possible to only include the visible columns when saving CSV?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我在保存CSV时使用TableTools插件做了一些测试。我注意到它保存了所有东西。它不关心您是否过滤了行，也不关心您是否隐藏了一些列。有没有办法只保存可见列中的数据？

问Datatables TableTools -是否可以在保存CSV时仅包含可见列？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Datatables TableTools -是否可以在保存CSV时仅包含可见列？EN