simple-excel操作模板

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE excel PUBLIC "excel" "https://tobiasy.oss-cn-beijing.aliyuncs.com/dtd/simple-excel.dtd">
<!--<!DOCTYPE excel SYSTEM "others/dtd/simple-excel.dtd">-->
<excel>
    <sheet name="学生表">
        <colgroup>
            <col index="A" width='17em'/>
            <col index="B" width='17em'/>
            <col index="C" width='15em'/>
            <col index="D" width='17em'/>
            <col index="E" width='17em'/>
            <col index="F" width='17em'/>
        </colgroup>
        <head>
            <tr allalign="center" height="20px" isbold="true" fontsize="12px" fontname="黑体">
                <td colspan="7">用户信息表</td>
            </tr>
            <tr align="center" height="12px" fontsize="10px" isbold="true" verticalalign="center">
                <td rowspan="2">编号</td>
                <td>姓名</td>
                <td>性别</td>
                <td>年龄</td>
                <td>生日</td>
                <td>爱好</td>
                <td rowspan="2">排名</td>
            </tr>
            <tr height="10px">
                <td>name</td>
                <td>sex</td>
                <td>age</td>
                <td>birthday</td>
                <td>favourite</td>
            </tr>
        </head>
        <body>
            <tr firstrow="3" height="10px" allalign="center" color="100">
                <td index="0" property="code"/><!--序号 -->
                <td index="1" property="name"/><!--姓名 -->
                <td index="2" property="sex" columnsize="1" /><!--性别 -->
                <td index="3" property="age" columnsize="1" /><!--年龄 -->
                <td index="4" property="birthday" columnsize="1" /><!--出生年月 -->
                <td index="5" property="favourite" columnsize="1" /><!--爱好 -->
            </tr>

        </body>

    </sheet>

</excel>

 

posted @ 2019-11-01 13:19  孤独的拾荒者  阅读(474)  评论(0编辑  收藏  举报