I have an excel file that our company frequently updates throughout the day. As of right now, every time we make a change to our excel document, I have to re-upload a new fresh excel file to wpDataTables in order for it to display the most recent data. Is there a way for wpDataTables to fetch live data from our excel file without requiring me to upload the newest document every time? Thank you!
You can use Excel files in two ways to create wpDataTables:
1. Create a table linked to an existing Excel file, in which case you get to select the file (upload it) that'll be used to pull the data. This file will be stored in ../wp-content/uploads/YEAR/MONTH/ folder. The file on that location can be changed, but the structure can't. So, you would not be able to add, remove, reorder or rename columns in that file, or the wpDataTable will break. Also, you would not be able to edit the wpDataTable generated from this file.
2. Create a table by importing the Excel file. In this case, the source file is read, and a manual table is created. So, the generated table reads the source only once, and after that there are no relations between it and the wpDataTable. You would be able to edit the table, but the changes wouldn't be seen in the source file.
Hello,
I have an excel file that our company frequently updates throughout the day. As of right now, every time we make a change to our excel document, I have to re-upload a new fresh excel file to wpDataTables in order for it to display the most recent data. Is there a way for wpDataTables to fetch live data from our excel file without requiring me to upload the newest document every time? Thank you!
Hello Robert,
Thank you for reaching out to us.
You can use Excel files in two ways to create wpDataTables:
1. Create a table linked to an existing Excel file, in which case you get to select the file (upload it) that'll be used to pull the data. This file will be stored in ../wp-content/uploads/YEAR/MONTH/ folder. The file on that location can be changed, but the structure can't. So, you would not be able to add, remove, reorder or rename columns in that file, or the wpDataTable will break. Also, you would not be able to edit the wpDataTable generated from this file.
2. Create a table by importing the Excel file. In this case, the source file is read, and a manual table is created. So, the generated table reads the source only once, and after that there are no relations between it and the wpDataTable. You would be able to edit the table, but the changes wouldn't be seen in the source file.
Kind Regards,
Uros Jovanovic
[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