You need to be logged in to post in the forum - Log In

An active JCE Pro Subscription is required to post in the forum - Buy a Subscription

Support is currently Offline

Official support hours
Monday to Friday
09:00 - 17:00 Europe/London (BST)

Please create a new Ticket and we will get back to you as soon as we can.

#112070 Pasting multiple cell from Excel, into a joomla table

Posted in ‘Editor’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Latest post by ssnobben on Friday, 08 March 2024 08:59 GMT

dhillock
Hello,

If you look at this page here know that everything in a table is originally stored in an excel spreadsheet.

To populate this page, I copy and paste - cell by cell - into the table...because I can barely type my name (it seems), without making a mistake. 😉

I'm trying to figure out a way to copy - for example, the Judge Name and Judge Club - from the spreadsheet directly into the Joomla table. In other words, copy a range from excel (2 x 3 or 6 cells) directly into the table. Is there a way to do this?

Any feedback is appreciated.

ssnobben
Did you get this to work? hmm

dhillock
Unfortunately, no. I copy the cells one-by-one.

Ryan
Copying table cells from Excell and pasting them into the editor will paste them as a table.

If you have an exsiting table in an article and you paste the copied cells into this table, it won't merge the cells into the existing table, but will still paste as a new table into the existing table.

Ryan Demmer

Lead Developer / CEO / CTO

Just because you're not paranoid doesn't mean everybody isn't out to get you.

Ryan
Please try JCE Pro 2.9.63 Beta 5 - https://www.joomlacontenteditor.net/downloads/editor/pro/development

Pasting a table into an existing table will now add the new cells to the table, replacing the content in the target cell and subsequent cells, and adding new cells if necessary. How is a short example:

https://cdn.joomlacontenteditor.net/tmp/112070-pasting-multiple-cell-from-excel-into-a-joomla-table.gif

Ryan Demmer

Lead Developer / CEO / CTO

Just because you're not paranoid doesn't mean everybody isn't out to get you.

ssnobben
yes good to improve this as Dropeditor also working etc https://www.joomunited.com/products/droptableshttps://www.joomunited.com/products/droptables