Upload data from Excel to Internal table in ECC

[Former Member]

Hello SDN,

Here I am facing a problem for uploading the data from excel sheet to internal table in ECC6.0

Main problem is we don't have any FM ALSM_EXCEL_TO_INTERNAL_TABLE.

Please provide me the solution how to upload the data from excel to internal table through class. If possible please provide me the sample code so that it will be very helpful for me.

Waitingfor your valuable response.

Thanks & Regards,

Kumar.

[Former Member]

Hello SDN,

Here I am facing a problem for uploading the data from excel sheet to internal table in ECC6.0

Main problem is we don't have any FM ALSM_EXCEL_TO_INTERNAL_TABLE.

Please provide me the solution how to upload the data from excel to internal table through class. If possible please provide me the sample code so that it will be very helpful for me.

Waitingfor your valuable response.

Thanks & Regards,

Kumar.

[Former Member]

Hi,

FM ALSM_EXCEL_TO_INTERNAL_TABLE is available in ECC 6.0. Please check.

[Former Member]

Hi,

now I am working in BW server. In that we don't have that FM.

Regards,

kumar

[Former Member]

Hi,

Is the class CL_GUI_FRONTEND_SERVICES available ?

Regards

[Former Member]

It is avilable but it is not supporting excel format. I am not getting any data. Please help me out in this issue.

Regards,

Kumar

[Peranandam]

use FM GUI_UPLOAD

[Former Member]

Hi,

Try this FM

'TEXT_CONVERT_XLS_TO_SAP'

[Former Member]

Hi,

you can use OLE to acces (not only) excel, but this will only work in dialog processing.

regards,

Hans

[Former Member]

solved