I have a datatable with different pages (pagination = True), when I delete a row in the first page and export the table using export_format=‘xlsx’, I only get the current page and not the whole datatable.
How can I get the whole dataset when I export?
Interesting question! The user guide explicitly states that when the table is edited the export function will export a view of the table. So this is expected behavior.
Perhaps it’s an idea to export the dataframe directly to xlsx and not use the datatable for this particular matter. Just use a regular export to excel. I advice to use the same source for this. So make a dataframe that creates the datatable and also is available for export.