Hi, Edwin 

Thanks for reaching out to us

-

1. If you mean to set an actual Excel file based table on front-end,  and if this table is linked to source Excel file,

then it will not be editable on WordPress.

-

First i will tell you the most important information to know when working with Excel files and our plugin :

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.

-

2.

But, if you just need to make a table that can be editable in WordPress front-end and to look similar as a spreadsheet editor,

then you can make a Manual table,  and use our Excel-like feature.

3.

We don't have any auto-complete feature as part of our plugin, but can you tell me a bit more about this - i did not fully understand what you need for auto-complete, please?

4.

You can also check out our Form integrations, if you need that perhaps.

We have several built-in integrations with form plugins.

These form integrations are :

- integration for Forminator Forms, ( a free add-on), 

- Formidable Forms integration;   and  Gravity Forms integration

-

Let me know how all of that sounds,

and if you can elaborate a bit more, so that i can understand your goal better.

Thank you.

-

And, just wanted to point out that we have a Demo Sandbox site, where you can try out the plugin functionalities, on this link  ( you can find more links in my signature for add-on Testing)

and there is a 15-day money-back guarantee period, So if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)