how to access table itself from dtOptions in angularJS-datatables

Question

I'm tring to have a csv download button and need to exclude a couple of columns from table.

I've found a exportOptions defines which columns should be exported. this option comes from jQuery datatalbles and table.column() method is likely to be used to select columns.

now I need to select certain columns, but I couldn't find out how with angular-datatables way.

anyone knows solution?

    <table dt-options="dtOptions" dt-column-defs="dtColumnDef">
        <thead>
            <tr>
                <th>hoo</th>
                <th>hoo</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td>hoo</td>
                <td>hoo</td>
            </tr>
        </tbody>
    </table>



<script>
    // here is inside my controller

    $scope.dtOptions = DTOptionsBuilder
    .newOptions()
    .withDOM('tB')
    .withButtons([
    {
        text: 'download csv',
        extend: 'csv',
        exportOptions:
        {
            // columns: I neet to select certain columns here
            // wiht method like "table.columns(0)" mentioned in jQuery datatables document
            // but I don't know how in angular-datatables
        }
    }]);
</script>

I use angular-way to render table.

does anyone have a clew?

sasa
– sasa

2017-11-14 02:23:31 +00:00
Commented Nov 14, 2017 at 2:23 — sasa
– sasa, Commented Nov 14, 2017 at 2:23

davidkonrad · Accepted Answer · 2017-11-14 12:14:07Z

1

There is no difference between the angular way and a pure jQuery DataTable. And you do not need to access the table instance in exportOptions. What you need is to return a column selector; here are some examples (dont know exactly what you are trying to do) :

exportOptions: {
  columns: [0,4,5] //some columns by index
}
exportOptions: {
  columns: 'th' //any column
}
exportOptions: {
  columns: ['th:eq(1)', 'th:eq(5)'] //same as numbered array
}
exportOptions: {
  columns: 'th:not(:first)' //exclude the first column
} 
exportOptions: {
  columns: 'th:not(.no-export)' //exclude columns with class no-export
}

etc.

answered Nov 14, 2017 at 12:14

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shekhar Reddy Over a year ago

would this be the solution for the event handlers for on click on th !? or a next button click

Collectives™ on Stack Overflow

how to access table itself from dtOptions in angularJS-datatables

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related