<?xml version="1.0" encoding="UTF-8"?> <a:service xmlns:a="http://www.leaf-framework.org/application" xmlns:dr="leaf.plugin.excelreport" xmlns:s="leaf.plugin.script" trace="true"> <a:init-procedure> <a:model-query fetchAll="true" model="excel_test" rootPath="/model/datasource"/> <a:model-query fetchAll="true" model="excel_test1" rootPath="/model/datasource1"/> <dr:excel-report enableTask="false" filename="exceltest.xlsm" template="D:\u01\hls_file\test111.xlsm"> <dr:styles> <dr:cell-style name="cell1" align="ALIGN_LEFT" vertical="VERTICAL_CENTER"> <dr:font bold="false" fontName="宋体" height="9"/> </dr:cell-style> <dr:cell-style name="cell2" align="ALIGN_LEFT" vertical="VERTICAL_CENTER"> <dr:font bold="false" fontName="Arial" height="9"/> </dr:cell-style> <dr:cell-style name="cell3" align="ALIGN_CENTER" vertical="VERTICAL_CENTER"> <dr:font bold="false" fontName="Arial" fontcolor="RED" height="9"/> </dr:cell-style> <dr:cell-style name="header" cell_style_id="2" foregroundcolor="BLACK"> <dr:font cell_style_id="2" fontname="宋体" height="10"/> </dr:cell-style> <dr:cell-style name="header2" cell_style_id="2" foregroundcolor="RED"> <dr:font cell_style_id="2" fontcolor="RED" fontname="宋体" height="10"/> </dr:cell-style> </dr:styles> <dr:sheets> <dr:sheet name="A2-底层参数" autoSizeColumns="3" displayGridlines="true"> <!-- <dr:static-content>--> <!-- <dr:cell-data cell="A" row="1" stylename="cell_center" type="content" value="100"/>--> <!-- <dr:cell-data cell="B" row="1" type="content" value="200"/>--> <!-- </dr:static-content>--> <dr:dynamic-content cell="A" dataModel="/model/datasource"> <dr:columns> <dr:table-column cellStyle="cell1" field="a" type="content"/> <dr:table-column cellStyle="cell1" field="b" type="content"/> </dr:columns> </dr:dynamic-content> <dr:dynamic-content cell="0" dataModel="/model/datasource1"> <dr:columns> <dr:table-column cellStyle="cell1" field="a" type="content"/> <dr:table-column cellStyle="cell1" field="b" type="content"/> </dr:columns> </dr:dynamic-content> </dr:sheet> <!-- <dr:sheet name="备注" autoSizeColumns="0,1,2,3" displayGridlines="true"> <dr:dynamic-content cell="C" dataModel="/model/datasource"> <dr:columns> <dr:table-column cellStyle="cell1" title="电话催收:CALL电子邮件催收:EMAIL催款函催收:LETTER短信催收:MESSAGE上门拜访:VISIT" titlestyle="header2" type="content"/> </dr:columns> </dr:dynamic-content> </dr:sheet> --> </dr:sheets> </dr:excel-report> <s:server-script><![CDATA[ println(222222); ]]></s:server-script> </a:init-procedure> <a:service-output output="/parameter"/> </a:service>