Alternative for 'ALSM_EXCEL_TO_INTERNAL_TABLE'

[Former Member]

Hi All

Is there any altenative class for function module 'ALSM_EXCEL_TO_INTERNAL_TABLE'

Thanks

[Former Member]

HI,

You can Use

'TEXT_CONVERT_XLS_TO_SAP'

http://www.sapdevelopment.co.uk/file/file_upexcel.htm

Regards

Sumit Agarwal

[Former Member]

'KCD_EXCEL_OLE_TO_INT_CONVERT'

GUI_UPLOAD

Regards,

SAPient

[former_member188685]

Use GUI_UPLOAD or CL_GUI_FRONTEND_SERVICES=>GUI_UPLOAD.

Convert your excel file to Tabdelimited text file and use the above functions.

[Former Member]

Hi,

You can use Function module ws_upload to do the same.

e.g.

**************************

CALL FUNCTION 'WS_UPLOAD'

EXPORTING

FILENAME = 'D:\Quota_upload.xls' "Change here with quote

FILETYPE = 'DAT'

TABLES

data_tab = int_input

EXCEPTIONS

conversion_error = 1

invalid_table_width = 2

invalid_type = 3

no_batch = 4

unknown_error = 5

gui_refuse_filetransfer = 6

others = 7.

[narin_nandivada3]

Hi,

Try using FM - FILE_READ_CONVERT_SAP_DATA

And Can i know why you want to go for an Alternative..?

Hope this would help you.

Good luck

Narin