topic How to paste data from excel to table control in module pool in Application Development and Automation Discussions

How to paste data from excel to table control in module pool

Former Member — Wed, 25 Feb 2015 12:57:57 GMT

Hi,

I have a requirement to copy data from excel to be pasted in table control fields. It is getting pasted only for the visible rows and not for the entire rows in table control. I want to paste all records which are copied from excel in table control.

Please help me in achieving this issue.

Regards,

Muthu

Re: How to paste data from excel to table control in module pool

muralikrishnan_vijayanp — Wed, 25 Feb 2015 13:24:21 GMT

Hi Muthu,

You can make use of the method clipboard_import from cl_gui_frontend_services class. Add a button in table control screen for copying the data from clipboard. While clicking on that button call this method.

Thanks,

Muralikrishnan

Re: How to paste data from excel to table control in module pool

Former Member — Wed, 25 Feb 2015 14:04:13 GMT

Hi murali,

Thanks for your reply. Please let me know how to add a button in table control field. So that when the user selects the particular field in table control and upload data.

Regards,

Muthu