如何获取整个表格数据？

Question

I'm using Datatables Jquery plugin.

I want to get all table datas when I perform click event.

And another task is when I click like copy button, all table datas should be copied to clipboard.

$(document).ready(function(){
    $('#example').DataTable();

    $("button").click(function (event) {

        var mydata="";

        $("#example tr").each(function (row, tr)
        {

            mydata = mydata
            + $(tr).find('td').text() + ' '
            + '
';

        });
            alert(mydata);
    });

});

Answer 1

You can use fnGetData() of the datatable to get all data and do your operation on it.

$(document).ready(function(){
    var dataTable = $('#example').dataTable();

    $("button").click(function (event) {

        var mydata=dataTable.fnGetData();

        /*$("#example tr").each(function (row, tr)
        {

            mydata = mydata
            + $(tr).find('td').text() + ' '
            + '
';

        });*/

            alert(mydata);
    });

});

DEMO

For More Information see below links

how-to-get-all-data

fnGetData