结束循环。调用函数 “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。 结束形式。
1. 先将一个Excel单位格属性设置为文本格式,然后保存下来,用SMW0将EXCEL上传到服务器上 2. 用zcl_document_jxzhu=>download_template_to_fronten方法来讲模板下载下来 3. 使用SAP_CONVERT_TO_XLS_FORMAT将内表数据导入到Excel 关于 zcl_document_jxzhu=>download_template_to_frontend的方法具体内容:https://www...
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...
SAP_CONVERT_TO_TXT_FORMAT SAP_CONVERT_TO_TEX_FORMAT SAP_CONVERT_TO_XLS_FORMAT SAP_CONVERT_TO_XML_FORMAT SCMS_TEXT_TO_BINARY 我用到的方法只是前两个和最后一个,第四个只能直接导出文件,可能还没有找到合适的方法,以后再做弥补。 下面就是上代码了 DATA: l_user(30)TYPEcVALUE'admin',"用户名 l_...
(函数SAP_CONVERT_TO_XLS_FORMAT) 性能较差, 如果文件名已经存在,因为函数本身的BUG,会导致DUMP ,并打开临时文件. 影响多表的同时输出. 八 总结 生成EXCEL文件还有很多其它的方式,但是用了ABAP2XLSX后, 感觉这种方式更简单灵活,结合大数据量用CSV方式,基本可以解决所有数据下载的问题. ...
CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT' EXPORTING I_FIELD_SEPERATOR = I_LINE_HEADER = i_filename = l_filename I_APPL_KEEP = ' ' TABLES i_tab_sap_data = it_excel CHANGING I_TAB_CONVERTED_DATA = EXCEPTIONS conversion_failed = 1 OTHERS = 2 ...
SAP_CONVERT_TO_XLS_FORMAT SAP_CONVERT_TO_XML_FORMAT SCMS_TEXT_TO_BINARY 我用到的方法只是前两个和最后一个,第四个只能直接导出文件,可能还没有找到合适的方法,以后再做弥补。 下面就是上代码了 DATA: l_user(30) TYPE c VALUE 'admin', "用户名 ...
Solved: Hello, When using the FM 'SAP_CONVERT_XLS_FORMAT' to generate an excel, it works only if we are using Office 2013 or an older version. When we tested on a
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. ...
Does anyone know how to convert SmartForm output to Excel format (an .xls file)? All helpful answers are highly appreciated Regards, MV Replies (0) You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in. Comment Answ...