Hello Sina.

Thank you for your interest in our plugin.

I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.

This format will work only up to a certain limit (no exact limit, but 3000-5000 cells is a good example). If you have a larger file, the page load time will increase. For large data sets it makes sense to import the data to MySQL, you can use “Create a table by importing data from data source” option to do this.

Also, when you create a table linked to an existing Excel file, the data source is read, and table created, so no future editing of the table is possible. Also, it is not possible to add other Excel files to this table. The file used for table creation is stored in ../wp-content/uploads/YEAR/MONTH, and if you wish to change the data table will display, you would need to change that file.

Please note: Once you create a table from an Excel file, changes in this file, like:

• Changing the column’s name,
• Changing the column’s order,
• Deleting the column, and
• Adding a new column.

are highly not recommended, because the table in the wpDataTable plugin will not work, at the moment. If you make any of these changes, please recreate the table again.

If you choose to go with the SQL Query based table, I can show you a workaround to insert a timestamp column, but showing who edited the row may not be possible.

Also, providing any other access to back-end other than admin is not possible with the plugin's built-in features, but it probably could be done with some Membership plugins, like "Multiple Roles" plugin, although I haven't used it, so I cannot say that it will work 100%.

Best regards.

Hello again Sina.

Yeah, I certainly hope so. You're not the first to ask for an Excel update option, so it is on our "to-do" list. Implementing it, however, is up to our developers, and I cannot say how hard it is to achieve.

We don't have our future plans published anywhere because these tend to change. There's no telling what may come up during development (conflicts, crashes, bugs, etc.) that may prolong the development process. A lot of customers would be upset reading a feature they want to see is "under development", but not see it in a few updates that are released in the mean-time.

Best regards.