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.