Search

Thanks zajc, reply much appreciated.

It's good to hear that Datatables has finally provided a solution. BTW, I come here to say that after tried a lot of times, I've figured out myself. Edit datatables.js , search for <xf numFmtId="2" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/> add a line after that with '<xf numFmtId="49" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ Then scroll up a little and find ,change 67 to 68 Customize code: customize: function( xlsx ) { var sheet = xlsx.xl.worksheets['sheet1.xml']; $('row c[r^="M"]:gt(0)', sheet).attr( 't', 'inlineStr' ); //add :gt(0) to skip column title $('row c[r^="M"]:gt(0)', sheet).attr( 's', '67' ); //apply for new style $('row c[r^="M"]:gt(0)', sheet).append('<is><t xml:space="preserve"></t></is>'); $('row c[r^="M"]:gt(0) > is > t', sheet).each(function () { $(this).text($(this).parent().siblings("v").text()); //paste text to new node $(this).parent().siblings("v").remove(); //remove useless v node }); }

Here is another thread from today discussing the same issue: https://datatables.net/forums/discussion/50940/export-to-excel-very-slow-from-version-1-10-17#latest Kevin

Happy to take a look at a test case showing the issue. Allan

Hi @KushalJain , If you just want to change the data in a row, you can easily do that with something like this: table.row(rowId).data(yourNewData).draw(); Cheers, Colin

Make sure your database is optimized, etc. Add sort order to your sql. You are spending time writing out all that html strings only to have DataTables resort it. See if deferRender makes a difference https://datatables.net/reference/option/deferRender Also, might consider using AJAX to get your data instead of creating the html table that DataTables is just going to rewrite.

Thanks for your effort but this gets too complicated for solving my problem. I will have to figure out some sort of work-around. Probably ugly - but functional I hope. Will remember these suggestions for a future page with a different lay out. Thanks.

Another option, if you aren't actually performing any numerical calculations is to simply have it as a string in your JSON data. Allan

It would also be worth looking at the Network panel in your browser's inspector to see what is taking the time. Is it the download of the data, the preparation of the data on the server, or DataTables on the client-side? Allan

Now its working great, thanks.