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?
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.
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.