I'm looking for a way where my table on my homepage updates when I change something inside my exel file? Can this be done, and if not, how can I change so it can be done? Do I need to upload my excel sheet into google-sheet and wpDatatable will then update the table automaticly when a change has been made inside the google-sheet? or can i set it to periodic "re-import" the table?
I just need a way to get my data from my excel file into my wpDatatable, without having to manually reimport every single table.
If you created the table using the first option (Create a table linked to an existing data source), the file that is being used as a data source is being stored in ../wp-content/uploads/2019/MONTH.
So, if you change something in that file the changes will be shown in the table when you refresh the page. You just have to watch out for the following:
Once you create a table from an Excel file, changes in this file, like:
Changing the column’s name,
Changing the column’s order,
Deleting the column, and
Adding a new column.
are highly not recommended, because the table in the wpDataTable plugin will not work, at the moment. If you make any of these changes, please recreate the table again.
You can, of course, use it as Google Spreadsheet, and in that way the changes will be visible once you update the Google Spreadsheet file.
There is a cache on the Google side, so when you update the table it might take up to 5-15 minutes to be reflected in wpDataTable.
So, it's up to you to decide now, whether you want to go to ../wp-content/uploads/2019/MONTH and edit the file, or you want to do it through Google Spreadsheets.
Hi
I'm looking for a way where my table on my homepage updates when I change something inside my exel file? Can this be done, and if not, how can I change so it can be done? Do I need to upload my excel sheet into google-sheet and wpDatatable will then update the table automaticly when a change has been made inside the google-sheet? or can i set it to periodic "re-import" the table?
I just need a way to get my data from my excel file into my wpDatatable, without having to manually reimport every single table.
Hello Mikkel
Thank you for your purchase.
If you created the table using the first option (Create a table linked to an existing data source), the file that is being used as a data source is being stored in ../wp-content/uploads/2019/MONTH.
So, if you change something in that file the changes will be shown in the table when you refresh the page. You just have to watch out for the following:
Once you create a table from an Excel file, changes in this file, like:
are highly not recommended, because the table in the wpDataTable plugin will not work, at the moment. If you make any of these changes, please recreate the table again.
You can, of course, use it as Google Spreadsheet, and in that way the changes will be visible once you update the Google Spreadsheet file.
There is a cache on the Google side, so when you update the table it might take up to 5-15 minutes to be reflected in wpDataTable.
So, it's up to you to decide now, whether you want to go to ../wp-content/uploads/2019/MONTH and edit the file, or you want to do it through Google Spreadsheets.
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