Excel button export column not in table but inside source data

alzambo

Hi,
I need to add a field in my exported excel file.
I don't have this field (column) displayed in the table but it is contained in table source data array.
How can I include it in my export button configuration column selector?

This is my code portion:

[...]
"data": datiTabella,
buttons: [
            {
                extend: 'excel',
                text: 'Esporta Excel',
                className: 'btn btn-default',
                exportOptions: {
                    modifier: {
                        page: 'current'
                    },
                    columns: [ 3,4,5,6,7,8,9,10,11,12,13,14 ], // I don't know how to select data that is not on table
                    format: {
                        body: function ( data, column, row ) {
                           // here I have some column formatting...
                        }
                    }
                }
            }
        ]
[...]

Thank you,
alex

allan

Hi Alex,

The file export options of Buttons will only export the data from the columns. As such you would need to include it in the table's columns. But you could simply set the column's visibly to false (columns.visible) if you don't want the column to be visible.

Allan

alzambo

Perfect, thank you Allan.