Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
I have reviewed the documentation on spreadsheet (excel-like) editing. It mentions using this on the front end, but I cannot find how to do that. I have a MySQL table created using the wpDataTable Constructor that I would like to try that on. I don't see any options for Excel-like editing anywhere when I edit the table. Can I do this?
Hi sandiknowles,
Thank you for the purchase.
You just have to enable Front-end editing for that wpDataTable and then you'll be able to Front-end edit Excel-like table. Excel-like tables doesn't have editor modal like standard wpDataTables than you edit them by clicking directly on the cell.
Hi, I have the same problem. No front-end option if an excel spreadsheet or a google spreadsheet is the source. If I choose an excel spreadsheet as source there won't be an option "front-end editing" which I could check.
Hi bluecafe,
Tables made with Add from data source can't be editable. Only Manual tables and MySQL tables with server-side processing can be editable. Please take a look at this post from our documentation - Link.
Hi, yes you are right. Sorry for hijacking this thread. If I use the WPDatatable Constructor the option shows up with google spreadsheets ... THANKS!
Hi bluecafe,
No problem. That is the purpose of Public Tickets
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
Thank you, Milos. I don't understand how to make it excel-like. Is this the same as in-line editing? I was thinking it was different because the arrow keys could be used to move from cell to cell. I only see how to make it in-line or modal.
Hi sandiknowles,
When you are adding wpDataTable shortcode you can choose between Standard and Excel-like table type. If you choose Excel-like you will get Excel-like wpDataTable on the front-end.
Also you can take a look at this post from our documentation for Excel-like editor - Link
Hi Milos,
There is no link in the documentation to information about activating the Excel like mode.
See also the screenshot.
Johan
Hi johanfit,
You are right. We will correct that. Thank you for notifying us.
Could you briefly explain how to do this with the short code? Thanks!
Hi sandiknowles,
All you have to do is to add shortcode like [wpdatatable id=3 table_view=excel] instead of usual shortcode.
Thank you, Milos!