Goal:
I need to export all the data from a table that uses server-side pagination so that the CSV file contains all records with the same formatting and column names as displayed in the table.
Steps:
- I have a table that pulls data from a database using server-side pagination due to the high volume of records.
- When exporting to CSV using the built-in function, only the current page’s data is exported.
- I tried using a custom export script, but the exported data does not retain the table’s formatting and column headers.
- Manually mapping over 40+ columns is not a viable solution.
Details:
- Component: Table with server-side pagination
- Issue: The built-in CSV export and custom scripts only export the currently loaded page, not the full dataset with UI formatting and column headers.
- Requirement: The export must reflect the formatted data as seen in the table (including all 40+ columns with their respective formatting) without manually coding each column mapping.
- Code Snippet Request: Could you advise the export code that could export CSV manually?