GUI_UPLOAD 导入 txt 这两个函数都是比较常见的导入功能,也很好用。 可以自定义封装一个类似下图导入功能。 1.ALSM_EXCEL_TO_INTERNAL_TABLE,这个函数模块可以把用户本地 EXCEL 文件中的一个矩形块中的内容上传到一个内表中。 输入参数: FILENAME:最长 128 个字符的路径名称。 I_BEGIN_COL:导入单元格的开始列...
DATA:ENDOFIEXCEL. DATA:XLSLIKERLGRAP-FILENAMEVALUE'C:\sap_usr02.xls'. CALLFUNCTION'ALSM_EXCEL_TO_INTERNAL_TABLE' EXPORTING FILENAME=XLS I_BEGIN_COL=1 I_BEGIN_ROW=1 I_END_COL=100"读取多少列 I_END_ROW=100"读取多少行 TABLES INTERN=IEXCEL EXCEPTIONS INCONSISTENT_PARAMETERS=1 UPLOAD_OLE=...
20.22.1. 读取客户端Txt、Excel文件到内表:TEXT_CONVERT_XLS_TO_SAP TEXT_CONVERT_XLS_TO_SAP函数可以将本地的文本文件(列与列之间默认使用TAB键分开,但也可以指定)或真正的Excel文件上传到服务内表中,并且文件转换成内表中的数据是自动完成,不需要手动,这与ALSM_EXCEL_TO_INTERNAL_TABLE函数是不一样的 PARAMET...
i have a excel file in my computer ,the file have some fields,now i want upload this file to the internal table and of course the internal table have the same fields as this file. i want use the function module (gui_upload or ws_upload),but they just can upload the .txt ,and the...
SAP Managed Tags: ABAP Development Hi U can use GUI_UPLOAD or 'ALSM_EXCEL_TO_INTERNAL_TABLE' Thanks Vasudha Reply Former Member 2007 Nov 28 9:41 AM 0 Kudos 255 SAP Managed Tags: ABAP Development You can use FM ALSM_EXCEL_TO_INTERNAL_TABLE and check this link for sample co...
CALLFUNCTION'ALSM_EXCEL_TO_INTERNAL_TABLE' EXPORTING FILENAME=XLS I_BEGIN_COL=1 I_BEGIN_ROW=1 I_END_COL=100"读取多少列 I_END_ROW=100"读取多少行 TABLES INTERN=IEXCEL EXCEPTIONS INCONSISTENT_PARAMETERS=1 UPLOAD_OLE=2 OTHERS=3. "读取后内表保存的结构为:第一行记录第一个单元的行值列值单元格...
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...
ABAP Development You can use the Function module ALSM_EXCEL_TO_INTERNAL_TABLE to read the Excel file into the internal table of type alsmex_tabline. From this internal table you can fill the target internal table. TYPES: BEGIN OF ty_upload, ...
END OF it_upload. “定义内表 PARAMETERS: p_fname1 LIKE rlgrap-filename. DATA: BEGIN OF it_excel OCCURS 0. ”定义上载的EXCEL内表 INCLUDE STRUCTURE alsmex_tabline. DATA: END OF it_excel. FIELD-SYMBOLS : <fs>. CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE' EXPORTING filename = p_fname...
call function 'ALSM_EXCEL_TO_INTERNAL_TABLE' exporting filename = FILENM i_begin_col = 1 i_begin_row = 1 i_end_col = 100 i_end_row = 30000 tables intern = IEXCEL EXCEPTIONS INCONSISTENT_PARAMETERS = 1 UPLOAD_OLE = 2 OTHERS = 3. ...