'ALSM_EXCEL_TO_INTERNAL_TABLE issue

[Former Member]

Hi

I tried below fm to download data. But sy-subrc value is 2

pls help me

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = p_pcfile

i_begin_col = 1

i_begin_row = 2

i_end_col = 255

i_end_row = 65000

tables

intern = it_material

EXCEPTIONS

INCONSISTENT_PARAMETERS = 1

UPLOAD_OLE = 2

OTHERS = 3

.

IF sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

[Former Member]

Hi

I tried below fm to download data. But sy-subrc value is 2

pls help me

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = p_pcfile

i_begin_col = 1

i_begin_row = 2

i_end_col = 255

i_end_row = 65000

tables

intern = it_material

EXCEPTIONS

INCONSISTENT_PARAMETERS = 1

UPLOAD_OLE = 2

OTHERS = 3

.

IF sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

[Former Member]

Hi ,

Check if the file name is correct .

Regrads

Arun

[Former Member]

Hi

Check the type of parameters which you are passing in sub-routine , and make comments of error messgae to avoid run time message.

Aditya

[Former Member]

hi,

Check out the file format and the path ...Refer the below path for a piece of code for reference

http://www.sapdev.co.uk/file/file_upexcelalt2.htm

Regards,

Santosh