topic Re: Multiple Paste from excel to table control in Application Development and Automation Discussions

Multiple Paste from excel to table control

Former Member — Mon, 11 Apr 2011 10:29:20 GMT

Hi All,

I need to provide a facility that will enable us to enter values on table control in a module pool by copy-pasting from an excel.

The problem is that it is only pasting the number of rows that can be seen on the screen. While I need to paste 100 lines.

I have set the 'Lines ' parameter as 100 and yet it is not working.

Kindly suggest a way .

regards,

Inesha

prakashjasti — Mon, 11 Apr 2011 11:25:38 GMT

Have you given the Scroll bar for the table control

Regards,

Prakash

Former Member — Mon, 11 Apr 2011 11:40:02 GMT

Yes, I have provided a scroll bar .

It is currently only pasting only the number of rows as are visible on the screen. That is my problem. I want to paste more than them.

Former Member — Mon, 11 Apr 2011 15:36:36 GMT

Hi,

Try the method CLIPBOARD_IMPORT of class CL_GUI_FRONTEND_SERVICES.

You can get all data in internal table and move all data into table control's internal table.

Regards,

L.Velu

kesavadas_thekkillath — Tue, 12 Apr 2011 04:50:32 GMT

cheeck this blog by Faisal link:[http://weblogs.sdn.sap.com/cs/mobile/view/wlg/20868?x-topic=46]

Former Member — Wed, 17 Aug 2011 06:23:20 GMT

Answered by myself

Former Member — Mon, 13 May 2013 05:24:54 GMT

Hi,

I am facing the same problem. Can u please share your solution.

Thanks & Regards,

Sharbani

matt — Mon, 13 May 2013 05:55:38 GMT

The solution is above.

Try the method CLIPBOARD_IMPORT of class CL_GUI_FRONTEND_SERVICES.

You can get all data in internal table and move all data into table control's internal table.

hsas — Sat, 28 Sep 2024 16:48:46 GMT

we are face same issue i want to paste my data in migo out of screen but sap paste data only within screen