I'm trying to create a download button for a CSV file, but I need to exclude specific columns from the table.
I have discovered an option called "exportOptions" that is used in jQuery DataTables to define which columns should be exported. It seems that the "table.column()" method can be used to select the desired columns.
However, I am using angular-datatables and I haven't been able to figure out how to select specific columns using this framework.
Does anyone know of a solution?
<table dt-options="dtOptions" dt-column-defs="dtColumnDef">
<thead>
<tr>
<th>Column A</th>
<th>Column B</th>
</tr>
</thead>
<tbody>
<tr>
<td>Data A</td>
<td>Data B</td>
</tr>
</tbody>
</table>
<script>
// Here is inside my controller
$scope.dtOptions = DTOptionsBuilder
.newOptions()
.withDOM('tB')
.withButtons([
{
text: 'Download CSV',
extend: 'csv',
exportOptions:
{
// I need to select certain columns here,
// similar to using the "table.columns(0)" method mentioned in the jQuery DataTables documentation,
// but I cannot figure out how to do it using angular-datatables.
}
}]);
</script>I am using the Angular way to render the table.