sapdoi调用excel.docx

?事务代码 OAOR 导入到系统中备用。然后写程序用DOI技术读取该模板，向模板中填写数据。最后输出出来。因为可以支持公式和VBA扩展功能，所以可以实现自动计算、统计以及EXCEL图标功能。用OAOR 导入EXCEL文件CLASS NAME: HRFPM_EXCEL_STANDARD(一般sap有的，可以自己定义 T-CODE:SBDSV1)CLASS TYPE 为 OTObject key 定义成跟你的报表的名字一致，这样不容易弄错点create的STANDARD DOC.TYPE?双击STANDARD APPLICATION 为 excel 图标进行上传最好把file name, description, language的值都写成程序名一样??（2）然后就可以编程用DOI实现报表的输出：为了输出EXCEL，需要创建一个屏幕，并在屏幕上放置一个容器，详细代码如下：?***?Report?ZZKP052*******REPORT??ZLJC_TEST?NO?STANDARD?PAGE?HEADING?.DATA:?document_name(30)?VALUE?TESTDOI,?active_sheet(50)?VALUE?Sheet1.CONSTANTS?inplace?VALUE?X.DATA:?container???TYPE?REF?TO?cl_gui_custom_container,?control?????TYPE?REF?TO?i_oi_container_control,?document????TYPE?REF?TO?i_oi_document_proxy,?spreadsheet?TYPE?REF?TO?i_oi_spreadsheet,?error???????TYPE?REF?TO?i_oi_error,?errors?TYPE?REF?TO?i_oi_error?OCCURS?0?WITH?HEADER?LINE.DATA:?rangeitem?TYPE?soi_range_item.DATA:?ranges?TYPE?soi_range_list.DATA:?excel_input?TYPE?soi_generic_table.DATA:?excel_input_wa?TYPE?soi_generic_item.DATA:?initialized(1),?retcode?TYPE?soi_ret_string.DATA:?item_url(256),?already_done,?newname(40).DATA?document_type(80).DATA:?excel(80)?VALUE?Excel.Sheet.DATA:?line_count?TYPE?i,?column_count?TYPE?i.DATA:?ok_code?LIKE?sy-ucomm.PARAMETERS?flag.START-OF-SELECTION.?CALL?SCREEN?100.*——————————————————————-*?Module?OUTPUT_TO_EXCEL??OUTPUT*——————————————————————-MODULE?status_0100?OUTPUT.?SET?PF-STATUS?100.*??创建EXCEL模板?PERFORM?create_basic_objects?USING??????document_name.*??输出EXCEL?PERFORM?output_to_excel.ENDMODULE.??OUTPUT_TO_EXCEL?OUTPUT*———————————————————————**???????FORM?create_basic_objects?????????????????????????????????????**———————————————————————*FORM??create_basic_objects?USING?p_app_name?p_classname?p_classtype?p_obj_key?p_docname.?DATA?l_app_name(200).?DATA:?bds_instance?TYPE?REF?TO?cl_bds_document_set.?DATA:?doc_signature?TYPE?sbdst_signature,?wa_doc_signature?LIKE?LINE?OF?doc_signature,?doc_components?TYPE?sbdst_components,?doc_uris?TYPE?sbdst_uri,?wa_doc_uris?LIKE?LINE?OF?doc_uris.?DA