what should i do for file export of hidden data

i am using xampp for a page where for the database i am taking 3 columns of the data to be shown in a data-table. i want to make file export buttons (csv,excel,pdf,print) for all the data that is present in the table that i am using (without displaying them), for example i have total 10 columns in the table

what should be the ideal way to do this i cant find any specifics on this.

i was using adminlte as an example but for that the plugins only use the data that is being displayed in the data-tables