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 #1715945
multiple tabs/headers in excel file
Closed

Comments

  • Andres Eenmaa started the conversation

    I watched your documentation videos and couldn't find if I can use an excel/spreadsheet file which has multiple headers or tabs. My question is, do I have to make these multiple tab/header files into separate files to make it work?

    I also attached some screenshots.

  • [deleted] replied

    Hi Andres,
    Thank you for your inquire.

    Our plugin reads active sheet from your Excel file. There is no option to choose which sheet will be readed at this moment so our suggestion is to split file by sheets.

    For testing purpose we have sandbox website where you can see and test all plugin functionalities

    sandbox.wpdatatables.com

    username: demo

    password: demo


  • Andres Eenmaa replied

    I had another question also. Is it possible to make a working table out of this file (screenshot_6)? I tried it in the sandbox and it came out really weird. (screenshot_1)

  • [deleted] replied

    Hi Andres,

    You need to have one table on the sheet so our plugin could understand where your table begins , which is the header row, column types etc. In your file there is more than one table and my guess is that this is the reason for why plugin has struggle with it.