Hello Blagoj

That depends on how the table is created.

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, if you have the file with the same title, the same number of columns, same headers, and the same order of columns - you'd be able to replace the original file with the new file, and wpDataTables would pick that up.

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. In this case, you'd be able to save new rows in a separate Excel file (without column headers) and export it as CSV. Then, access the table and in the Editing tab above the table see what the "MySQL table name for editing" is. Access your database and access that table. In the "Import" tab select the new CSV file and import it. That will update the table. Another option would be to switch to Excel-like view, select a range of new cells from your Excel file and paste them below the last row in wpDataTables.

You're welcome, Blagoj.

Glad I could help.

If you need some further assistance, please feel free to reach out to us.