Skip to Main Content
Feature Request FR-2479
Product Area Page Components
Status ROADMAP

75 Voters

Enable Paste from Excel to Interactive Grid

eric.olson Public · Apr 29 2022

Idea Summary
My users often see an Interactive Grid of rows and columns and want to fill it with some data they already have in Excel. It's time-consuming to do this in the IG because you have to navigate from cell to cell pasting each cell individually. I should be able to select a 3x3 selection of cells and paste them into the IG.

I realize I could create a process to upload a spreadsheet and parse it with various APIs. But I'm not talking about loading a big spreadsheet, but just copying a few cells here and there.

Jeff Kemp says this was possible, but no longer is: Load spreadsheet data into APEX | Jeff Kemp on Oracle

I've implemented something similar in a legacy tabular form with JavaScript and overriding the onpaste event.

This is planned for a future APEX release.

Known Duplicates

Known duplicates

FR-2684
FR-2684 Easy data importing copy paste from excel sheet to interactive grid
FR-2774
FR-2774 Excel like data input

Comments

Comments

  • jonathan.wintermeyer OP 2.6 years ago

    Yes, please!

  • john.snyders APEX Team OP 2.6 years ago

    One question. When you paste 3x3 range of cells from spreadsheet do you expect them to overwrite the values in the next 3 rows from where you paste or do you expect to insert new rows? Or does it depend? 

    My thinking is that it should overwrite and if you wanted insert you would first add/insert 3 new empty rows then paste.

  • eric.olson OP 2.6 years ago

    Personally, I think I'd expect it to overwrite any existing cells, but insert rows if the IG doesn't have enough. I could see it being annoying having to remember how many rows to insert. If it's more than just a few, having to click Add Row 15 times would be a nuisance.

  • steven OP 2.2 years ago

    It must be a fantastic feature to attract Apex usage.  Today, Excel like data grid is very helpful for building enterprise application.

  • sameer OP 2 years ago

    Awesome idea.

  • andraz.podobnik OP 1.4 years ago

    I'd love to have this feature too. Users would love it.

    In the meantime, I'm also able to use the Enhanced Grid Pro plug-in, which supports copy-pasting from Excel. Well, it actually looks and feels like Excel (also with Undo/Redo).

  • sambaran.jana OP 12 months ago

    Excellent idea.

  • sebastian.thomas OP 11 months ago

    Hello Team, when is the paste feature expected from Excel for multiple cells.

  • dsievers OP 10 months ago

    I have users that would love to copy/paste, since they need to populate data from excel.

    Granted we could maybe import this data or start the APEX workflow earlier. But I feel the requirements change faster than we can keep up with, and copy/paste would really help.

  • derik.tran OP 9 months ago

    So how long is this roadmap?  This is a VERY popular feature, and we would like to take advantage of it as well.

  • pjones_dev OP 9 months ago

    This was one of the ideas voted for at kscope 23 so I believe it will be delivered by kscope 24.

  • sebastian.thomas OP 9 months ago

    Hello Team

    Is there an ETA when this feature will be available?

  • jayson hanes Admin OP 3 months ago

    We cannot give ETA's for feature implementations in future releases of APEX until release date. There are so many moving parts involved with features being released, it is more involved than most are aware. It is possible for a feature to be ready to go until it's not at the last moment (for whatever reason, and there could be many).

  • minh.tran OP 3 months ago

    @jayson hanes - appreciate your support on this feature.  The inability to copy/paste from Excel is a key hurdle for our customers to fully adopt APEX apps.

  • vikas.p.kumar OP 2 months ago

    We at EPM also want the feature to be able to paste selected rows and columns from excel to an Apex Component which can be n x m matrix.