Convert my Datatable to a JSON

oakmese

Hi,

I want to know if it's possible ton convert the datas of my Datatable to a JSON ?

kthorngren

Use rows().data() with toArray() chained to get a Javascript array of rows. You can then use JSON.stringify() to convert to a JSON string. For example:

var json = JSON.stringify( table.rows().data().toArray() );

Kevin

oakmese

Tank you @kthorngren

oakmese

I have div,span, img... in my table, I think the best solution is to get the JSON from the export option of excel do you think it's possible ?

kthorngren

The Excel format is in OpenXML and not conducive to obtaining the raw data.

I would look at using rows().every() to iterate all the rows and build a new array with the manipulated data. Use a regular expression to remove the HTML tags from the appropriate columns. Stack Overflow is a good resource for regex expressions.

I forgot to mention if you use ajax you can use ajax.json() to get the last fetched data.

Kevin

oakmese

thank you @kthorngren