Multiple Paste from excel to table control

[Former Member]

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]

Have you given the Scroll bar for the table control

Regards,

Prakash

[Former Member]

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]

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]

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

[Former Member]

Answered by myself

[Former Member]

Hi,

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

Thanks & Regards,

Sharbani

[matt]

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]

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