Okay
  Public Ticket #1455786
Data From Excel CSV
Closed

Comments

  • thomas started the conversation

    Hi, If i was to use this data table and pull data from an excel sheet, If i updated the excel sheet would that automatically update the info on the Wordpress website?

    I plan on having a table which is located on my website, Ran from Excel sheet, 

    The excel sheet will be updated daily, and the wordpress site needs to be updated with latest figures.thanks

  • [deleted] replied

    Hi Thomas,
    Thank you for the inquiry.

    "Hi, If i was to use this data table and pull data from an excel sheet, If i updated the excel sheet would that automatically update the info on the Wordpress website?"

    - Yes, but if you update the Excel file from that you have created table and that is stored on your server. By the default in uploads folder of your WordPress installation. Also this table can't be Manual table type than it needs to be Excel table type in wpDataTables plugin. Please take a look how to create Excel type tables from .xls or .xlsx file in wpDataTables plugin on this page from our documentation. Also the structure in this Excel file should not be changed (That means that number of columns should be always same as you created wpDataTable first time).

    You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.