OOLV显示BAPI和BDC和打印内表.docx

使用BAPI,BDC批量创建用户首先是创建一个状态：代码首先声明读取excel数据的变量等DATA:BEGIN?OF?IEXCEL?OCCURS?0.???INCLUDE?STRUCTURE?ALSMEX_TABLINE.此表是excel系统表，3个字段，行列值DATA:END?OF?IEXCEL.DATA:???LW_FILE?TYPE?RLGRAP-FILENAME,????????RC?TYPE?I,????????LT_TABLE?TYPE?FILETABLE,????????LW_TABLE?TYPE?FILE_TABLE.3个字段，也是excel里显示的3列DATA:?BEGIN?OF?WA_USERS?OCCURS?0,??????USERNAME(12)?TYPE?C,??????PASSWORD(40)?TYPE?C,??????LASTNAME(40)?TYPE?C,??????TAG,END?OF?WA_USERS.DATA?IT_USERS?LIKE?TABLE?OF?WA_USERS?WITH?HEADER?LINE.PARAMETERS?FILE?TYPE?LOCALFILE?OBLIGATORY.程序：AT?SELECTION-SCREEN?ON?VALUE-REQUEST?FOR?FILE.???PERFORM?PRM_FILE.选择文件路径START-OF-SELECTION.???PERFORM?FRM_EXCEL.点击执行，赋值CALL?SCREEN?100.跳转主屏幕AT?SELECTION-SCREEN?ON?VALUE-REQUEST?FOR?FILE.*-------------------------------------------------------------------*FORM?PRM_FILE?.选择文件路径??CALL?METHOD?CL_GUI_FRONTEND_SERVICES=FILE_OPEN_DIALOG????EXPORTING??????WINDOW_TITLE????????????=?选择文件??????FILE_FILTER?????????????=?XLS?模板文件|*.XLSX??????INITIAL_DIRECTORY???????=?D:\????CHANGING??????FILE_TABLE??????????????=?LT_TABLE????把导入的excel表赋给FILE_TABLE??????RC??????????????????????=?RC????EXCEPTIONS??????CNTL_ERROR??????????????=?1??????FILE_OPEN_DIALOG_FAILED?=?2??????ERROR_NO_GUI????????????=?3.??CALL?METHOD?CL_GUI_CFW=FLUSH????EXCEPTIONS??????CNTL_ERROR????????=?1??????CNTL_SYSTEM_ERROR?=?2.??READ?TABLE?LT_TABLE?INTO?LW_TABLE?INDEX?1.??IF?SY-SUBRC?EQ?0.????FILE?=?LW_TABLE-FILENAME.??ENDIF.ENDFORM.?*-------------------------------------------------------------------*FORM?FRM_EXCEL.????点击执行，赋值CALL?FUNCTION?ALSM_EXCEL_TO_INTERNAL_TABLE??EXPORTING????FILENAME????????????????=?FILE????I_BEGIN_COL?????????????=?1开始和结束的行列????I_BEGIN_ROW?????????????=?1????I_END_COL???????????????=?7????I_END_ROW???????????????=?100??TABLES????INTERN??????????????????=?IEXCEL??EXCEPTIONS????INCONSISTENT_PARAMETERS?=?1????UPLOAD_OLE??????????????=?2????OTHERS??????????????????=?3.IF?SY-SUBRC??0.??WRITE:?/?读入文件错误！,FILE.ELSE.一般下面是才是我们关心的问题，循环excel，excel有3列，下面是IEXCEL-COL一列一列的读取，AT END OF ROW当读取一