Hi,
I need some help. I have purchased the support credits.
But I am in urgent need of help to get the excel work today.

1. Excel speed. The speed is treble for data over 6000 entries it takes around 30 sec before it took around 2 sek.
2. The format is strange. Its docent come out correct on excel. It changes some time comma to dot and dot to comma and sometimes rakes away them.

I have added part of my code below. But I am not able to put hole code up.
It would be great if I can use my credits for Skype so I can share my screen etc.

var DataTable = $("#" + Table_ID).DataTable({
                language: {
                    "decimal": ",",
                    "thousands": ".",
                    "info":           "_START_ to _END_ of _TOTAL_ entries",
                    "infoEmpty":      "",
                    "infoFiltered":   "(_MAX_ total entries)",
                    "search": "_INPUT_",
                    "searchPlaceholder": "Global Search",
                        "lengthMenu":     "_MENU_",
                           },`
                           
               buttons: [
                    {extend: 'excel',className: "buttonsToHide", exportOptions: { columns: ':visible', 
                    format: {body: function(data, row, column, node) {data = $('<p>' + data + '</p>').text(); 
                    return $.isNumeric(data.replace(',', '.')) ? data.replace(',', '.') : data;} } } },
                    {extend: "copy", className: "buttonsToHide"},
                    {extend: 'csv',  className: "buttonsToHide", charset: 'UTF-32', fieldSeparator: ';',  bom: true, },
                    {extend: "pdf", className: "buttonsToHide"},
                        ], 
                                  
                dom:
                "<'row'<'col-sm-12 table-controls'fBli>>" +  "<'row'<'col-sm-12'tr>>" +
                "<'row'<'col-sm-3'><'col-sm-12'p>>",
                  "processing": true,
                "magicGoFaster": true,
                "search": {
                    "regex": true
                },
                
                     "ajax": url,
                
 
                /*columnDefs: [
                    { targets: columnAlignment, className: 'td-right'},
                    { targets: '_all', className: 'td-left'},
                ],
                orderCellsTop: true,*/

                 
                
                "footerCallback": function ( row, data, start, end, display ) {
                    var api = this.api();
                    var footerColumnArray = {};
                    var panelIdsExist = [];

                    $.each(footerColumn, function( index, value ) {
                        var intVal = function (index) {
                            return typeof index === 'string' ?
                            //index.replace(/[,.\s]/g, '').replace(/[\$,₹]/g, '') * 1 :
                            index.replace(/[.\s]/g, '').replace(/[,]/g, '.') * 1 :
                                typeof index === 'number' ?
                                    index : 0;
                        };
                        thousanSep = value.thousand_sep;
                        var decimalValue = value.decimal;

                        var columnTotal = api
                            .column( index, { search: 'applied' } )
                            .data()
                            .reduce( function (a, b) {
                                var resultValue = intVal(a) + intVal(b);
                                return resultValue.toFixed(0).toString().replace(/(\d)(?=(\d{3})+(?!\d))/g, '$1'+thousanSep);
                            }, 0 );

                        var resultSUm = api
                            .column( index, { search: 'applied' } )
                            .data()
                            .reduce( function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0 );

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