我正在使用Jquery和Datatables为客户创建一个资助研究项目的数据集。现在一切都很顺利，除了"；打开"；嵌入到我的按钮中也包含在导出中。问题是，用户不希望在打开网页时默认显示研究摘要，但他们希望能够以模式打开网页，或者导出结果并在那里查看。可以添加200个项目，每个摘要大约有1000个字符，因此，我试图在默认情况下使其不可见。我可以让抽象出现在模态中，我可以让它出现在导出的PDF/XLSX/CSV文件中，但我得到的是抽象+"；打开"；在输出中。我明白为什么会发生这种情况——我在同一个数据单元中有摘要和按钮，但我不知道如何让它发挥作用。感谢您的帮助。
底线：我不想要这个词"打开"；从我的按钮连接到导出输出中的研究摘要字段。
这是我的密码笔：https://codepen.io/tenebris_silentio/pen/eYZmPQE
<!DOCTYPE html>
<html lang="en">
<script>
$(document).ready(function() {
$('#example').DataTable( {
dom: 'Bfrtip',
buttons: [
{
extend: 'copyHtml5',
exportOptions: {
columns: [ 0, ':visible' ]
}
},
{
extend: 'excelHtml5',
exportOptions: {
columns: ':visible'
}
},
{
extend: 'csvHtml5',
exportOptions: {
columns: ':visible'
}
},
{
extend: 'pdfHtml5',
orientation: 'landscape',
exportOptions: {
columns: ':visible'
}
},
'colvis'
]
} );
} );
</script>
<table id="example" class="display">
<thead>
<tr>
<th class="all" data-toggle="tooltip" title="The known name of the project." >Project Name</th>
<th class="all" data-toggle="tooltip" title="The provided unique ID that distinguishes projects.">Project Number</th>
<th class="all" data-toggle="tooltip" title="The conclusing time point of a project, which is sometimes, but not always the point at which funding ends.">End Date</th>
<th class="all" data-toggle="tooltip" title="The primary funder of the project.">Funder</th>
<th class="all" data-toggle="tooltip" title="The principal investigator(s) or person responsible for the project.">PI</th>
<th style="all">Source</th>
<th style="all">Keywords</th>
<th style="all" data-toggle="tooltip" title="A list of project descriptors.">Tags</th>
<th style="all">Clinical Setting</th>
<th style="all">Project URL</th>
<th class="all" data-toggle="tooltip" title="A brief description on the scope and aims of a project.">Abstract</th>
</tr>
</thead>
<tbody>
<tr>
<td>Measuring Patient Handling and Mobility Experiences</td>
<td>NIH 17423424</td>
<td>1/1/2016</td>
<td>National Institutes of Health</td>
<td>John Smith, Ph.D</td>
<td>National Institutes of Health</td>
<td>Mobility, Distance, Measurement</td>
<td>digital</td>
<td>primary care</td>
<td><a href="https://www.testwebsite.com">Abstract Page</a></td>
<td><div id="ex1"class="modal">
<p>
<b>Abstract<p></b> Background: Safe Patient Handling and Mobility (SPHM) consists of ergonomic techniques and equipment to move patients who cannot move independently. SPHM helps minimize adverse events (pressure ulcers, falls), and staff injuries. Despite benefits, we know little about how patients experience assisted mobility. With valid and reliable scales, we can measure patient experiences, thus facilitating improved care, more tailored evaluation, and more targeted clinical staff education. Patients in rehabilitation are an ideal group to study.
<b></p>
<a href="#" rel="modal:close"></a>
</div>
<p><a href="#ex1" rel="modal:open"><button class="button"><span>Open</span></button></a></p></td>
</tbody>
</table>
在每个exportOptions部分(每个按钮一个(中，您可以添加一个选项来处理此问题，例如：
exportOptions: {
columns: ':visible',
format: {
body: function ( data, row, column, node ) {
var text = node.textContent;
return column === 10 ? text.replace( /Open$/, '' ).trim() : data;
}
}
}
工作原理：
对于每一行数据，如果列索引为10(第11个可见列(，则format.body函数将使用node.textContent从该节点提取文本。
然后最后不想要的"；打开"；文本将被删除，所有剩余的尾随空格都将被修剪。
对于所有其他列，单元格的数据将以不变的方式传递。
请参阅此处的exportData文档，以供参考。