with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4. when others. raise upload_ole. endcase. end-of-definition. * check parameters if i_begin_row > i_end_row. raise inconsistent_parameters. endif. if i_begin_col > i_end_col. raise inconsistent_parameters. endif. * Get TAB-sign for separa...
INCONSISTENT_PARAMETERS = 1 UPLOAD_OLE = 2 OTHERS = 3 . *Write result to list IF SY-SUBRC = 0. loop at itab. write: / itab-row,itab-col,itab-value. endloop. ENDIF.
* Get EXCEL-Sheet in internal table CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE' EXPORTING filename = p_file i_begin_col = '1' i_begin_row = g_begin_row i_end_col = '11' i_end_row = g_end_row TABLES intern = git_temp EXCEPTIONS inconsistent_parameters = 1 upload_ole = 2 OTH...
raise upload_ole. endcase. END-OF-DEFINITION.* 检查传入参数是否满足条件 "检查起始行是否大于结束行 IF i_begin_row > i_end_row. RAISE inconsistent_parameters. ENDIF. "检查起始列是否大于结束列 IF i_begin_col > i_end_col. RAISE inconsistent_parameters. ENDIF.* 获取导入模板中字段的TAB标识,...
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. PERFORM ORGANIZE_UPLOADED_DATA. FORM ORGANIZE_UPLOADED_DATA . SORT ITAB1 BY ROW COL. LOOP AT ITAB1. CASE ITAB1-COL. ... ...
upload_ole = 2 OTHERS = 3. Output is in below format. Further based on column number, work area is filled using CASE-ENDCASE and then Appending work area into required internal table in AT END OF ROW block. LOOP CASE (column) when 1. wa_itab-col1 = value when 2. wa_itab-col...
Solved: Hy guys , im using this function in order to read a excel file , however , I m Getting exception upload_ole = 2 , why is that ? , here some code : FORM
h_cell1 type ole2_object. data: ld_rc type i. MESSAGE DEFINATION define m_message. case sy-subrc. when 0. when 1. message id sy-msgid type sy-msgty number sy-msgno with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4. when others. raise upload_ole. endcase. end-of-definition. PARAMET...
upload_ole = 2 OTHERS = 3. IF git_temp[] IS INITIAL. EXIT. ELSE. LOOP AT git_temp INTO gwa_temp. AT NEW row. CLEAR gwa_upload. ENDAT. CASE gwa_temp-col. WHEN '1'. gwa_upload-werks = gwa_temp-value. WHEN '2'. gwa_upload-root = gwa_temp-value. WHEN '3'. gwa_upload-ma...