<?xml version="1.0" encoding="UTF-8"?> <a:service xmlns:msg="leaf.application.features.msg" xmlns:a="http://www.leaf-framework.org/application" xmlns:task="leaf.application.task" xmlns:excel="leaf.application.task.excel" xmlns:dr="leaf.plugin.excelreport" xmlns:t="uncertain.composite.transform" xmlns:mail="leaf.plugin.mail" xmlns:p="uncertain.proc" trace="true"> <a:init-procedure> <a:model-query fetchAll="true" model="psr.psr_datasource_test_result" rootPath="/model/banks"/> <dr:excel-report enableTask="false" fileName="banks.xlsx"> <styles> <dr:cell-style name="title" align="ALIGN_CENTER"> <dr:font bold="true" fontName="黑体" height="18" italic="false"/> </dr:cell-style> <dr:cell-style name="header" align="ALIGN_CENTER"> <dr:font bold="true" fontName="宋体" height="12"/> </dr:cell-style> <dr:cell-style name="foot"> <dr:font bold="true" fontName="宋体" height="12"/> </dr:cell-style> <dr:cell-style name="footNumber" dataFormat="#,##0.000"> <dr:font bold="true" fontName="宋体" height="12"/> </dr:cell-style> <dr:cell-style name="group"> <dr:font bold="true" fontName="宋体" height="12"/> </dr:cell-style> </styles> <sheets> <dr:sheet name="banks" autoSizeColumns="0,1,2,3,4,5" displayGridlines="false"> <dr:static-content> <dr:cell-data cell="A" offset="false" range="$A$1:$E$1" row="1" stylename="title" type="content" value="银行清单"/> <!-- <dr:cell-data cell="A" offset="true" row="1" stylename="foot" type="content" value="备注"/> --> </dr:static-content> <dr:dynamic-content cell="A" datamodel="/model/banks" row="2"> <dr:columns> <dr:table-column cellStyle="common" column_id="442" field="bank_code" grouplevel="2" merged="true" title="银行编号" titlestyle="header" type="content"> <!-- <dr:groups> <dr:subtotal-config column_id="443" formulaStyle="group" groupStyle="group" groupdesc="计数" groupfield="bank_code" groupformula="3" lineStyle="line" totaldesc="总计数"/> </dr:groups> --><![CDATA[ ]]></dr:table-column> <dr:table-column cellStyle="common" column_id="443" field="bank_name" grouplevel="2" merged="true" title="银行名称" titlestyle="header" type="content"> <!-- <dr:groups> <dr:subtotal-config column_id="443" formulaStyle="group" groupStyle="group" groupdesc="计数" groupfield="bank_code" groupformula="3" lineStyle="line" totaldesc="总计数"/> </dr:groups> --><![CDATA[ ]]></dr:table-column> <dr:table-column cellStyle="common" column_id="444" field="bank_branch_code" grouplevel="1" merged="true" title="支行编号" titlestyle="header" type="content"><![CDATA[ ]]></dr:table-column> <dr:table-column cellStyle="common" column_id="445" field="branch_name" grouplevel="1" merged="true" title="支行名称" titlestyle="header" type="content"> <dr:groups> <dr:subtotal-config column_id="444" formulaStyle="group" groupStyle="group" groupdesc="计数" groupfield="bank_code,bank_branch_code" groupformula="3" lineStyle="line" totaldesc="总计数"/> </dr:groups> </dr:table-column> <dr:table-column cellStyle="common" column_id="446" field="bank_account_num" title="支行账户号" titlestyle="header" type="content"/> <!-- <table-column column_id="447" titlestyle="header" type="content" field="currency_code" title="币种"> <groups> <subtotal-config groupdesc="计数" column_id="447" groupfield="bank_branch_code" groupformula="3" totaldesc="总计数"/> </groups> </table-column> <table-column column_id="448" titlestyle="header" type="content" field="deposit" title="存款金额"> <groups> <subtotal-config groupdesc="平均值" column_id="448" groupfield="bank_branch_code" groupformula="1" totaldesc="总计平均值"/> </groups> </table-column> --> </dr:columns> </dr:dynamic-content> </dr:sheet> </sheets> </dr:excel-report> </a:init-procedure> </a:service>