# Pattern name...: t600_p()# Descriptions...: 批量導入excle到單身
FUNCTION t600_p()
DEFINE xlapp, irow, icol INTEGER
# 变量:存对应需要的列数组
DEFINE ls_col01 DYNAMIC ARRAY OF STRING
DEFINE ls_col03 DYNAMIC ARRAY OF STRING
DEFINE ls_col04 DYNAMIC ARRAY OF STRING
DEFINE ls_col07 DYNAMIC ARRAY OF STRING
DEFINE ls_col11 DYNAMIC ARRAY OF STRING
DEFINE li,l INTEGER
DEFINE irow01,irow03,irow04,irow07,irow11 INTEGER
CALL cl_openexcel() returning xlapp, irow, icol
IF xlapp =-1 THEN
CALL cl_err ('' ,'aoo1213' , 1)
RETURN
END IF
LET g_success='Y'# 12是指excle总列数
IF icol >=12 THEN
CALL cl_Excel_ReadColumn(xlapp, 1) RETURNING ls_col01,irow01
CALL cl_Excel_ReadColumn(xlapp, 3) RETURNING ls_col03,irow03
CALL cl_Excel_ReadColumn(xlapp, 4) RETURNING ls_col04,irow04
CALL cl_Excel_ReadColumn(xlapp, 7) RETURNING ls_col07,irow07
CALL cl_Excel_ReadColumn(xlapp, 11) RETURNING ls_col11,irow11
FOR li =2 TO irow
BEGIN WORK
display ls_col01[li]," ",
ls_col03[li]," ",
ls_col04[li]," ",
ls_col07[li]," ",
ls_col11[li]
IF g_success='N' THEN
ROLLBACK WORK
EXIT FOR
ELSE
COMMIT WORK
END IFs
END FOR
CALL cl_Excel_COMCleanup(xlapp)
END IF
END FUNCTION