结束循环。调用函数 “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。 结束形式。
3. 使用SAP_CONVERT_TO_XLS_FORMAT将内表数据导入到Excel 关于 zcl_document_jxzhu=>download_template_to_frontend的方法具体内容:https://www.cnblogs.com/jxzhu/p/12359692.html -Tab Zhu 不念过去 不畏将来
DATA lt_zmmt001_excel TYPE TABLE OF lty_excel. MOVE-CORRESPONDING lt_zmmt001 TO lt_zmmt001_excel. INSERT INITIAL LINE INTO lt_zmmt001_excel ASSIGNING FIELD-SYMBOL(<fs1>) INDEX 1. DATA tablestructure TYPE REF TO cl_abap_structdescr. tablestructure ?= cl_abap_typedescr=>describe_by_data(...
首先呢,有一种方法是直接用函数GUI_DOWNLOAD,您得写点代码,然后指定文件路径和类型,再把数据表传进去,就可以导出为Excel啦。还有一种方法是用函数SAP_CONVERT_TO_XLS_FORMAT,这个也得写代码,不过可以导出为更标准的Excel格式哦。当然啦,如果您觉得这些方法有点复杂,还可以试试在SAP报表里直接导出,就像平时操作Excel...
(函数SAP_CONVERT_TO_XLS_FORMAT) 性能较差, 如果文件名已经存在,因为函数本身的BUG,会导致DUMP ,并打开临时文件. 影响多表的同时输出. 八 总结 生成EXCEL文件还有很多其它的方式,但是用了ABAP2XLSX后, 感觉这种方式更简单灵活,结合大数据量用CSV方式,基本可以解决所有数据下载的问题. ...
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...
另外,如果不要这样做,那我使用前面的TEXT_CONVERT_XLS_TO_SAP函数应该可以。SAP_CONVERT_TO_XLS_FORMATABAP 内表导出到excelCALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'EXPORTINGi_filename = file1TABLESi_tab_sap_data = itable1EXCEPTIONSconversion_failed = 1.以上代码是将内表itable1写到一个EXCEL文件file...
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. ...
SAP_CONVERT_TO_XLS_FORMAT Function Module Q How can I download my internal table into an Excel file? SOLUTION We can use the function module SAP_CONVERT_TO_XLS_FORMAT in order to download the internal table to an excel file. Please u ... ...
SAP_CONVERT_TO_XLS_FORMATConvert data to Microsoft Excel format. SAPGUI_PROGRESS_INDICATORDisplay a progress bar on the SAP GUI, and give the user some idea of what is happening SAVE_TEXTTo load long text into SAP SCROLLING_IN_TABLEIf you are coding a module pool and using a table contro...