As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #2060433
Excel download in server-side tables
Closed

Comments

  •  3
    Jose Luis started the conversation
    June 26, 2019 at 9:13am

    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


  •  2,576
    Aleksandar replied
    June 26, 2019 at 2:36pm

    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