Hi Gurus, When I did the testing on the FM: ALSM_EXCEL_TO_INTERNAL_TABLE, I got an Exception error : UPLOAD_OLE and no result on the internal tables. When I use other PC
i_filename = excel_file tables i_tab_converted_data = <s_table> exceptions conversion_failed = 1 others = 2. 参数i_tab_raw_data虽为改办field,但好像没什么作用,传入一个空数据也可正常使用。 三、以另外途径上传excel文件:ALSM_EXCEL_TO_INTERNAL_TABLE call function 'ALSM_EXCEL_TO_INTERNAL_TABL...
i_filename = excel_file tables i_tab_converted_data = <s_table> exceptions conversion_failed = 1 others = 2. 参数i_tab_raw_data虽为改办field,但好像没什么作用,传入一个空数据也可正常使用。 三、以另外途径上传excel文件:ALSM_EXCEL_TO_INTERNAL_TABLE call function 'ALSM_EXCEL_TO_INTERNAL_TABL...
file_filter=cl_gui_frontend_services=>filetype_excel multiselection=‘‘ changing file_table=it_tab rc=gd_subrc. 文件UPLOAD方法(转成内表): 一、最常用FM的是:GUI_UPLOAD 有同等作用的是CLASScl_gui_frontend_services的静态方法gui_upload,文件可以按二进制或文本格式上传,数值和日期等依赖于用户的...
* Note: Alternative function module - 'ALSM_EXCEL_TO_INTERNAL_TABLE' CALL FUNCTION 'KCD_EXCEL_OLE_TO_INT_CONVERT' EXPORTING filename = p_file i_begin_col = p_scol i_begin_row = p_srow i_end_col = p_ecol i_end_row = p_erow ...
* upload excel spreadsheet into internal table *---* * -->P_TABLE Table to return excel data into * -->P_FILE file name and path * -->P_SCOL start column * -->P_SROW start row * -->P_ECOL end column * -->P_EROW
Uploading the data into Internal Table perform upload_data. perform modify_table. top-of-page. CALL FUNCTION 'Z_HEADER' EXPORTING FLEX_TEXT1 = FLEX_TEXT2 = FLEX_TEXT3 = . &--- *& Form upload_data &--- text --- FORM upload_data. CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE' EXPORT...
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE' EXPORTING filename = file i_begin_col = '1' i_begin_row = '1' i_end_col = '10' i_end_row = '35' tables intern = it_tab EXCEPTIONS INCONSISTENT_PARAMETERS = 1 UPLOAD_OLE = 2 OTHERS = 3 . IF sy-subrc <> 0. MESSAGE ID SY-MSGID...
UMREN1(06) TYPE C, " Denominator for Conversion to Base Units of Measure 1. MEINH1(03) TYPE C, " Alternative Unit of Measure for Stockkeeping Unit 1. UMREZ1(06) TYPE C, " Numerator for Conversion to Base Units of Measure 1. ...
给你几个参考函数:ALSM_EXCEL_TO_INTERNAL_TABLE TEXT_CONVERT_XLS_TO_SAP KCD_EXCEL_OLE_TO_INT_CONVERT PS:其实GUI_UPLOAD对文本文件和EXCEL文件都是能够实现上载到SAP内表中的,你把FILENAME = L_FILENAME 上载文件路径换成(C:\Documents and Settings\test.xls)就行啦!!