How to modify cell data before export to excel or csv?

facetostool

I use buttons extension with excel export.
I tried to use customize but it not triggered in my case:

        buttons: [
            {
                exportOptions: {
                    columns: ':not(.hidden-col)'
                },
                "extend": "excel",
                customize: function ( win ) {
                    console.log('HELLO!');
                }
            }
        ]

console.log('HELLO!') - never showed.
In my case I use some ajax buttons and forms in cells witch I want to remove before export.
Anyone know how I can do it?

Tklaversma

Did you got your answer already? I'm still looking for the answer to your question.

I use <select> in a cell and it shows all possible values on output.So I want to edit this, before exporting.

Furthermore, I also use an <input> in a cell. This outputs nothing :(.

Help?

allan

There is currently no customize option for the Excel button type. My answer in this thread might be of some help.

Allan