custom Order column when export to excel

Wili

Hi @colin ,I have another question ,
when i want to export the data, how to reorder the data only for excel document ?
i want the result on the excel file is ordered by column 15.
Below is my partial code:

"buttons": [{
                "extend": 'excelHtml5', "text":'Export to Excel',"className": 'btn btn-secondary',
                title:'',
                exportOptions : {
                    modifier : {
                        // DataTables core
                        order : 'index', // 'current', 'applied',
                        //'index', 'original'
                        page : 'all', // 'all', 'current'
                        search : 'none' // 'none', 'applied', 'removed'

                    },
                    columns: [ 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17 ]
                }    
                   
            }]

Edited by Colin - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.

colin

You can modify the exported display values with orthogonal data but that's not so easy with the order.

You would need to create a custom ordering plugin, force a draw with draw(), do the export, then pop() that plugin with a final draw() to get the table back to how it was.

Colin