<?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>