Export button make incorrect order in headers

NIkflipflop

Export button Headers wrong order if use columns order in revert order

 buttons: [
        {
         extend: 'excelHtml5',
         exportOptions: {
             columns: [2,1 ],
             stripNewlines: false,
             orthogonal: "export"

         },
     }
 ],

Will result

Header 1, Header 2
Value 2, Value 1

Order 1.* version all work correct

allan

The export will happen with the columns in the order that they are in the DataTable, not the order of the columns array for the button. That is how the columns selector operates.

Allan

NIkflipflop

But value come in same order like columns instead header,

allan

Oh - I had missed that. Thanks for the follow up. I'll take a look into it next week.

Allan