Adjust Columns when Exporta DataTable Excel

Carlos83

Hi!, Someone know how export and adjust the text column in the exportOption? My code is:

extend: 'excelHtml5',
exportOptions: {
columns: [ 0,1,2,6,7,8] , orthogonal: 'export' },

But export orthogonal not is the solution for me cause in Excel text overflows

Thanks!

colin

Hi @carlos83 ,

I don't understand by what you mean about the "text overflows". You can use orthogonal data as you said, or you can modify it in the export code itself - see here. This example is adding a special character before all cells in a specific column.

Cheers,

Colin