2. 函数:SAP_CONVERT_TO_XLS_FORMAT 这个FM功能与GUI_DOWNLOAD类似,支持xlsx格式: SELECT*FROMsflightINTOTABLE@DATA(gt_temp) UPTO10ROWS.CALLFUNCTION'SAP_CONVERT_TO_XLS_FORMAT'EXPORTINGi_filename='C:\SAP\QQ1.XLSX'TABLESi_tab_sap_data=gt_tempEXCEPTIONSconversion_failed=1OTHERS=2.IFsy-subrc <>0....
1.FM:GUI_DOWNLOAD 这是最基本的方法,对应 CLASS: CL_GUI_FRONTEND_SERVICES 的方法 GUI_DOWNLOAD 注意参数 FILENAME 以xls 结尾这样在保存时可以保存为 excel. 示例如下 data:itab like table of mara WITH HEADER LINE. DATA:BEGIN OF T_FIELDNAMES OCCURS 0, NAME TYPE CHAR20, END OF T_FIELDNAMES. ST...
2. 函数:SAP_CONVERT_TO_XLS_FORMAT 这个FM功能与GUI_DOWNLOAD类似,支持xlsx格式: SELECT * FROM sflight INTO TABLE @DATA(gt_temp) UP TO 10 ROWS. CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT' EXPORTING i_filename = 'C:\SAP\QQ1.XLSX' TABLES i_tab_sap_data = gt_temp EXCEPTIONS conversion_fa...
CALL METHOD CL_GUI_FRONTEND_SERVICES=>FILE_SAVE_DIALOG EXPORTING DEFAULT_EXTENSION = 'XLSX' DEFAULT_FILE_NAME = LV_FILENAME INITIAL_DIRECTORY = LV_PATH CHANGING FILENAME = LV_FILENAME PATH = LV_PATH FULLPATH = L_PATH EXCEPTIONS CNTL_ERROR = 1 ERROR_NO_GUI = 2 NOT_SUPPORTED_BY_GUI = ...
在使用该程序时,需要将输出的数据已经封装到对应的内表数据中,然后定义OLE2 需要使用的共用数据结构. data:msgxlsTYPEstring.*一、下载EXCEL模板FORMDATA:lo_objdataLIKEwwwdatatab,lo_mimeLIKEw3mime," lc_filenameTYPEstringVALUE'测试.xlsx',lc_filenameTYPEstring,lc_fullpathTYPEstring,"VALUE'D:\test\',lc...
data:msgxlsTYPEstring.*一、下载EXCEL模板FORMDATA:lo_objdataLIKEwwwdatatab,lo_mimeLIKEw3mime," lc_filenameTYPEstringVALUE'测试.xlsx',lc_filenameTYPEstring,lc_fullpathTYPEstring,"VALUE'D:\test\',lc_pathTYPEstring,"VALUE'D:\test\',ls_destinationLIKErlgrap-filename,fnameLIKErlgrap-filename,ls_...
下⾯介绍ABAP2XLSX做电⼦签章 参照ZDEMO_EXCEL15和ZDEMO_EXCEL16，可以⼤概了解如何使⽤ABAP2XLSX填充数据和图⽚。METHOD write_download_excel.DATA:lt_mime_data TYPE TABLE OF w3mime,ls_key TYPE wwwdatatab.DATA:lv_string TYPE string,lv_xstring TYPE xstring.*---* * "ABAP2XLSX ...
lv_size = xstrlen( lv_xdata ). cl_gui_frontend_services=>gui_download( EXPORTING bin_filesize = lv_size filename = 'D:\test.xlsx' filetype = 'BIN' CHANGING data_tab = lt_rawdata ). After open test.xlsx, '啊' is disappeared in cell... Thanks. abap2xlsx Reply All ...
ABAP_EXCEL_DOI_操作手册V1 [ABAP EXCEL DOI 操作]2012年01月04日 1引言
filename = 'C:\Testing.xlsx'. Downloading data from internal table to excel CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = filename filetype = 'ASC' write_field_separator = 'X' TABLES data_tab = g_t_mara. ENDIF. Thanks... Reply Former Member In response to awin_prabhu 2015...