hii
use this FM like below code..
*Upload data from Excel sheet to internal table. CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE' EXPORTING filename = p_pfile i_begin_col = 1 i_begin_row = 2 i_end_col = 13 i_end_row = 8 TABLES intern = it_excel 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. *Populate data to internal tables and structures SORT it_excel BY row col. LOOP AT it_excel INTO ls_excel. CASE ls_excel-col. WHEN 1. ls_data-rec_no = ls_excel-value. WHEN 2. ls_data-doc_type = ls_excel-value. WHEN 3. ls_data-doc_part = ls_excel-value. WHEN 4. ls_data-doc_ver = ls_excel-value. WHEN 5. ls_data-application = ls_excel-value. WHEN 6. ls_data-data_car = ls_excel-value. WHEN 7. ls_data-file_path = ls_excel-value. WHEN 8. ls_data-matnr = ls_excel-value. ENDCASE. " CASE ls_excel-col.
i hope it helps you.
regards
twinkal
Hi Jem,
You might have missed some parameters in the function you are using.
Please my below code or better you post your code we can find the error that is taking you to dump.
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
filename = P_FNAME
i_begin_col = 1
i_begin_row = 1
i_end_col = 44
i_end_row = 60000
TABLES
intern = IT_FILE_UPLOAD
.
Cheers!!
Balu
Add comment