Hey there, Awesome Customers!

Just a heads up: Our team will be out of the office on Monday, November 11th in observance of Armistice Day, but don’t worry—we'll be back in full swing on Tuesday, November 12th.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards,

TMS

Okay
  Public Ticket #1079915
How to Enable Front-End Excel-Like Editing
Closed

Comments

  •  2
    sandiknowles started the conversation

    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?

  • [deleted] replied

    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.

  •  2
    bluecafe replied

    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. 

  • [deleted] replied

    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.

  •  2
    bluecafe replied

    Hi, yes you are right. Sorry for hijacking this thread. If I use the WPDatatable Constructor the option shows up with google spreadsheets ... THANKS!

  • [deleted] replied

    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! 

  •  2
    sandiknowles replied

    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. 

  • [deleted] replied

    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

  •  2
    Johan replied

    Hi Milos, 

    There is no link in the documentation to information about activating the Excel like mode.

    See also the screenshot.

    Johan

  • [deleted] replied

    Hi johanfit,

    You are right. We will correct that. Thank you for notifying us.

  •  2
    sandiknowles replied

    Could you briefly explain how to do this with the short code?  Thanks!

  • [deleted] replied

    Hi sandiknowles,

    All you have to do is to add shortcode like [wpdatatable id=3 table_view=excel] instead of usual shortcode.

  •  2
    sandiknowles replied

    Thank you, Milos!