topic Re: Upload data from Excel to Internal table in ECC in Application Development and Automation Discussions

Upload data from Excel to Internal table in ECC

Former Member — Tue, 09 Jun 2009 11:42:17 GMT

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.

Re: Upload data from Excel to Internal table in ECC

Former Member — Tue, 09 Jun 2009 11:58:55 GMT

Hi,

FM ALSM_EXCEL_TO_INTERNAL_TABLE is available in ECC 6.0. Please check.

Re: Upload data from Excel to Internal table in ECC

Former Member — Tue, 09 Jun 2009 12:00:42 GMT

Hi,

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

Regards,

kumar

Re: Upload data from Excel to Internal table in ECC

Former Member — Tue, 09 Jun 2009 12:10:15 GMT

Hi,

Is the class CL_GUI_FRONTEND_SERVICES available ?

Regards

Re: Upload data from Excel to Internal table in ECC

Former Member — Tue, 09 Jun 2009 15:12:21 GMT

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

Re: Upload data from Excel to Internal table in ECC

Peranandam — Fri, 12 Jun 2009 01:29:45 GMT

use FM GUI_UPLOAD

Re: Upload data from Excel to Internal table in ECC

Former Member — Fri, 12 Jun 2009 04:23:41 GMT

Hi,

Try this FM

'TEXT_CONVERT_XLS_TO_SAP'

Re: Upload data from Excel to Internal table in ECC

Former Member — Mon, 15 Jun 2009 21:03:31 GMT

Hi,

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

regards,

Hans

Re: Upload data from Excel to Internal table in ECC

Former Member — Thu, 13 Aug 2009 06:35:59 GMT

solved