Copy data from Excel Into Table control Fields

[Former Member]

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

[Former Member]

HI

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

[Former Member]

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.

[Former Member]

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?

[Former Member]

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.

[Former Member]

Hi,

Please check Sm30 when you create entries.

you can directly copy and paste for all the fields.

[Former Member]

i tried, i can copy:)

[Former Member]

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.

[Former Member]

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

[praveen_reddy2]

hi manish,

after copying the data from excel..

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