How to Copy/Export ONLY current page (client side)

KyleWarford

This has been really frustrating and I assume I am missing something obvious.

I am using HTML5 buttons primarily, though I am not specifying. I would like to just use the basic "buttons" code.

I have spent the last 2 hours looking for an answer to what seems like a very simple request. When you use pagination, with client side processing, copying/exporting etc gives you the entire dataset and not just the currently visible page. how do I change this so I am not given the entire dataset at once?

thank you.

kthorngren

You can try this code to copy/export the visible rows and columns.

    buttons: [
              {extend: 'copy',
               exportOptions: {
               columns: ':visible',
                 rows: ':visible'
              }
             },
              {extend: 'print',
               exportOptions: {
               columns: ':visible',
                 rows: ':visible'
              }
             },
              {extend: 'csv',
               exportOptions: {
               columns: ':visible',
                 rows: ':visible'
              }
             },

            ]

Kevin

KyleWarford

thank you so much!