I have a table with server-side processing, that has thousands of rows.
Whenever I need to download in excel ALL rows, I need first to display (show) all rows, what takes time and sometimes could not work if the table is too large.
Is there anyway in server-side processing tables to download the excel with all existing rows, even if I am displaying for example 10 rows?
I am sorry to disappoint you, but unfortunately no. Full list of table-tools limitations is located in our documentation, but here's why:
Table Tools consists of a block of buttons that provides additional features for the tables. These functionalities are based on a 3rd party HTML5 library.
For tables with server-side processing, only the visible rows will be exported to any format.
Generated PDF, XLS, CSV are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so font, size, and other properties cannot be changed.
You can’t export columns that are hidden – they will not be visible in any exporting or printing tool.
You can take a look at our Report Builder add-on, which can do this for you, and export entire tables to Excel or Word files. It is a paid add-on, so please go through the documentation and feel free to ask anything before purchase.
Hi,
I have a table with server-side processing, that has thousands of rows.
Whenever I need to download in excel ALL rows, I need first to display (show) all rows, what takes time and sometimes could not work if the table is too large.
Is there anyway in server-side processing tables to download the excel with all existing rows, even if I am displaying for example 10 rows?
Thanks
JLO
Hello again JLO.
I am sorry to disappoint you, but unfortunately no. Full list of table-tools limitations is located in our documentation, but here's why:
Table Tools consists of a block of buttons that provides additional features for the tables. These functionalities are based on a 3rd party HTML5 library.
For tables with server-side processing, only the visible rows will be exported to any format.
Generated PDF, XLS, CSV are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so font, size, and other properties cannot be changed.
You can’t export columns that are hidden – they will not be visible in any exporting or printing tool.
You can take a look at our Report Builder add-on, which can do this for you, and export entire tables to Excel or Word files. It is a paid add-on, so please go through the documentation and feel free to ask anything before purchase.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables