ALSM_EXCEL_TO_INTERNAL_TABLE 导入excel GUI_UPLOAD 导入 txt 这两个函数都是比较常见的导入功能,也很好用。 可以自定义封装一个类似下图导入功能。 1.ALSM_EXCEL_TO_INTERNAL_TABLE,这个函数模块可以把用户本地 EXCEL 文件中的一个矩形块中的内容上传到一个内表中。 输入参数: FILENAME:最长 128 个字符的路径...
SAP Managed Tags: ABAP Development DATA: lw_file(128) VALUE 'D:\UP\CUST.XLS'. DATA: lw_tab LIKE STANDARD TABLE OF alsmex_tabline WITH HEADER LINE. DATA:lw_row(4) TYPE n, lw_count(2) . DATA:lw_fld(20) VALUE 'fs_itab-fld1'. CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE' EX...
lead selectionlo_el_file_upload=lo_nd_file_upload->get_element().* get all declared attributeslo_el_file_upload->get_static_attributes(IMPORTINGstatic_attributes=ls_file_upload).TRY.* Create object of class to read .xlsx file contentsCREATE OBJECTlref_excelEXPORTINGdocument_name=ls_file_upload...
DATA(lo_excel_uploader)=NEWzcl_excel_uploader(iv_filename='C:\excel.xlsx'iv_last_column_number=4iv_number_of_rows=5iv_first_data_row=4iv_names_row=1iv_dataelements_row=2). Next, you will get access to public tablemt_data.As you have noticed table is ...
https://wiki.scn.sap.com/wiki/display/ABAP/How+to+Upload+Long+Text+into+SAP+Using+Excel+Sheet+and+SAVE_TEXT+Function+Module Created bySmruti Ranjan Mohanty, last modified onOct 09, 2013Go to start of metadata Reference Link: Note 933420 - ALSM_EXCEL_TO_INTERNAL_TABLE ...
1,403 SAP Managed Tags: ABAP Development Hi, I want to upload data from an excel file (with multiple sheets) from sheet 2 to Internal tables in SAP. Can anyone suggest which FM to use in which I can provide the sheet number of the excel file. ThanksReply...