topic Re: Copy data from Excel Into Table control Fields in Application Development and Automation Discussions

Copy data from Excel Into Table control Fields

Former Member — Sat, 22 Jan 2011 07:22:34 GMT

Hi Guru's,

I want to copy data from the excel and copy them into the table control fields...

I have 3 fields in my tablecontrol.. it is possible to copy 3 field data from excel and then click on paste button in screen to copy them into the 3 field of table control....

Please guru's help me on this...

Thanks

Man

Re: Copy data from Excel Into Table control Fields

Former Member — Sat, 22 Jan 2011 11:41:00 GMT

Use any Function Module which opens a file from Desk Top like F4_FILENAME

Then use ALSM_EXCEL_TO_INTERNAL_TABLE Function Module to transfer the data from Excel to Internal Table.

If the internal Table structure you are using on Screen is Same as the above then automatic data transfer takes place otherwise explicit data transfer from the above internal table to Screen to be performed

On how to use the above FM take Where used LIst

Hope this would serve your purpose

Cheerz

Ram

Re: Copy data from Excel Into Table control Fields

Former Member — Mon, 24 Jan 2011 05:01:12 GMT

I just want to copy data like CTRL+C from excel and paste that data into table control through button click.

I want help on this, i have 3 field in my table control.

Re: Copy data from Excel Into Table control Fields

Former Member — Mon, 24 Jan 2011 05:56:28 GMT

whats is ur requirement actually, r u going to design any selection screen where user can upload that excel sheet and then u can get the values from that excel sheet into ur internal table and then u want to show it in tc screen?

whts ur requirement?

Re: Copy data from Excel Into Table control Fields

Former Member — Mon, 24 Jan 2011 07:28:57 GMT

My requiremnet is user copy data from excel by pressing ctrl+v and then in screen it will click on button to paste that data into the fields of table control, i have 3 fields in table control.

User will copy one field data at a time. or copy 3 field data at a time to paste it in the table control.

i am able to copy the data into the 1 field, but not in other field.

Re: Copy data from Excel Into Table control Fields

Former Member — Mon, 24 Jan 2011 07:40:08 GMT

Hi,

Please check Sm30 when you create entries.

you can directly copy and paste for all the fields.

Re: Copy data from Excel Into Table control Fields

Former Member — Tue, 25 Jan 2011 04:11:51 GMT

i tried, i can copy:)

Re: Copy data from Excel Into Table control Fields

Former Member — Wed, 23 Mar 2011 18:48:34 GMT

I think that you just have to do CTRLC and CTRLV...

Re: Copy data from Excel Into Table control Fields

Former Member — Thu, 24 Mar 2011 07:25:21 GMT

Hi,

Check the table maintanence generator, if the 'maintanence type' is 'one step', then you can directly open the same in SM30, copy the content from excel and paste it over there.

Else you can't copy-paste at a stretch.

Re: Copy data from Excel Into Table control Fields

praveen_reddy2 — Thu, 24 Mar 2011 07:38:33 GMT

hi manish,

after copying the data from excel..

go to table maintenance generator and press neww entries and paste it over there.