I would like to be able to copy and paste multiple vertical cells from Excel to a Editor/KeyTable enabled datatable. Is there built-in functionality? If yes, is there a good example I could follow?
I don't believe there is anything built in to paste cells into a Datatable. First you will need to get the contents of the copy/paste buffer. You might be able to find solutions on Stack Overflow for this.
Next you will need to iterate the copied data and use edit() to update existing cells or create() to create new rows. Both API's have options to not display the edit form to programmatically update the table without user interaction.
Answers
I don't believe there is anything built in to paste cells into a Datatable. First you will need to get the contents of the copy/paste buffer. You might be able to find solutions on Stack Overflow for this.
Next you will need to iterate the copied data and use
edit()to update existing cells orcreate()to create new rows. Both API's have options to not display the edit form to programmatically update the table without user interaction.Please post any questions.
Kevin