I am working on creating tables and charts on WordPress from excel file. My excel spreadsheets contains the pivot tables, can I upload those spreadsheets to create a table and chart on WordPress? If not, can you recommend a way to upload the data on WordPress? Weekly, I update my excel file with new entries, is there any way the existing tables and charts from WordPress will automatically updated on WordPress?
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
Pivot tables cannot be created in wpDataTables, and if you need that functionality, you need to create a PIVOT table in your database, create a VIEW for that table, and then pull that view into wpDataTables.
Tables created by linking to an existing Excel file can be automatically updated if you replace the file in ../wp-content/uploads/YEAR/MONTH/ but the structure needs to remain the same.
Hi,
I am working on creating tables and charts on WordPress from excel file.
My excel spreadsheets contains the pivot tables, can I upload those spreadsheets to create a table and chart on WordPress? If not, can you recommend a way to upload the data on WordPress?
Weekly, I update my excel file with new entries, is there any way the existing tables and charts from WordPress will automatically updated on WordPress?
Hello Phuong Dang
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
Pivot tables cannot be created in wpDataTables, and if you need that functionality, you need to create a PIVOT table in your database, create a VIEW for that table, and then pull that view into wpDataTables.
Tables created by linking to an existing Excel file can be automatically updated if you replace the file in ../wp-content/uploads/YEAR/MONTH/ but the structure needs to remain the same.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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