Go to specific Page number in DataTable Jquery

You want to go to specific page number using Jquery in DataTable Pagination then you can use below to apply.

1. Go to specific page number

    $(document.getElementById('idofTable').DataTable().table.fnPageChange( pagenumber );

2. Destroy DataTable
 
     var table = $(document.getElementById('idofTable').DataTable();
     table.fnDestroy();


That's all in this post.
Hope this helps..

Happy Coding..!!!!!!

Create CSV file using Jquery/ JavaScript

Below is sample Html and Jquery to create CSV using Jquery or Javascript.

if have issue in generating data containing comma (,) use below code.

<table id="tableId">

    <thead>

        <tr><th>Heading</th><th>Heading</th></tr>

    </thead>

    <tbody>

        <tr><td>cell</td><td>cell2</td></tr>

    </tbody>

</table>

<input type="button" value="select table" onclick="





createCSVFile(document.getElementById('tableId') );">


<script>
        function createCSVFile(tablehtml) {
          export_table_to_csv(tablehtml,'report.csv');

        }
        function download_csv(csv, filename) {
            var csvFile;
            var downloadLink;

            // CSV FILE
            csvFile = new Blob([csv], {type: "text/csv"});

            // Download link
            downloadLink = document.createElement("a");

            // File name
            downloadLink.download = filename;

            // We have to create a link to the file
            downloadLink.href = window.URL.createObjectURL(csvFile);

            // Make sure that the link is not displayed
            downloadLink.style.display = "none";

            // Add the link to your DOM
            document.body.appendChild(downloadLink);

            // Lanzamos
            downloadLink.click();

        }



        function export_table_to_csv(html, filename) {
            var csv = [];
            var doc = document.implementation.createHTMLDocument("New Document");
            var p = doc.createElement("p");
            p.innerHTML = html;
            doc.body.appendChild(p);
            var rows = doc.querySelectorAll("table tr");

            for (var i = 0; i < rows.length; i++) {
                var row = [], cols = rows[i].querySelectorAll("td, th");
                
                for (var j = 0; j < cols.length; j++) {
                    

                    //check if data contains comma 

                    if(cols[j].innerText.trim().includes(',')){
                        row.push('"'+cols[j].innerText.trim() +'"');
                    } else{
                        row.push(cols[j].innerText.trim());
                    }
                    
                   
                }
                
                csv.push(row.join(","));        
            }

            // Download CSV
            download_csv(csv.join("\n"), filename);
        }

</script>

Thanks for visiting.

If have any doubt or suggestions please comment.

Have happy coding. :) !!!!!!!