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

[Former Member]

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

[muralikrishnan_vijayanp]

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

[Former Member]

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