Hi, Dragan.

Sorry for the delayed reply.

-

Unfortunately, it will not be possible to have both synchronization with the source file,

and also be able to edit the dataTable from the "WordPress end".

I will elaborate generally about our plugin capabilities, when working with Excel files :

There are two ways to create wpDataTables from Excel spreadsheets.

1. Create a table linked to an existing Excel file,

if you create a wpDataTable that will  be connected with the existing source and upload the 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/edited, but the column structure can't. 

So, if you have the file with the same name,

 the same number of columns, same headers, and the same order of columns - you'd be able to replace the original file in its location with the new file, and wpDataTables would pick that up.

-

Alternatively, if you select "URL from any domain"

Creating a table linked to an Excel file by providing its URL is pretty much the same as it is for creating a table by uploading an Excel file. 

The only difference is that you would choose the URL from any domain option instead of the WordPress Media Library option under File location when creating the table,

and when you want to edit the source file,   you don't have to edit the one that is now in your Media Library folder,

but you can edit on the original source file.

-

With this method, any editing you do on the source file is going to reflect in the table,

but this does not make a new table in your database, and it can not be editable from our plugin. ( And we can't run new SQL tables from it)

2.  If you import the file, the plugin reads the source file and creates a manual table. 

Once the table is created, it is no longer linked to the source file, so changing data in the table will not show up in Excel or Google Spreadsheet, and vice-versa,

but this dataTable is editable in our plugin, and we can make new SQL tables from it.

If you need quicker editing, the ability to edit multiple rows at same time,

you can either switch to the Excel-like view, 

and then select and copy the range of cells you want to paste from the source file, and paste it in the Excel-like view, 

or you can import a new/edited CSV to update the table, as well, in the following ways :

• Replace data within an existing table.
• Add data to an existing table.
•   Replace the entire table with new data.

You can see more details on Updating manual tables from source files (CSV, Excel or Google sheet) here.

-

So, as you can see, it is not possible to have a dataTable stay connected with the changes on the source Excel file,

while also being able to edit this table from the plugin end.

-

It might be possible in the future, but i can't realistically say if or when that might happen.

Let me know if you have any questions. Thank you

Hi, Dragan.

Firstly i apologise for the waiting time once again.

Thank you for your patience.

-

Yes, my apology for that, sometimes i can go into "too much details", 

i am working on improving that and making the answers more "concise" to provide only the necessary points.

Of course, please don't hesitate to reach out to us with new tickets for any new questions you might have.

Thanks, we also wish you all the best!