Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
Hi!
I made a table by importing a excel sheet, i tweaked the settgins to fit the projects needs. I cant find a way to change the text orientation of the indiviudal columns, so I would like to / need to import a new Excel sheet with the correct text orientation – Is there a way to duplicate the table and copy the settings and add the updated excel sheet / Can I reupload excel files to existing tables to replace the content?
Thank you for any insights!
Manuel
Hi Manuel
Thank you for reaching out to us.
If you created a table linked to the file, you must overwrite the file located in ..wp-content/uploads/YEAR/MONTH/ folder, and the table will be updated when you do that, but you need to keep in mind that you can't change the structure of the source file, so renaming, deleting, adding or reordering columns in the source file will cause the table to break.
To update the table by importing the Excel file again, you'd need to remove the headers and existing rows, and include only new rows. Then, in the database, find the wp_wpdatatable_# that was created, and then import that new Excel file in there.
Another option would be to view the table in Excel-like mode in the back-end, and then bulk select; copy and paste the data from Excel. There's no way of updating the existing table by just updating the original file.