Currently, I see that the export to Excel and PDF includes only the visible fields showing on the screen. Is there any way to include additional fields in the export that are not visible on the screen?
We're using a 3rd party HTML5 library and it has some limitations. One of them is that for tables with server-side processing, only the visible rows will be exported to any format. If you want the entire table to be exported (or copied to a clipboard), you need to choose the “Show All” feature in the “show … entries” block, and then do the export.
One more thing you can try is to make some code customization and to change in file wp-content/plugins/wpdatatables/source/class.wpdatatable.php search for all (there is a couple of them)
Currently, I see that the export to Excel and PDF includes only the visible fields showing on the screen. Is there any way to include additional fields in the export that are not visible on the screen?
Hi Robert
Thank you for reaching out to us.
We're using a 3rd party HTML5 library and it has some limitations. One of them is that for tables with server-side processing, only the visible rows will be exported to any format. If you want the entire table to be exported (or copied to a clipboard), you need to choose the “Show All” feature in the “show … entries” block, and then do the export.
You can view all limitations in our documentation.
One more thing you can try is to make some code customization and to change in file wp-content/plugins/wpdatatables/source/class.wpdatatable.php search for all (there is a couple of them)
and you will find this
'exportOptions' => array('columns' => ':visible'),and you have to replace with this
'exportOptions' => array('columns' => ''),Like this all columns from the table will be exported (visible and hidden)
Please note that this will be overwritten in next update and you have to do it again.
I hope this helps, do let us know if there is anything else we can assist you with.