onetwo icon indicating copy to clipboard operation
onetwo copied to clipboard

[poi]excel导出,增加动态列支持

Open wayshall opened this issue 2 years ago • 1 comments

excel导出,增加动态列支持

wayshall avatar Jul 05 '22 04:07 wayshall

field元素增加iterator属性,支持通过集合动态创建列

<?xml version="1.0" encoding="UTF-8"?>
<template name="报名客户资料">
    <rows>
        <row span="2" fieldStyle="alignment:ALIGN_CENTER;verticalAlignment:VERTICAL_CENTER;" fieldFont="boldweight:BOLDWEIGHT_BOLD">
            <fields>
                <field value="'报名客户资料'" rowspan="2" colspan="3+#dynamicCellHeaderList.size"/>
            </fields>
        </row>
        <row name="element" renderHeader="true" type="iterator" datasource="#cardList" fieldFont="boldweight:BOLDWEIGHT_BOLD"> 
            <fields>
                <field name="id" label="主键" />
                <field name="cardNo" value="cardNo+'--for--test--'+cardPwd" label="卡号"/>
                <field name="cardPwd" label="密码"/>
                <field name="header" label="#header.name" value="#element.dynamicProperties[#header.id]" iterator="#dynamicCellHeaderList"/>
            </fields>
        </row>
    </rows>
</template>

wayshall avatar Jul 05 '22 04:07 wayshall