结束循环。调用函数 “SAP_CONVERT_TO_XLS_FORMAT” 出口*I_FIELD_SEPERATOR=i_line_header='X'i_filename=li_filename*I_APPL_KEEP=' '表格 i_tab_sap_data=lt_zmmt001_excel*正在更改*I_TAB_CONVERTED_DATA=例外 转换 失败=1其他=2。 结束形式。
今天写一下SAP_CONVERT_TO_XLS_FORMAT 批量导出excel的函数 部分功能代码如下: FORMfrm_export_excel_1 .DATAli_filenameTYPErlgrap-filename.DATAls_filenameTYPEstring. li_filename=p_file. ls_filename=p_file.CALLMETHODzcl_document_jxzhu=>download_template_to_frontendEXPORTINGiv_fun='2' "选择FUN的功...
ASSIGN COMPONENT sy-tabix OF STRUCTURE <fs1> TO FIELD-SYMBOL(<fs2>). IF sy-subrc EQ 0 . <fs2> = ls_comps-name. ENDIF. ENDLOOP. CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT' EXPORTING * I_FIELD_SEPERATOR = i_line_header = 'X' i_filename = li_filename * I_APPL_KEEP = ' ' TAB...
CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT' EXPORTING i_field_seperator = 'X' * I_LINE_HEADER = i_filename = p_pcfile * I_APPL_KEEP = 'X' TABLES i_tab_sap_data = it_excel1 * CHANGING * I_TAB_CONVERTED_DATA = EXCEPTIONS conversion_failed = 1 OTHERS = 2 . ENDAT. ENDLOOP.Reply...
(函数SAP_CONVERT_TO_XLS_FORMAT) 性能较差, 如果文件名已经存在,因为函数本身的BUG,会导致DUMP ,并打开临时文件. 影响多表的同时输出. 八 总结 生成EXCEL文件还有很多其它的方式,但是用了ABAP2XLSX后, 感觉这种方式更简单灵活,结合大数据量用CSV方式,基本可以解决所有数据下载的问题. ...
CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT' EXPORTING i_filename = 'c:\1.xlsx' TABLES i_tab_sap_data = t100_lines. 如果EXCEL文件已经存在,那么数据会被覆盖 注:数据内表中的字段类型不能是数字类型,否则会出现意想不到的错,如有数字类型字段,转出前最好先转换为字符类型再输出...
SAP_CONVERT_TO_XLS_FORMAT SAP_CONVERT_TO_XML_FORMAT SCMS_TEXT_TO_BINARY 我用到的方法只是前两个和最后一个,第四个只能直接导出文件,可能还没有找到合适的方法,以后再做弥补。 下面就是上代码了 DATA: l_user(30) TYPE c VALUE 'admin', "用户名 ...
l_xls TYPE char1, l_txt TYPE char1. TYPE-POOLS truxs . DATA: l_tab_filetable TYPE filetable, l_extension TYPE string, l_filename TYPE string, l_filter TYPE string. DATA: l_result1 TYPE i, l_result2 TYPE abap_bool, l_file TYPE string. ...
Recently, in one of my project a requirement came to generate the output/target file in excel or .xls format. It was challenge how to generate these files because we cannot directly generate a file in .xls file by just giving a name in receiver adapter like “Output.xls”. So it should...
1,306 SAP Managed Tags: ABAP Development, NW ABAP Print and Output Management Hi, Does anyone know how to convert SmartForm output to Excel format (an .xls file)? All helpful answers are highly appreciated Regards, MVKnow the answer? Help others by sharing your knowledge. Answer Nee...