how to limit the number of rows

[rgarimella9]

i would like to list only 100 entries per page and a next button to go for next page when i am listing the csv content to table format.

rgarimella

[derekeder]

@rgarimella9 you can accomplish this by using the built-in paging in DataTables: https://datatables.net/reference/option/paging

Set the paging option to true in datatables_options:

CsvToHtmlTable.init({
    csv_path: "data/Health Clinics in Chicago.csv",
    element: "table-container",
    allow_download: true,
    csv_options: {
        separator: ",",
        delimiter: '"'
    },
    datatables_options: {
        paging: true
    },
    custom_formatting: [
        [4, format_link]
    ]
});