How to hide column in angular datatable excel export but show column on screen?

Question

I have this code to enable the excel export button:

self.dtOptions = DTOptionsBuilder.newOptions()
    .withButtons([
        {
            extend: 'excel',
            text: 'Export to Excel',
            title: 'banana report'
        }]);

Previously I have used this code to hide the column in the datatable but have it show up in the excel:

self.dtColumnDefs = [
    DTColumnDefBuilder.newColumnDef(11).notVisible()
];

But how can I do the opposite? How can I hide in excel but not the datatable?

davidkonrad · Accepted Answer · 2016-09-30 06:27:00Z

2

Use exportOptions. For example

.withButtons([
   {
    extend: 'excel',
    text: 'Export to Excel',
    title: 'banana report',
    exportOptions: {
      columns: [ 0, 1, 6, 7 ]
    }
   }])

Will only export the specifed column indexes. See

https://datatables.net/extensions/buttons/examples/html5/columns.html https://datatables.net/extensions/buttons/examples/print/columns.html

answered Sep 30, 2016 at 6:27

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

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

Collectives™ on Stack Overflow

How to hide column in angular datatable excel export but show column on screen?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related