Format Thousands Separator When Export to EXCEL

windantara

how can me custom number column to thousands separator format?

before : 1000000
after : 1.000.000

windantara

DONE with this code

customize: function( xlsx ) {
                    var sheet = xlsx.xl.worksheets['sheet1.xml'];
                    var twoDecPlacesCols = ['C'];           // you can add more column ['A','B','C']
                    for ( i=0; i < twoDecPlacesCols.length; i++ ) {
                        $('row c[r^='+twoDecPlacesCols[i]+']', sheet).attr( 's', '63' );
                    }
                    $('row c[r=C3]', sheet).attr( 's', '2' );
                },