GUI_UPLOAD 导入 txt 这两个函数都是比较常见的导入功能,也很好用。 可以自定义封装一个类似下图导入功能。 1.ALSM_EXCEL_TO_INTERNAL_TABLE,这个函数模块可以把用户本地 EXCEL 文件中的一个矩形块中的内容上传到一个内表中。 输入参数: FILENAME:最长 128 个字符的路径名称。 I_BEGIN_CO
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...
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. "读取后内表保存的结构为:第一行记录第一个单元的行值列值单元格...
SAP Managed Tags: ABAP Development how to upload the excel file to the internal table , for example: 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. ...
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...
0 Kudos 1,408 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. Thanks...
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...
比如导入数据量过大时,印象里excel导入,每个sheet页能读到的最大行数是4999. 超过这个数,就得放到第二个sheet页再继续读。 如果需要读多个sheet页,可以参考下面的自建fm FUNCTION ZALSM_EXCEL_TO_INTERNAL_TABLE . *"--- *"*"Local interface: *" IMPORTING *" VALUE(FILENAME) LIKE RLGRAP-FILENAME *" ...
1、将EXCEL数据写入内表: ALSM_EXCEL_TO_INTERNAL_TABLE 假设EXCEL有4列, "获取文件地址 SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text - 001 . . PARAMETER : p_file TYPE ibipparms -path DEFAULT 'C:\Users\pc\Desktop\上传模板.xlsx' . ...