POI导出带格式的Excel模板——（六）

Jar包

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAASMAAAEdCAIAAADIMpanAAAWX0lEQVR4nO2dz68kx13A3x/AjRsHTiinIA5cYCTuKBduli0wSGANOUQcjEFaG0fBMjGLslZLXpzDykaJBI6QyW4k3EKOVpEjJ5BbULzoJWOv93nX+/w2s/aT3r4glkXNYaa768f3W93zq6ar6/PR0+ptd3V19bz6TlXX9PczBxUA7J6DfTcAIAuINIAYEGkAMSDSAGJApAHEoDvSDo9OvvPuT/7hrf/o/PnOuz85PDqJ0GiA5OiOtKvv/PjGz26en5//t8eDBw+a38/Pz2/87ObVd34codEAydEdaa+++b379+8/evTo/wwePXr04MGD05+++/Dhw2bL/fv3X33ze7tvcyxmxeRgUsxGdy7YB92RVrzx9nw+/1+Dhw8fnp2d3f/u1+Yv/9b5+XmzfT6fF2+8HaHRkVij95fTgyXCge3Og4ODabnpuSApuiPt4jfeOjk5+R+D09PTe/928ed/87nPPvvs5//59vn5+WL7ycnJxW+8FaHRQ6WcNsFSTr1gqsqptwmyoTvSXrhy9fj4+Bc1Z2dnn1y/fPLlXzk+Pv7kX1+49+Lnzs7OFruOj49fuHI1QqNToJx6YxSRljPdkfbc5W/duXPnrOb09PTk2V9e/Lv45fT0dLHrzp07z13+llSHP6kyZ1JN9yunB5OiLCbN1rqUcVS4QLDmwi08W9bkT+aa3WYN2sxPu2JhgqjWYJ5LaNZidzmVp6WQAN2R9sylbx4dHZ3WzOfzk7/7zaOjo0/+4pfm8/l8Pr99+/bdu3c//fTTo6OjZy5906ugnLrdw97SdkqjJy069mJz2wt7FVBrbgtPipkTSBLd1QYODJXwXxHjXLNi6k9BF8HHiJgw3ZH2hRf/xfz54IMPbt68eeeFX7t17Ss3b968ffv2Xxb/ePH1b3/00Ufvv//+l1664h7vT6PcLU0vM3eIv3cV6FXzrJiYwWoe0AxcdiiGqnXH1Fkx6THueC+KHfbeqNb5rgBDpzvSfv1PLps/Tz7/9S9+9bXff+7vn3j28he/+tqVN9++e/fuE89e/tvXrx4eHj71lcvu8b0irV8grRNp/oHNxua/ypwsFGlyLHWOdkZBu1xzLjNSzYGOSEuc7kh78sLLT77xx+ZP+f0fld//0bXrP7x2/d8PZx8cHh7+0Ze/fvH1qzdu3HjywsteBWb3K4tlQNiTseV/No60XjXXcTIrCusuyGt4YPYoBppYTbt8P5v5009/KmtUbkxCibTk6Y60x55+6Tdefcz8efzCK09ceOXxC6/86YtXbt269YfPv/rSa9++devWe++999jTLwlVtJOh8ALD5pHWp+Z2RGqLir141RUR6/OyulwbacZua03GuWlsX6zJdMqYNhq6I+2Hf/7b/s9PbT7++OPj4+PZbPZ7X/rrCI0eIYTS2OmOtHemn/+vr33B/Hln+vk/u/RP5s+9e/fm8/mHH374u9O/itDo8cEjIqOnO9K++/iv+j/HHvfu3fvna2899ow0e4QAy0klA9rI6Y60a9d/8NTzl37nD57u/Hnq+UvXrv8gQqMBkoNMUIAYEGkAMSDSAGJApAHEAI8IQAzwiADEAI9IgHRSN/nke/DgEQmw3UhrnnvsyFwLl5HzCIi0wYNHJMAWI21WTJZV6Zk1XWXqZ48JqRTBIxJgN7NHLemmo8xy2OpzNAwQPCKB2ZoRaUJRuU4rEbsQwmLNQAvvQkMyePCIBGgiTXR7SHVa8z5bdDAz3iA0epTpijQ0JAMFj4juEbFnj95QIdXpNEAKC+PNQNCQeGW6X07rQuWmkv22f/CI6B6RJtJkt8eakbbh/LEj0tCQDBU8IpXeEetIk90e6jgpzB7bZUV9QV4s45W2Ig0NSTrgEQncGBn3aYLbQxknjbLmikjX6otSZtVIQ0MyVPCI7JJoS/KE0uDBI7JdjClgaF1j+2dl+X7g4BHZNsYUMEbnR0OSCHhEAGJAJihADIg0gBgQaQAxINIAYoBHBCAGeEQAYrB7j4j2qeoWn5/gg1sYPLv3iBBpAPv0iJCmDzmxP48IkQY5sXuPiPodtq6HQE516bCGeKfAogGDZPceEVvyIT3ovrZWxD8FFg0YKLv3iIguj0pJ71QP0H63j2j+h0UDBsbuPSLrRFr/DGv7FFg0YKjs3iMizx7NmFhXK4JFA9Jh9x4Rs5+3Cx+OdXQtrQgWDUiH3XtEIvRzQgkGz849IhGe3+ARERg+O/eI7HZ5HYsGJAIeEYAYkAkKEAMiDSAGRBpADIg0gBjgEQGIAR4RgBjszyNSVc6XbnYVBkiY/XlEqopIg3zYn0ekqoRIAxgp+/OIVBWRBvkQzyNiJIw1mWri7BEjCIyQmB6ROrHMyvXECAJZENEjUlX1s/dmTqc+pmEEgRER0SNSVStEGkYQGBcxPSLLaaOxkl9HGkYQGDvxPCKGl6eJHT3SMILAuBiYR4RQgpEyLI8Ij4jAWBmMRwQjCIwaPCIAMSATFCAGRBpADIg0gBgQaQAxwCMCEAM8IgAx2L1HZFX49DoMr0+a7N4jsiod3pGD8AfczReK+geq3dP8VreZv1X4/np3U1uDk7Wg1Wm23ytpfpmc3wIiLU326xFZiVkxcVK2vf1iZNR7lO5ZTidyyqnxjaVuGrhVlfdlwMrhYvuVE1k18dzMGNivR2Rd9M6t7JlO/e2Beq3+beXMeaeQBlH5cKn9XSWFy4E02b1HxJR/uDMn6Ut3e7yLB/qf9m3zvbpsM6rYGarOsdZ/Z8VkUhTO/C94uLUlXFJ8KVCtpMnuPSKO/KOdI3lfJN+OHEqk1R0rEIh+VHiZpQp6wmko0srpgTcTVA/32r/Ciax2olpJj917RNzuZGSGim/gbXF1TSKwvuGGgbHK4C04WCOTVWP/Mc3e1yqJusa05aZQSeXNAdVKmuzeI7JCpPn3SBrqEOVaEUKreO0hwdsjt0H+7FGINP1wq45ASe0SUa2kye49Ipbo0fyPN3sUFgnsasxK2sJdC4HB7crpfHWeVpXRArtZ7uFi+/UTSUM+qpWE2b1HpFn7C32U1GtFRLn/3yzSvA+vjJsuv8FiVdJij3S40H71RN5Ai2olcXbvEeFvv114OdNk5x4RusZ24RGRRNm5R4RI2xqoVlIGjwhADMgEBYgBkQYQAyINIAZEGkAM8IgAxACPCEAM8IgozyvuBT6WHi9peUR2wxqRJqtHvJ3658yy74RIGy8JeUQ2pE8U9Yw0UT1i7g5WovtOYMSk6RFZhy1GmomQJBCMNN13AqMmLY+IP2mTalj0/lruUWdcmkfasg03jVJsqoIwppkZqGoFXeYCHCFjIyGPiO80UGow5R7yPZjdJDfjy2+qgpXj2qvF5i4cIVmRjkckpJhyTmTuaJYe3EizMzTFNEqzQnf9w1WPyPSxMKgvFY6QMZGOR6RXpDUenO1GmtCW3muUcrmOSMMRMjrS8YhY3bss6rsvSVO1UaRJTfUvyNtuTFNn/nw2bGHAEZIBKXlEJOWGviLiRlp9tG9kdAYNuakGonqkjSVn9aU5xSqRhiNkdOARGRK8VOMFj8iA4BGREYNHZBjgCBk7eEQAYkAmKEAMiDSAGBBpADEg0gBigEcEIAZ4RABigEckTEf+NPRiWH/T/YBHJMzmkdY8BqnWIztFQtltmshE/b5i4RRCvqt4uNh+r6T3LKj8NYsZk49HZD02jLRZ80WgcqKN7hRZ7FHzSAWRidGdzZOJpxCSdsTDxfYrJ7JqYiLgko9HZD22N3vUO7eyZzrt5Rqpj7b6t5Xo5p1CGkTlw6X2d5VEkSKStkfETCFzJQBWpeX0YFKUy+3LPFTrnV5rpBlpwoxNOJVCoP95u5YvQa8u21y2/Z7gHOsm6bSaFWN00g+3toRLqsl7uftR0vKIWD28qWVSzIydooHD+Csu4sVN+Ao00jqPdfY+06SZEd4KflT4koZA5WLuWijSDM1KMxNUD/fav8KJrHbm7kdJyiMi33Mvdnh1We+b5snE3wMGEdskYp3dP7W6JtHX3mP8x/7VrdYVmfQf0+x97VtV15jWvlWpJZU3B/woaXtE2h3ONNA3cGwj0tTxJbh40e8CrNYr7yjuNYduj9wX0Z89CpGmH27VESipXSJ+lGQ9IlU5bW/PJgtlY/OOKxg4ekWa0si2te7ZZ0URvrlsl+5Mz0jQdFB1b1fOZmz1jvRWRMzu7r3u5qvit18/kTRNsd895b8OkVZV1UA9In6wNn840cDRb0wTGmlMlaTVD3GdJ9jkbUSaN5U1brrk1kih5xWVDpeXfOQTeQMtfhQDPCILkmhksvDq4hGpSaKRqcIjIhUekZokGpkgJX6UJXhEAGJAJihADIg0gBgQaQAxINIAYoBHBCAGeEQAYpCtR2R7KZ7QwEfUOtl6RLYeac2ThGq1UqpzFcynEbNPza1CrraUrqM9rSnWKT6Y6qXvSM0i0gJk6xFZI9LCzz57qd/uoVJkdKTc4AsZD9l6RLYbaXbFSudW9uALyYIxekSEKZe4JZAOU04PWtWGm/Id7F+B/uftmuELyYfxeUT82x7xwKYf6d4Rd7IWHNM830b4Aio7djo6np412WExwBcyGEbnEZENGP6B1ju2lGJqBqcfaeqaRGB9ww0DoclCtaYQYFmkf6SJFoOuMa3NXldLKm8O9p/ae1WzvrEbnUckNB9ytjZDqJ+23xlpAUINtVL7lXcO99pCt0f4QpJhdB4Rq1hZ1KOhd2Dpq3gU70iPSMMXgi+ki/F5RCTLhbzmETBbiJFWF9XmTcJJN4s0b95r3HT5L6ZYlbQQJR0utF89kTfQ+pEmv6pEWpA8PCKwDfhT6+ARga3BIyIB8IjANijxhXSARwQgBmSCAsSASAOIAZEGEAMiDSAGeEQAYoBHBCAG2XpERNZID80JPpnegGw9IiKBSGseIAxlqGmP46vX42eoWluFFG0pS8dpmHi42H6vpJqaVJ+eSFuXbD0iIlqkoQmBTcnWIyLSY/aod25lD5oQqKp0PSKd2TeSYqScHkyK0kjjr48zJk8dkRbof94uNCHQkpZHRCqvbvezjI1OsIgxN21KjzQ0IdYxaEJWJimPiFg+9G5siw+souLvTaSpaxKB9Q03DATfglAtmpBMSNcjUpfXti+PWS/SAoQypK2M/tAqXnsImpBMSMwjIr2ja9uXv9pLbGtFGpoQNCEbk5RHZJUVESP+ms6w/piGJsSebqAJWRk8ItAb/pIbgEcE+sIjIpuARwR6UKIJ2RQ8IgAxIBMUIAZEGkAMiDSAGBBpADHAIwIQAzwiADHAI2LS5wnjwLF8rDsAhvr5Oh4Rk9QjrXkMEtmJcv37A4+ISdKRhuxk0OARMUk60gz0zq3sQXayc/CIOPOS3lkz7qSqnB4YWg8rrdKf/YSbIZ9PznxRXiat/3m78pWddFzstsEj0sMjIr+ZSqli7tzK7BtmHmW4GZKlo880CdlJ1fUy7k92gkfE/L1UPCJOPeIf2Qmqus023pVov/tvx14b9DWJwPqGGwZ2frpWLbKTzcEjYv4evk8zFg76R5rQGbqaIVs6vDaEUIcoYweyk6jgEam6I21WFO5NpNn9ysLtFE3/snppOW0uPNgMNxqW/cZrg/cy++IFZCfNzuFHGh4R6wTCAoUfP8Y7uXBT3tkM0dIhtcF/oYUXc7NI8ybA5oqT2Bop9Lyi0uHyko98Im+g9SNNfhkHHGl4RCAlhtrd8IjAqBjqIyJ4RGA0lIOWneARAYgBmaAAMSDSAGJApAHEgEgDiAEeEYAY4BEBiAEeEYfu9JH91tfNYD+7zRs8Ig4RI619HlB+4F9+xtNAymfe+wsIMhl6RMLPrESLNNHPYR0XethBNHbAgMnQIzKQSOsoFIw0XQoCQyUlj0gPmYdxLjcBxTALWFM2p4ZS0oHolyBnetipJn3yNt1LNtM01YiTI623SIMwjUk6HpFeMg/HEqGaJMzWCMlUrg5EuwSxfif7s6tDW4myAn1VBVaFQxRpZE46HhFXVSB2NCEcQyaJnpIC7RLE+lWrhnM5zbFbURWor8FwRBqZk45HxDhcl3kIvSxkktgw0sT61UhzkdZBREKZ4KFIG5hII3PS8Yj0knmoUhfFJNFTB6Jcgly/Wac+aImXacxXZ960ukNVMHiRRuak5BHpIfMQBp/ljM0Qciy3uksmAR2Idgly/dYiS6GLO2zqQdKcKtuTzVUjbWAijczBI9KHpC4hqcbmAx6RPqR0CTwiMkzwiPQhkUsYtkgjc/CIAMSATFCAGBBpADEg0gBiQKQBxACPCEAM8IgAxACPiEP6HpG0yOaDdjwiDjEjrXm4Uf2sWTaFhLPeZD2JkLOjnkJ4wFQ8XGy/V9J7wlP+hsGxg0fEIVqkzZrvwJTTZ3RTiJE4JJ1P0JMY3dnLNHCrUnKRvMPF9isnsmrK9BEWPCIO+5g96p1bS8Gb9mplfbSXudqkr3mnkAZR+XCp/V0lc55K4xHZv0ckLKrz9Q3TsrcHqLlou3FqquqsmBhX375C+uHWlnBJNSUvC+sJHpH9eUTqjhWWiLg3RlJit1a5mJEWijTj6pvLVw/32r/Ciax2ZmE9wSOyT49IU6SXk8f4j/2rW62b6d1/TLP3Lf/XY0xr/0RqSeXNQfBRKH+sxMEjsjePiHJSbYfRCYPzUmElwsvNdtYKndmjEGn64VYdgZLaJVq3jWO2nuARcWpQI024BLl+b3VP62FmofY8XQuBwe3Kqxd6c/FWRMzu7v1JzD+T3379RNIMxn5j7f5jpQ0eEacGfUzbrkdEvf/fLNK8D6/saz7w73mk0POKSofLi0HyibyB1o80+cXMKdLwiIziEoZKNi8tHpE+jOASBoo3io8WPCJ9GMElDI8yL+sJHhGAGJAJChADIg0gBkQaQAyINIAY4BEBiAEeEYAYJOsRyecjTxgFw/aIOFmaWjGAwTNkj4ioxABIklQ8IjkbKGAMJOIR8ce0bPwTMA5S8IhYeZjmxiz8EzAOhuwRqbfm7Z+AcTBoj0hoHSQb/wSMgwF7RMRgyc8/AeNgwB4RUYmRn38CxkGyHhFCCZIiVY8Ij4hAWiToEcnMPwHjAI8IQAzIBAWIAZEGEAMiDSAGRBpADPCIAMQAjwhADIbnEakq47slR/ckCJ+458rwPCJVNYhICyhM3AJ+A9Uv2iXSsmWYHpG9R1qXwiQkWzCCCf0J1AzTI7L3SHMa40SV/W3QDlaTh9B+GAQ794iY2Wn1W3w5PZgU5TLZZbnBmmw5kdbhILG/xNwpWU4XX4Frl5S/OVZEVJi0VUpfSW+3UswsVxqB/mS0RPCI1L2t7XRGT1rEizuAWZGmOEisqFmmjgpCkXJq1e+mdXcgKkyMKv37LqduPdLQn+RFBI9IVceTeesT/l2bPRpmBBt9sBK/Id5pT2XU6AyQ0shiR48bS/3HNPQnORHBI1LtJNL8EJCFImKkGQcos7QOhUk40uxotapBf5IrETwiy75nL8mtEGmag6TpkeU0IBSRIm1WFCG5ZJfCxJwyWjNSR4TiyFHQn2TNzj0ihpen6VErjmmig0RZTvCEIvKYFvowzNptlLJuybwKzL1tQ8ymoT/JmggeETAglHIlgkcEWnhEJFsieESgqir0J7mDRwQgBmSCAsSASAOIAZEGEIP/BwjkFCdaZz9CAAAAAElFTkSuQmCC" alt="" />

模板xml

student.xml

<?xml version="1.0" encoding="UTF-8"?>
<excel id="student" code="student" name="学生信息导入">
    <colgroup>
        <col index="A" width='17em'></col>
        <col index="B" width='17em'></col>
        <col index="C" width='17em'></col>
        <col index="D" width='17em'></col>
        <col index="E" width='17em'></col>
        <col index="F" width='17em'></col>
    </colgroup>
    <title>
        <tr height="16px">
            <td rowspan="1" colspan="6" value="学生信息导入" />
        </tr>
    </title>
    <thead>
        <tr height="16px">
            <th value="编号" />
            <th value="姓名" />
            <th value="年龄" />
            <th value="性别" />
            <th value="出生日期" />
            <th value=" 爱好" />
        </tr>
    </thead>
    <tbody>
        <tr height="16px" firstrow="2" firstcol="0" repeat="5">
            <td type="string" isnullable="false" maxlength="30" /><!--用户编号 -->
            <td type="string" isnullable="false" maxlength="50" /><!--姓名 -->
            <td type="numeric" format="##0" isnullable="false" /><!--年龄 -->
            <td type="enum" format="男,女" isnullable="true" /><!--性别 -->
            <td type="date" isnullable="false" maxlength="30" /><!--出生日期 -->
            <td type="enum" format="足球,篮球,乒乓球" isnullable="true" /><!--爱好 -->
        </tr>
    </tbody>
</excel>

Java解析XML导出模板Excel

package CreateTemplet;

import java.io.File;
import java.io.FileOutputStream;
import java.util.List;

import org.apache.commons.io.FileUtils;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.hssf.usermodel.DVConstraint;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
import org.apache.poi.hssf.usermodel.HSSFDataValidation;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.util.CellRangeAddressList;
import org.jdom.Attribute;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.input.SAXBuilder;

public class CreteTemplate {

    /**
     * 创建模板文件
     */
    public static void main(String[] args) {
        //获取解析xml文件路径
        String path = System.getProperty("user.dir") + "/resource/student.xml";
        System.out.println(path);
        File file = new File(path);
        SAXBuilder builder = new SAXBuilder();
        try {
            //解析xml文件
            Document parse = builder.build(file);
            //创建Excel
            HSSFWorkbook wb = new HSSFWorkbook();
            //创建sheet
            HSSFSheet sheet = wb.createSheet("Sheet0");

            //获取xml文件跟节点
            Element root = parse.getRootElement();
            //获取模板名称
            String templateName = root.getAttribute("name").getValue();

            int rownum = 0;
            int column = 0;
            //设置列宽
            Element colgroup = root.getChild("colgroup");
            setColumnWidth(sheet,colgroup);

            //设置标题
            Element title = root.getChild("title");
            List<Element> trs = title.getChildren("tr");
            for (int i = 0; i < trs.size(); i++) {
                Element tr = trs.get(i);
                List<Element> tds = tr.getChildren("td");
                HSSFRow row = sheet.createRow(rownum);
                HSSFCellStyle cellStyle = wb.createCellStyle();
                cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
                for(column = 0;column <tds.size();column ++){
                    Element td = tds.get(column);
                    HSSFCell cell = row.createCell(column);
                    Attribute rowSpan = td.getAttribute("rowspan");
                    Attribute colSpan = td.getAttribute("colspan");
                    Attribute value = td.getAttribute("value");
                    if(value !=null){
                        String val = value.getValue();
                        cell.setCellValue(val);
                        int rspan = rowSpan.getIntValue() - 1;
                        int cspan = colSpan.getIntValue() -1;

                        //设置字体
                        HSSFFont font = wb.createFont();
                        font.setFontName("仿宋_GB2312");
                        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);//字体加粗
//                        font.setFontHeight((short)12);
                        font.setFontHeightInPoints((short)12);
                        cellStyle.setFont(font);
                        cell.setCellStyle(cellStyle);
                        //合并单元格居中
                        sheet.addMergedRegion(new CellRangeAddress(rspan, rspan, 0, cspan));
                    }
                }
                rownum ++;
            }
            //设置表头
            Element thead = root.getChild("thead");
            trs = thead.getChildren("tr");
            for (int i = 0; i < trs.size(); i++) {
                Element tr = trs.get(i);
                HSSFRow row = sheet.createRow(rownum);
                List<Element> ths = tr.getChildren("th");
                for(column = 0;column < ths.size();column++){
                    Element th = ths.get(column);
                    Attribute valueAttr = th.getAttribute("value");
                    HSSFCell cell = row.createCell(column);
                    if(valueAttr != null){
                        String value =valueAttr.getValue();
                        cell.setCellValue(value);
                    }
                }
                rownum++;
            }

            //设置数据区域样式
            Element tbody = root.getChild("tbody");
            Element tr = tbody.getChild("tr");
            int repeat = tr.getAttribute("repeat").getIntValue();

            List<Element> tds = tr.getChildren("td");
            for (int i = 0; i < repeat; i++) {
                HSSFRow row = sheet.createRow(rownum);
                for(column =0 ;column < tds.size();column++){
                    Element td = tds.get(column);
                    HSSFCell cell = row.createCell(column);
                    setType(wb,cell,td);
                }
                rownum++;
            }

            //生成Excel导入模板
            File tempFile = new File("e:/" + templateName + ".xls");
            tempFile.delete();
            tempFile.createNewFile();
            FileOutputStream stream = FileUtils.openOutputStream(tempFile);
            wb.write(stream);
            stream.close();

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    /**
     * 测试单元格样式
     * @author David
     * @param wb
     * @param cell
     * @param td
     */
    private static void setType(HSSFWorkbook wb, HSSFCell cell, Element td) {
        Attribute typeAttr = td.getAttribute("type");
        String type = typeAttr.getValue();
        HSSFDataFormat format = wb.createDataFormat();
        HSSFCellStyle cellStyle = wb.createCellStyle();
        if("NUMERIC".equalsIgnoreCase(type)){
            cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
            Attribute formatAttr = td.getAttribute("format");
            String formatValue = formatAttr.getValue();
            formatValue = StringUtils.isNotBlank(formatValue)? formatValue : "#,##0.00";
            cellStyle.setDataFormat(format.getFormat(formatValue));
        }else if("STRING".equalsIgnoreCase(type)){
            cell.setCellValue("");
            cell.setCellType(HSSFCell.CELL_TYPE_STRING);
            cellStyle.setDataFormat(format.getFormat("@"));
        }else if("DATE".equalsIgnoreCase(type)){
            cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
            cellStyle.setDataFormat(format.getFormat("yyyy-m-d"));
        }else if("ENUM".equalsIgnoreCase(type)){
            CellRangeAddressList regions =
                new CellRangeAddressList(cell.getRowIndex(), cell.getRowIndex(),
                        cell.getColumnIndex(), cell.getColumnIndex());
            Attribute enumAttr = td.getAttribute("format");
            String enumValue = enumAttr.getValue();
            //加载下拉列表内容
            DVConstraint constraint =
                DVConstraint.createExplicitListConstraint(enumValue.split(","));
            //数据有效性对象
            HSSFDataValidation dataValidation = new HSSFDataValidation(regions, constraint);
            wb.getSheetAt(0).addValidationData(dataValidation);
        }
        cell.setCellStyle(cellStyle);
    }

    /**
     * 设置列宽
     * @author David
     * @param sheet
     * @param colgroup
     */
    private static void setColumnWidth(HSSFSheet sheet, Element colgroup) {
        List<Element> cols = colgroup.getChildren("col");
        for (int i = 0; i < cols.size(); i++) {
            Element col = cols.get(i);
            Attribute width = col.getAttribute("width");
            String unit = width.getValue().replaceAll("[0-9,\\.]", "");
            String value = width.getValue().replaceAll(unit, "");
            int v=0;
            if(StringUtils.isBlank(unit) || "px".endsWith(unit)){
                v = Math.round(Float.parseFloat(value) * 37F);
            }else if ("em".endsWith(unit)){
                v = Math.round(Float.parseFloat(value) * 267.5F);
            }
            sheet.setColumnWidth(i, v);
        }
    }

}

结果:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAwQAAAC1CAIAAABu56/4AAAdaklEQVR4nO3d3WrjaJ7Hcd9KneQicjzUmY+WZWFZ2Ibp1S7D9sC4GoYeZmCanQtwk6YPBuqwocFJKokrKptMTCYeT4yDcSZROpiwu9XdVdWvs5AryB7IlvXySHpkW3/pkb8fQtOJHSX1kx7pF73WHgAAADZYrehfAAAAoEiUIQAAsNEoQwAAYKNRhgAAwEajDAEAgI1GGQIAABuNMgQAADbaGsrQ/f396hNBJmQuj8zldTodB7I6nU7Rs33jsG6RF818DWVoOp2uPhFkQubyyFzeq1eviu4GG+fVq1dFz/aNw7pFXjTzNZShL7/8cvWJIBMyl0fm8mzbLrobbBzbtoue7RuHdYu8aOZrKEOO46w+kQK0G1tb9Z2bon+NpRiW+c1OfSvEvOQNy9zlT77RLvq3yez4+LjgapDNF+8/e/rE//HpF0X/SpkdHx8XPduzUKxbzFvWHePWLarYzQo9mvmSZej169fe///tb39b+hcqzs1OfavRaBg2A+cMy/xmpx4Kut0wbeyYlvlDKOSbnbpxkT+8fPmy4GqQzRfv+wvQXz75mYF96OXLl0XP9iyi6xYDmbduMT/2aObLlKHXr1//9a9/9T6dTCar/E7FcOelsXPUsMwVObcbpu0cMizzaN+82amblrnZZchxnn/69Mmz9z7+S4G/UmaUIXmmrVuqEHs088xlyG1C/jI0Ho9X/b3EebPSvG3yw8ODcZkr9wyZNpQMy9zAfW9R7Xa76G6QSbgMOccfPXn29H2jjvW120YtNeZvlR+MW7c8VCH2aObZypDXhPxlaDQareFXE+WrQGa2IcMyVx1gNi51wzI3c8EOOTo6KrobZKIuQz/7vFfcr5TZ0dFR0bM9C+U5Q6Ztpg1btzyoYjc/8wxlyN+E/GVoOByu57cTE9hOGPkXtGGZR/+MMPCQjWGZV6IMHR4eFt0NMqlCGTo8PCx6tmdh/i6KB+PWLQ9ViD2auW4ZCjUhfxkaDAZr+wUlmH8evHGZq88ZMix1wzI3L2CFg4ODortBJlU4THZwcFD0bM/C/K3yg3HrlocqxB7NXKsMRZuQvwz1+/11/o55q8ReCuMzN3DHhWGZK9qQef3oxYsXRXeDTKpwAvWLFy+Knu1ZmL9VfjBv3VKF2KOZp5chZRPyl6E///nPa/4186TcIBi3ZTYr8+jIMbB/mpb5bBeol3LwM0OYXYbMvLSeMiTPuHVLBWKPZp5ShuKakL8M9Xq99f+meYmpPab9zWxU5sojkyal7TIsc1e7YXLkD/v7+0V3g0yqcNPF/f39omd7FuqbLhq2sJu3bjG/DEUzX8MdqP/0pz+tPhFkQubyyFze3t5e0d1g4+zt7RU92zcO6xZ50czXUIa63e7qE0EmZC6PzOXt7u4W3Q02zu7ubtGzfeOwbpEXzXwNZYinHMsjc3lkLu9J6KgTHyIfRc/2jcO6RV4089p0Or27u7u9vXUc5/r6+urqajKZjMfjy8vL0Wg0HA4vLi4Gg0G/3z8/Pz87O+v1eqenpycnJ91ut9Pp2LbdAoAcFF4LNvOj6NkOFGANe4ZardYjAACACRzHCX2FMgQAADYIZQhArFqtVqvVov8f95WEiaS+M+5tq3wvAOigDAFIktCH4vpHqJpk6kz+bw9J/RbN30p/+gk/EUCVUIYAJInrGQm1QLMzJX+X/u+mWW70f2Gdn5Lp9wRQcpQhAJnptAfNT3UmmOm74ia1dBla7p0ADJKxDOndcpsyBFRA8n6XhD0l+X2L/nct8c/RzyR7lgBKLVMZch9rRBkCNoLmhj/0trjKkjqFJUqG8ruSy1DWqS3xHgDG0S1D7sPv6o0Ge4aATbBcE9L8inIi3nvWsrNniX+Rzhv++Mc/0oeA6tEuQ+32zQOHyYCNs3rhiBad0KtHR0fLNYzUH6f/b0n4R/m/nTIEVBLnDAHIRqcNZO0c0cKk372ydpol/jneOylDQCVRhgDoWqJqPGYpTyv8asvT/NHRupbz7wVADmUIgELqrh39PTFZy9BafoTOBDP9oOgEk/9FAAxCGQKga7kSsFwZSp6C95Xo/yT/XM23reW7AJiCMgRA17rKkM6OHM33J7cinT6U+o+KewN9CKgMyhAAXZq9QZ9yyku8Wfk7xP3CmcrQKq8CMAWP4wCQrrbCBfCa00/tN8nfG9eckn9owj9Kc1KZfiKAcqIMAdBSyU1+Jf9RALKiDAEAgI2mKEPT6fTu7u729tZxnOvr66urq8lkMh6PLy8vR6PRcDi8uLgYDAb9fv/8/Pzs7KzX652enp6cnHS73U6nY9t2q9VyAAAAzMSeISM5kVaLvJG5PDKXR+byyFxeNHPKkJEYPPLIXB6ZyyNzeWQuT6AM3Te3t5v3gc9rgS8svhzDsvP5x1dJYEbeN7cjmam+tnhJNUeQIjJ4bEtrWQ2PiEfbIn5NwcyjgUcX88iKJZC15izbaPEbZs0FN7LA+6cQt9b3fYdvps7nV+D7Kjh6spWhRRrznHyRKyNmoY/SLkM3O/WtmdQbDQXKkHLpVSzHcQOGtZWWwIwMrKNmwcaWIduq5NpEQGjw3De30xZVdyZ4m+dZ7LbF2klXbBmKXcxDX5mNjflXWb2k82ceXE0HVjThKBfjIbkMKfNfTFm14bDsxesJEzdYTBmK2Ypa9uOjbdUSZkZwEhUMbA00y1C74XWgdmNrq75zo1mGFmsi1dzxL8fsGVpJaIXli2wWvLoMaf1hBrXg4ElYgL2F2CtD/nRta7t5z84hPZEyNFtS55lShtZvuTLk2zivVIYeY/YMbWQZenwM7sifhxzZua9en9w3t9mcxtIrQ+2Gr/+k34V6UYbcWXLf3K5ZFnuG8jSfkcF2Y9nKuuMG7b6iCD34NwbihDYSgeVUvTgrytB8RV/NdfraLTK3rZplWTXLvm9aTVvZRL3thPKrlCFNy5QhnT8NIt/kEy5D4e/dzMNk8X+7+qIIvSkwTyqY1Poscc6Qby9RWhmaz5bt5j1rnXz5ZqR/Pd/076oObawXq5XgfiTmkyZf5pGlW7HiUWwfrGZze7vZ9HZWEH0aL/N7N7n5Xs95cuwZWr9w6U/vOKFDMewZyiy2DPlqZOSfvYhi/qLqhAnEyFyGbnbqaUfJQucMNb0TI5R7hyw75Y+IaMNFVGDD7A0Ey0rYSnhmxYhTVzLyb5hj9sF54vZ6ul9n06zLy9y23EU2tKctZjGPfJnE9WmeQO1FGdnoruEE6vCGYCPLkNaWcnb+kHdYPu2QDOaylaGbnbrG+dP+MrTYN9S0apZlbTfvvUMF3n99b2bFtCT/4QPvKFhoV1BsuO4gI/uMQoMnfJggurqZvcO24k/iQrLMV5Mptrb+9FnnpAvudY6c7ub7LCZL9gxllnI1WfJi6+UVnD/VTGp9MpShm5166qnT4TK02F167x0PiC1DnEO6Av9fzP61ffJ1lQl/ajAvUi1ZhnzXPTUTL/tGlLoMJVxkM3+j75RTylA2y5Sh5J0Yi+9asgwFJ1/BUZNYhuJ2p81y8I4aR/8ermBS66NbhjT3CUX2DHnme7WX2jCzukqlOK6vPi4wMzt7elt9mgrDRsc8c73jvO6pjd4gsJpxJ3EhQfb7DIXeRxnKrNA9Q8rBZVlal6oZLL4MuVUndJFLZO2hujqmmkmtj14Z0jlRKK4MeQuzZbtLePxhMiXmoBbFJcfBoZC6lfAjdB1Jf73F7Rmq1Xx/2QZPNGKjrGGpMhS8HVF4o0HuKQo/TOa/QVfk0stqrqsS7jPka4GLU24jIc62uxwm06dVhtqNrZAMV5N519bbj8uUIS6x0RO8sil8jc0j9xnKwZJlKLzH8765Tdy6lrsDdeCwTOh+LKxe0gTLUOLuz2XKUOoKyL8isy33/NPAqxUcPKp1S2hbGJgXkcMAbkKBi4OrmdT6iDybzJsJ/rqvaK6BF/iDORPfIZvYyzAUmbJnaAWZy1D4HcGLB0hcg6oMJW1Qm7670vmX/egDDBBH99EQKWdwKbuO1h2oYw74z+dpFQdObOaLcMOlfr48NyP7D7yFv4pJrQ8Paq0IHuwnj8zlkbk8MpdH5vIoQxXB4JFH5sKePHvKR1EfRc/8zcK6RZ6iDL169cq2bdu2j4+Pj4+PX7582W632+320dHR0dHR4eHh4eHhwcHBwcHBixcv9vf39/f39/b29vb2dnd3d3d33ZHjAMBaFV4INvmj6JkPSKut+P1P+DOiCA5/SYgjc2GsWwrx5NnTTz57nvWj6N/abKxb5EUzpwwZicEjj8yFsW4phFuG/vurb/U/KEMrYt0ijzJUEQweeWQujHVLIdwy9D9ff6f/QRlaEesWebplqPv5e/ODxx89pwyVD4NHHpnnyX+31hnWLYWofhmKu4NP+MaP0ZsxKL+YNv3Ia9EpsG6Rp1eGjj968uzpk0+/cJwv3n/29MkfPulShkqGwSOPzPPj3S3Of9s41i2FcMvQ/37zvf6HUWVocWN471PvgZr+uz1GF0jlF9OmH3lNNQXWLfJ09wzN9T7+Q8rOIVZYhWDwyCPz3NiBZ0/NtxKsWwrhlqHX33z/Oq0DvZ5/mFKG3N0y25a1aD2BvTjecqhcINVLacr0A2KnwLpFXtYy9MX7s11ElKFyYfDII/O8qDdIlKFizMrQmx9ev/nhta/xKD7c97z5wZgyZNvhXUDKZU//i6nTD7wcOwXWLfIylaH0JkQZKgqDRx6Z54UyVCZuGfrq7Q9fvZ11nd/+/r/cj49++/sPf/2bD3714b//4oPXb35w3/PVW2PK0Ex4efM/NTD6nMcMZUg1/YSfSxkqUtY9Q87zT58+efbex3+hDJULg0cemeeFMlQmbhn6+u2PX7/90as7v/ndxx/++je//NWH//GLD977+b+5X3Tf8/XbH00uQ/6HntmzFyhDGyBzGXJPpv7Z5z3KUKkweOSReV4oQ2UyK0Pvfvz63Y9e3fn67Y//+ctfvfdz65//5V8XX3w3+zC7DC1kPkwWfiBwZPqBN1CGymTJMvT+MXuGyoXBI4/Mc8MJ1CXilqFv3v30zbufvLrjfvzDP/6T/1P3Pd+8+6kiZSjlXOn0E6hTps8J1GWiVYbcmwy5e4Oef8rVZGXE4JFH5vnh0vrycMvQm29/evPtT17dUX6473nzrdFlaFFQUq+i17u0PqkqcWl9eejuGXr+qffEvqQThihDRWHwyCPzPLl3Z+Gmi8WblaHv/q7/YXIZ8i16gbOAFAtkzBfTph+gngLrFnm6ZUgfK6xCMHjkkbkw1i1F+eSz52+/+7v+h2FlqHxYt8ijDFUEg0cemQtj3SJsfjTg6SefPX/3/f/pf1CGVsS6RR5lqCIYPPLIXBjrFmGUoaKwbpGnKEOvXr2ybdu27ePj4+Pj45cvX7bb7Xa7fXR0dHR0dHh4eHh4eHBwcHBw8OLFi/39/f39/b29vb29vd3d3d3dXXfwrNioACDkybOnNRii6IUFWFXtYWWtVquQZrfJHP6SEEfmwtwyVPRvgXTMphWxbpEXzZwyZCQGjzwyl8dW1gjMphWxbpFHGaoIBo88MpfHVtYIzKYVsW6Rl7EM3ezUtxptylD5MHjkkXmevOcWBO6/Et3KevdpUUi8+QvyY1gZink2WfA+Q8oFUr2Upkw/8lp0Cqxb5GUrQ+3G1hZlqJQYPPLIPD9xd+ZVliHv9fvm9mL75X8BsowqQ26dDjy13l2K/B1mhTtQh6YfeY07UJdDljLUbmzV6+wZKicGjzwyz03sM5vYM2QEU8qQu1tm27IWy5j60RxLPptMMf0Ank1WIvpl6Gan3mhzmKysGDzyyDwv8U/zZs+QEYwpQ7Yd3gWk/YD6hKU0afqBl3lqfYnolqGbnXp954ZzhkqLwSOPzPOSsQyxZ6hsTClDM+HlbfaJu1/HspcvQ6rpJ/xcylCRNMtQu1HfuXngBOryYvDII/O8LLtnSO8F5M7kMrQ4p3m7ac9eoAxtAK0y1G7MGxBlqKwYPPLIPC9ZylDw26g/pWB2GVrIfJjMuzYscs3Z7PPAGyhDZaJThtqNrbDkQkQZksfgkUfmudE+gTrpIBnHyQpTkTKUcq50+gnUKdPnBOoy4T5DFcHgkUfm+dG/tN4TOHt69gXKUDFMLkOLgpJ6Fb3epfVJVYlL68uDMlQRDB55ZJ4nb59Pyk0XF28Ob25sK/4sDuTK5DLkW/QCy49ygVQvpSnTD1BPgXWLPB7HUREMHnlkLi+0lZ2fgaHaknGQrDiGlaHyYd0ijzJUEQweeWQuj62sEZhNK2LdIo8yVBEMHnlkLo+trBGYTSti3SJPUYam0+nd3d3t7a3jONfX11dXV5PJZDweX15ejkaj4XB4cXExGAz6/f75+fnZ2Vmv1zs9PT05Oel2u51Ox7btVqvlAMC6sZU1Qq1WK3pJAVbFniEjOfwlIY7M5VGGjMBsWhHrFnnRzClDRmLwyCNzeWxljcBsWhHrFnmUoYpg8Mgjc3lsZY3AbFoR6xZ52mXoZqfu3X/afU4ZZahMGDzyyDxP3nMLdO4z9PiY8nQoiDKsDMU8myy4PCkXSPVSmjL9yGvcZ6gMtMvQ4vlk7BkqIwaPPDLPT/Y7UNOFSsSoMuTemSrw1Hp3SfJ3mBXuQB2afuQ17kBdDrplqN1I3R9EGSoSg0cemedG+9lk/u/gHoulYUoZcnfLbFvWYhlTP5pjyWeTKaYfwLPJSkSzDN3s1PW7EGWoAAweeWSeF92n1i8eAc6zWkvFmDJk2+FdQNoPqE9YSpOmH3iZp9aXiGYZaje26vW63hlDlKEiMHjkkXledMuQJ7xfiGe0FsuUMjQTXt5mn7hd27KXL0Oq6Sf8XMpQkfTK0M1OfdGB0s8eogzJY/DII/O8ZCxDqufVc/5QkUwuQ4sdjttNe/YCZWgDLHFpffrpQ5QheQweeWSel2xlKHK6EOcPFc3sMrSQ+TDZ4sBt+Jqz2eeBN1CGyoQyVBEMHnlknpssJ1Df39/PtjCWHXk/ClGRMpRyrnT6CdQp0+cE6jLRK0PtxpZ3aEzjXGrKkDwGjzwyz0/2S+sf59cwU4WKZ3IZWhSU1Kvo9S6tT6pKXFpfHrp7hnz3XEy/3RBlSB6DRx6Z52nWbPRuujjbNeRdBk0nKpbJZci36AXOAlIukOqlNGX6AeopsG6Rx+M4KoLBI4/M5cVcWq86d9W2aERFMawMlQ/rFnmUoYpg8Mgjc3lsZY3AbFoR6xZ5lKGKYPDII3N5bGWNwGxaEesWeYoyNJ1O7+7ubm9vHce5vr6+urqaTCbj8fjy8nI0Gg2Hw4uLi8Fg0O/3z8/Pz87Oer3e6enpyclJt9vtdDq2bbdaLQcA1o2trBFqtVrRSwqwKvYMGcnhLwlxZC4v9ekbKImilxSzsW6RF82cMmQkBo88MpdH5vLIXB6Zy6MMVQSDRx6ZyyNzeWQuj8zl6ZehxZ2GUp/UShmSx+CRR+Z58i6b5/4rBat+5jHPJgvesUG5QKqX0pTpR15jOS8D3TLUbsxLUOChrZShsmDwyCPz/HBn3vKoeububQ8DT613W5C/w6xwB+rQ9COvsZyXg2YZSn8eGWWoWAweeWSeG57ZVCIVztzdLbNtWYtlTP1ojiWfTaaYfgDLeYnolaGbnbrGUzgoQwVi8Mgj87zwNO8yqXDm97Yd3gWk/YD6hKU0afqBl1nOS0SvDLUbW/Wd9vykodRaRBmSx+CRR+Z5YSNRJtXPPLy8zT5x9+tY9vJlSDX9hJ/Lcl4k7TLknTe9OHuIMlQiDB55ZJ4XNhJlUv3MY06g3m7asxcoQxsgw56hef9JP2ZGGZLH4JFH5nlhI1Em1c889mqvzIfJvGvDIteczT4PvIHlvEyWOGeIMlRGDB55ZJ4bTiwtkepnnr7nZskTqFOmz3JeJhkurfcdJks5a4gyJI/BI4/M88Mlx+VR/cxj9tCkXkWvd2l9UlViOS+PZW66yAnUJcTgkUfmeXLvzsLN6IpX/cxDZcVb9AJnASkXSPVSmjL9AJbzsuBxHBXB4JFH5vLIXB6ZyyNzeZShimDwyCNzeWQuj8zlkbk8ylBFMHjkkbk8MpdH5vLIXJ6iDE2n07u7u9vbW8dxrq+vr66uJpPJeDy+vLwcjUbD4fDi4mIwGPT7/fPz87Ozs16vd3p6enJy0u12O52ObdutVssBAAAwE3uGjOTwl4Q4MpdH5vLIXB6Zy4tmThkyEoNHHpnLI3N5ZC6PzOVRhiqCwSOPzOWRuTwyl0fm8vTKULuxFZT8cDLKkDwGjzwyz5P33ALuv1Kw6mce82yy4H2GlAukeilNmX7kNZbzMsi+Z4g7UJcSg0cemeeHO/OWR9Uzd297GHhqvduC/B1mhTtQh6YfeY3lvByyliGNKkQZKgKDRx6Z54ZnNpVIhTN3d8tsW9ZiGVM/mmPJZ5Mpph/Acl4i2crQzU495QgZZaggDB55ZJ4XnuZdJhXO/N62w7uAtB9Qn7CUJk0/8DLLeYlkKkPpz6unDBWFwSOPzPPCRqJMqp95eHmbfeLu17Hs5cuQavoJP5flvEhZypBuF6IMFYDBI4/M88JGokyqn3nMCdTbTXv2AmVoA2QoQ9pdiDJUAAaPPDLPCxuJMql+5rFXe2U+TOZdGxa55mz2eeANLOdlkqEMtRs65wtRhorB4JFH5rnhxNISqX7m6XtuljyBOmX6LOdlol+G9HcMUYYKwOCRR+b54ZLj8qh+5jF7aFKvote7tD6pKrGcl4d+GdLfMUQZKgCDRx6Z58m9Ows3oyte9TMPlRVv0QucBaRcINVLacr0A1jOy4LHcVQEg0cemcsjc3lkLo/M5VGGKoLBI4/M5ZG5PDKXR+byKEMVweCRR+byyFwemcsjc3mKMjSdTu/u7m5vbx3Hub6+vrq6mkwm4/H48vJyNBoNh8OLi4vBYNDv98/Pz8/Oznq93unp6cnJSbfb7XQ6tm23Wi0HAADATOwZMpLDXxLiyFwemcsjc3lkLi+aOWXISAweeWQuj8zlkbk8MpdHGaoIBo88MpdH5vLIXB6Zy9MuQzc79S1X+t2GKEPyGDzyyFwemcsjc3lkLk+zDLUbW7PbT9/s1LfS7kRNGZLH4JFH5vLIXB6ZyyNzeXplKPAojvRbUVOG5DF45JG5PDKXR+byyFye5p4hXxvSeCwHZUgeg0cemcsjc3lkLo/M5emfQD0/aUjjAWWUIXkMHnlkLo/M5ZG5PDKXl+GcIbcFcc5QOTF45JG5PDKXR+byyFwe5wxVBINHHpnLI3N5ZC6PzOVRhiqCwSOPzOWRuTwyl0fm8jKcQM1hsjJj8Mgjc3lkLo/M5ZG5PG66WBEMHnlkLo/M5ZG5PDKXx+M4KoLBI4/M5ZG5PDKXR+byKEMVweCRR+byyFwemcsjc3mUoYpg8Mgjc3lkLo/M5ZG5PEUZmk6nd3d3t7e3juNcX19fXV1NJpPxeHx5eTkajYbD4cXFxWAw6Pf75+fnZ2dnvV7v9PT05OSk2+12Oh3btlutlgMAAGAm9gwZyeEvCXFkLo/M5ZG5PDKXF82cMmQkBo88MpdH5vLIXB6Zy6MMVQSDRx6ZyyNzeWQuj8zlaZch7z5DPKi1lBg88shcHpnLI3N5ZC5PswwFH9SacgNqylABGDzyyFwemcsjc3lkLk+vDPFsstJj8Mgjc3lkLo/M5ZG5PMpQRTB45JG5PDKXR+byyFxehsNkbhtyzx1KPlBGGZLH4JFH5vLIXB6ZyyNzeZlPoK7vtFPPGqIMyWPwyCNzeWQuj8zlkbm8JS6t5zBZGTF45JG5PDKXR+byyFxe9jKkcTkZZUgeg0cemcsjc3lkLo/M5emfMzTbG7Q4e4gyVCYMHnlkLo/M5ZG5PDKXp71nqN3Y4qaLJcbgkUfm8shcHpnLI3N5PI6jIhg88shcHpnLI3N5ZC6PMlQRDB55ZC6PzOWRuTwyl0cZqggGjzwyl0fm8shcHpnLU5Sh6XR6d3d3e3vrOM719fXV1dVkMhmPx5eXl6PRaDgcXlxcDAaDfr9/fn5+dnbW6/VOT09PTk663W6n07Ftu9VqOQAAAGb6f/T8+QMRiTtUAAAAAElFTkSuQmCC" alt="" />

注意:

如果一个里面有好几个sheet需要用同一个HSSFWorkbook对象创建sheet

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAnoAAACECAIAAACIzxEbAAAf+ElEQVR4nO2dPa/bOhKG/btcOL8i9S20cHHrtBenkXunCLCVO2+TIsUChtsAri6wwKnSuFKxe4r8CG0hWSKHM8MhLdmS/D4IAh9RJIcf5it+WLOqAQAAADAyq2cbAAAAACwfyC0AAAAwOpBbAAAAYHQkuf3fv7798Y+f/0sMAgAAAACDILe//vnp7Z+X1KCX4dPbH4OkIKVDrivZsUHGZDOyy7gtL51ByjUUefWjJGVJISOXUeshmrh+w4B1CMBM4eX28l2cvypB0+TT2x/Kv+w0U/NiU7CkEyYbTYTEYg1TypIht3old3eGH3T7s8tlt8dus27wIO2u5yJlFEZ5ZJ833kMKnm0GAPOFk9vf//7H21//+s3drgRNlegQkJdgNK4lX3YoJEOSNEJJ46wUxCYVFaG8AkbtZI2J3pOaVNRaizyk1k92u7PX2YyiKv6wPq/rOtvf7jEDgFnDyG31869P3//D3q0ETRZ23LRPMtjUws/6nZJJ7G3KFWW0YtOUys7WgCJpliFVL6zyWa/SvHLpZoSJSzVjrJ9oRkpZ9Jv162GFkD8f0+ejfVjvSKn2ADBTQrn9z+7tj90v9mYlaLoM+KSf9JCuDJfG8Ss6Y2Av1vKArtsfjn166cKbFZOihZXSySuXnkX0OpuXsX7uafdaaPRoKCu3SrnsWPq8foVVeqgseEECuV3cIalBnvSVsVJ6Qtd1lETXE4lKlyRLbkntWmhUL1177pHb+8tFEtR12iJgbInGa3cpHckYtp88ss/rrWy5AsDiIXK7wN//KNogjUqWEdyYbzTIMjNgjYnKkjEvJXG97PfIrWLVIOUiQbrN9r6hRzQaI92W1A/1gjy+z0NuAYjiy+2yDkk1RIee7DSz74lKhTRuZsutNJ7qCUYfBaQg3eakpw09olGTkopJZMkeUSqRkoJ+p1GSw/uf0uejdWKXdgAWiSe3l+9/SCehlKCJo4zLE5FbRS2U4cktF0nZIhisJVE7lQIaFV1PZMByWZ4Mon3DXj/6xTDonqcE6U97uTK4p88bqw6AZePK7dIOSTUYh7+h0kzNV08qdcAln6OzCoucSFOQqHAaizBGuXRTo9dZ2waXW+ke6TnDnvVT+rwi55BbAGpXbquff3369u+Ku0kJmj5zlFtFY6SIUhTLLFASKvujQOptimGDlMtigx6RVXRL9Ox2J89AunayVj1LbkMzoo9ikFvwgnRyu8BDUg36aDVGmtFZV96cySiWZNRWDFMs0SvHWHvsbVLEMPd7yqUkHr2eWj9DtTubOLmil9Go0FK+OvZuabEHcgteEHgEAgAAAEYHcgsAAACMDuQWAAAAGB3ILQAAADA6kFsAAABgdCC3AAAAwOhIcrvY3wUBAAAAj0eQ26X4BVJ+HMneJkU3Xg9DLSkYfyp6508Vwx+SZkS3GGPJAj+7BAC8GrzcXr6L81claJqwwmZ/uUT3IfoqA6OQu7LHSmBSXtH3HoRFzpC6JO03pg/FBQC8FJzcLtEvUEfSi3XuVyZpTnn/7JbIZyi9RNEtCs3CxlLWCaSMLI8RAACwVBi5rX7+JTn/UYImjnF812+zJMKqXS3LXh1Il6LEbFA0R/ZmO2GmkoX6c4OeNeQWALBsQrldlF+gUMPYD4r6Kn/WgdiEqsmKTTgHDW9gr7BmGwVeKkIUyXLWsGiNAQDAaxLI7VIOSXVI00pdNsKLxoVQXfyIPeydoRnhn3rK4Z/RSbmCZUod3q88wdxjDAAAzBQitwv8/U90dhv+aRQVacZpySWcAbOJKOJkn93q9kQfI/QHC71mokBrAQAvgi+3SzwklTq7rW3iJOWlT3alZMOLehQ25Qy5tSCZEZqty7aeMgAALBtPbi/f/5BOQilBEydjdqtfrAXdlVSTZBqdlbp36jdId5K8wnyTdM6i+m5GUgqWmTQAACwVV24XdUiqQ5rz6XIrzYCj2qBPUkNL2M/KPDW0xDL7HGN2y16xP7VAXwEAL0Uvt9XPvz59+3fF3aQETR/LsK7MzKT7lTkluU2KHs2dVVk2NT2d8J4k9Dmo8kSiP51AbgEAL0Untws8JFUbljFrTiBZqQhjKfNLi9Aqaqqszeap8j2Lt0kPExZlTTUAAAAWADwCAQAAAKMDuQUAAABGB3ILAAAAjA7kFgAAABgdyC0AAAAwOpBbABbNabvanp5tBAAyQRc9bVfr/VW6VwqaPpDbXE7b1WrGDT9jpl/zp+3qsRJ33a9XN7yaOW0nXlXApWnHxzSYmJfSe9WOnWk820Wv+7WUkxI0eV5Cbt3BaEWaKntknP6gPwFes+aH17jTVqjEutbGH94QrVHyzZvpADgObJOQeufqfzi5JV8SJmEpL6X36h07y3g5yVzVnzLLl9vTVh1SZtty0+dVa/66Xw+ptv7AGQ5PYnbsSBZplHwTF9mUuegV8oDqap/PbrmQPzWU3jtwx64j+r3AGe7i5TY208BIMRYvW/ODFiyoRTrmqWobmDHO4vJimzITXZcesMB/3a9X2+1tR/S63+6v1j3PR04qYwkuboK7eLltVjiYhmGXdvoO2fbOfhWvT8JZ2SPpNpGk8DDHaH95Lze7Y/Vebv7cNP/Kdzf4Ut6ub/4sjh/Nxeq425TnY9FebO9xIrqxyku8CjOZd80HIyYZJGmSfYLSWEuusxnQ2mCe4m+X3NuFamRKKTYKk5VfYr/A7Y2RpiSl6lK/7ter7b6J2zebefT0in6LpVVvWxeOtV1eShDNKqjbPtBrrwC+AcPaF27entrQ7oNbw1K32Z6u+/V6f63r07YtYNBowpczdXKrJkg6qntHXDKT9faRm98ZLF5ua6e9uVaQGrSN1EbhviJMTH/c8IYrLwXzil4rtK0oXg6bze54cxVRHXe9WF4O3W3VcdcIbfehvhw2m8Olruv641g40ludC4viciO7+Ul5pjVPM3GTvO7XsrCJ61xMgt6g7/+13l/5AS6m2pHrSqOQB4rAwOTVUb8qnL+6QbEfHa2zFbEBleq97ter9XrNdQ8lSGqUXl7cNOzn09je29weNlontG2zrb1pqmRh/8S6PbVpd7HkvLr80hZw1QS1qjCsTSeLP+R2InSPYH5baIO+PqoJg77wlQ/HZEufeC89OSR/8ndWx92mOFet7h4udd3LbXUuHMGum5muP2MenlnWPLnR+YsOOyRFaYBhbuMtdNScKSjJXRweY+XkGoU+UpAgWQ7lmUYgQ9uTG9Kbb5Nb+S6leoMpfaCcXJDYKOwxJNPyfjQ0LF5X792HfpqqdZtb7a7X667Gw5TDqlTkMWtzSOs3Y8jtxHkduW0gExN90E9e6Ig8YefNbkW5rc7Fpl8W3ljk9nLY+FHCBeqxmFnNi4IYUVvjbDOYRXk4WZG0aO5iZdlGI9IofaRweHYXSrl5MT90B9wlt0lq6y8/pGqI2CjsEw//VJFYBmFyS9Y5nGmq0m06Qe6fEISUIxZYgtTwvttE1mkSM4XczgHreDXKoM98d3Vkua3OhbNfa53d9qvKKWQvJnvMq+ZrZ4jytCec9aaXyouljBtBYlQdUuKyMI3SLkPq8zOLwBjEMU1uraUljZKjtglzUGp59uQ2XKkQRNZ/ZLHkEDw9CasiSitEGkhZhXZusK1vDWHPNHk1uQ1mN/KOxKCDPjNbsBCR2y6oOf0Ul1uyd/tIplvz3a4Yud7GJNJDtiDXa39wIwuy3nZvH8vLUJYDf4hiZuZaXVnGozDJ694908oTDOhCU8ZXumW5ZRtFXJvQqjdvhqQ3iracoQqPFuiuLWx9bfVEto0uWcg8KinT5i6vIE2n90aClAT1kse6aLratq0/VR1evNzSmZm0u05D5ZZm5nrMmmPwp7I6JaMtJjcnoW7Hkt+PhUVu61ZxgyXo4ZlNzbfh0mpocN1bHmOXErkS99fbWHTbjbfPNT7pIAofam0UeSE5pSmlkpnlNqh8Pz26ucxVryJw+oxMaBTD5oFbyYzAiC3WxXM2lsPFd7q0QvLivj7C8ynTllLv1YP4BJVebaqOrJabtt4uXm4nQtDho4svYBgWXPPR7StdjjMTBWA45C6auZDMPi5OBcjtQwiGeGYnA4zBcmveVJCEo2F9ohMdq8AiYbto9prEaSvMvicB5PZR0GU8jGmPYnE1fyuQaVQxnhroVv5mXztgboRdVDmqJwdNex25rmvILQAAAPAAILcAAADA6EBuAQAAgNGB3AIAAACjA7kFADyVE32rhvpSKwDmCuR20tz9kr5h8spDcagAnsXkehT7w0v8HgkskaXLbfi99b/eygt1xaDgLUX920zZ9/7cMWxMbnBMYZlyix41RF5unslvOQBgnry03CrvANBeD6C8rpMbHO+RsIkNjmm8oNyiRxnz6nPMeYcfALPkleU2x1PILfAVB8dUXk9u0aOseZkyxAQXLItXllvl7ZrqizelUcBz29Fnwb+ymzjbaL2e0WVGLr4zkdqenDTDFwNzeclBSl4SH8fCdQLY0Kls88HxiDCeJ6L//lx/flt9/XX6+rb6/Lb6/Lb68tOx/Pf+y+3657f1j991Xdf1r+3nt9XXX2E6txt40KOG6lFZrp+6lHCWCsyOl5DbAN+nGa8rclB0cOzf29m/nsxfS/Tfd9tm5fgBCdyPhC/I9V2meCKg5KUEKXmJXMpARKtzsdkdq7qR243gMVCE8fpjsKWRW//fTTU9rXWCfu+/EFWu67+/rz6/bf/WskKPGqhHGVZT+Fsgt2CmvITcKgdb+pv4IZILkpyY3UbC03a93zfTi9ul0Ax3JCEmOUH92B4dor2ZkJCXaoaSl0h13DVy23n9c5z90cVkRpuH4ia3rcT+/X3VzVybz52sOn+evr6tPn8/tR++7f9bX398az4ooEfVw/SobLkFYKZAbv1b+S93OHXg5iLt4ND8irD7vxuVSNJOKvKqWhPvxFnGDY6xvFQzlLxkLodNca7qj2NxKMvdsequ1LzctkFD08gt0dSvv+q6UVA6u23uvP74tvr8/dSsKn9+W//4fbuigR7l3ntHj4LcglcDcqvdywfpg+N+263/bU/u4KjPRbTB8cr5lRplLiLkJVOdi83hUp2L8r2+HIrjRzffzZzd3rOYzMktnd26/P199fnb/sf31Zefpx/fVl9+7r8KdzqgR9UD9ajcvVsAZgrk1gsw/YhDHAT8za/TdrVed0MPs8UVTzAYQslvNf2//J07Pi8lSMlL4b3c7MpydzsbdSjL7vCUL7eXw6bd0x0BRW5vk1dmW7c5GPXl2/rH7373lxyeCkCPGqxHZZ5MbteoocNgbryy3Eo7ZnpQdHAk51X8AayDnUaw5vd5e+MMObLDjGRCmBSk5KXQHDxuNmvrS+mcjaqdM8mb/p5R0OS2Dk9LeYeT27NR7T36seQaPWrIHiWvC9RcRXsh0FswO5YutwCA6SILrjb1bfQWcgtmBuQWAPA82BV3ZdP7FgVHqMDsgNwCAJ5J/1PiGyfxzVlYRwYzBnILAAAAjA7kFgAAABgdyC0AAAAwOpBbAAAAYHQgtwCAp3La4uyTfDoMLAfILZgYzksTXn4QfgHUV10QlulBuUH/7RNYBC8it94Lcwbo06kvc6Ve2+5+kA1+epjgNS+ViMu5kUh/X+7c37CbPODSN1XdW/igD43/OokUsb1Dbp2amvAccu4dGMR4BbmlP6Q/be/u01lyS16+d+f3PvAsOv5A8lAHLa8ntzmdir4m8s7yKy9KHoM0sc2VW/d3vY/5ouSCGe7CWb7cpn6lzYneIbfDfLG6oeNRYwjkdkySazco7wAV0EnsI/pUsr0DLCZPXNFm3oeBzuLlVlXb9nxCv9QUjF40gF1YDV43HyTH+ykTXjbvz1gaf6f8eqHgv5t8ZznHaul51bIgiEXe7hsD+3Qd3zZ6XtLAwxmf2SgW+Lfvt7Y5+Yodx68vamnv3y4g2mJhz/avsHl1tvdJihbSx0PeX31+XlwLfxyLzqNUR6eyzQfH9UXUn2OAWW7fy83uWL2XGz6vxhtH868zuDruNuW5Ma84frT3OBHdWPxzA9/tm/qd7KwcGFm63Bpevtp1Y/deP16QiuYajIvFmOGMjdf9mgiv593MG70YX97sRUlu78iLlVu9yKv1/toPFb0hfl5sI3FVLBsvxdAsjCEupl7369V6vWbrKvSsJyz4cw9B4rMMk6DQpZzKZ/O6CSN1SUsyTOhSuXnxD2+MU+TqXLSuG1vxa4WqOhfJk137pN3Py3cfWR13vmfJ9rbquGuEtvtQXw43X1gfx8IpmmQ8XyuQ22UAuWUHgKDTRyaMND69TZfb0ChXArVsyYCWYmxyXuxQoBeZeCD35TailPFlNUMiqoU6ym30BFHflCSSM7jTHsDND5nuICcY2teZoeVFjg0E2d56VLiMQraJhUcle158iavjrtGk6rjbFOeqrh3FoovJjDarpJyZIHkp69h9UGdzddy1NnfG9w8NqvEP3bABDwZyywbSM590BOIjyrEii8nBcqJNAtvBd08HETVWZl63qOxUSCpyktzq86mI8WKMaFMKaKKsPinxGcXU1my8m6CwlKzlRcJoKs1Ues+dUCZqy6wIJeYlCMvlsCnOVf1xLA5luTtW3ZWal9s2KE5Tl+atBFVuq3OxcX05G+T2ctj4UfjFcMjtklm63OqrR6rcal9MeXDkY2lHpaiF1hknmenI65R0LpKRV5+jRRT9mweb3WrGy7YYJ7OS9Qyi2iqR/CA6PdbWEPkE2e0Np0NJeaV0KH/67t/mdqicvNgLdV03Sna4VOeifK8vh3ZhtpWl/NltWOMxZLmtzsXG3WC2zW77ObpKXncF82Dxcss81fY/BErQR1OwGIvZPxQmPr61ZuH0BNdNUdsltebllkLfu+Vujsstq1+C3ArGK6ZEd2vFzUo+liKqohDTx6v1mlvD5Z8VxHl0F0B29pS8lPXccI+Y66F09yIvLyeTsMzv5WZXlrvb2ahDWXba5kugv5/am833UaULsLEictsFNaef4nJL9m4VUxhD22qHDs+cF5DbuiaLcsJTO4UuXDJjf0v8jGZKWqf9OiqBzCaUJz9Oebenq5NgRl6+nczgLxdZlVuhOpjFX4PxOY1CcqQdwY/EiRmDnFMf0h4fU5bl6YYBW7mccZG8JAUket0n4fYNL8F4uSw7tezTRHPwuJ0IumJ2C+r+MZNFRjmDDQipB/iWaIvJzUmo27Hk92NhkdvQ/mAzWO5b0NtF8CJyC6YFlsxAXdfaesAdCaanmBdraLRvRfpqOJgekFvwBCC3oEVetc8gT5QmIWXxQ53Pfx4AdwK5BU8Acgs6rsGmQBb8vu04sYbnJHoEwjrycoDcAgAAAKMDuQUAAABGB3ILAAAAjA7kFgAAABgdyC0A4KmctjgIJB+VAssBcgsmhveKjmcbA8Ym5Ze3A/i7nSzRl5+B+fMicuu9WWagHx2kJEPfbHP3g2zwOzz13dD3wb6WZ/Rn8fTfCs3910XJAy59Ade9hQ/60Pg/SE17zUW23Do1NeE55Nw7MIjxCnJLf0jfvzP5riST5dZ/eeS933tvbBxRbEmWDxutXk9uczoV8dhwb/k99Rv0BRTx7Azkya37u97HfFFywQx34Sxfbgd/Tdwt0TvkdpgvVjd0PGoMgdyOSXLtGl3sJNFJ7CP6VLK9AywmT1zRZt6Hgc7i5VZV2/Z8Qr/UFIxeNIBdWA0clwbJhV9y54ruG8DLkZTEez18LaXAOapjEmwqQ9s5lQRBLHLjOXXlpNu7UIjkJQ08nPGZjWKB923R2ubkK3Ycv75YhwP8Yn20xcKe3V+J+AdQ9laEMqUk6DXzanvyHRz45tLG+DgWrm+7hk5lmw/Oi/5TfMs7llq6wHu52R2r91LwTdv4Trh5KWgNro67TXluzCuOH+09TkQ3Fv/cwHd7xocEmCFLl1vDm0hZV9mMxzw6/kl+srhYjBn92Kioo7+ex8w4ROdxktxe92uyqE28vjgjJedoRnfAF7hqa73ErLrHGs8jEFvZfCEixksxNAtjiIupN1dzXF2FfuyEBX/uIUh8lmESFLpU9AnON2OALiWXi3jrs/gI4lzYVueidbTXih/rCM+GfdLu5+U7+6uOO98PoOMRaPNn66O3kWHJAZ9kPF8rkNtlALllB4Cg08e906mx8uSWnxNzs4pwwIwaGwRlOeDTi2z0d8tmFl9WMySiWqij3EZPEIlN6QzutC25lmSGUznB0D5xcksUUO0stx4VznnlBKVykSMKJrntnMl3zuwcxcp3L9/bbRUtzQGfdKfmgK9/aFCNf+iGDXgwkFs2kJ75pCMQH1GOlbeYLHhFpbPdPR1EVOEMli7vklu9yElyq8+nIsaLMaJNKaCJsrhBEeblTQEVtTUb7yZoXEp2zA1j+VeaqfSeO6EsJyiVi4QZHzAuh01xruqPY3Eoy92x6q7UvNy2QXGaujRvJahyW52LDeO5VpPby2HjR+EXwyG3S2bpcquvHqlyq30x5cGRj6Uelcqc3ZKZjrxOSeci/DQlX27lIg87u9WMl20xTmYl6xlEtVUi+UF0eqytIfIJstsbbIfy8goqQ1jtJuvocoJauWIdim+Z6lxsDpfqXJTv9eXQLsy2spQ/uw1rPIYst9W52LgbzLbZrednXiavu4J5sHi5ZZ5q+x8CJeijKViMxewf8tuJ/qYmt3fLC6cnuHKCvh1+zWTJrV5ko9yy+iXIrWC8Ykp0t1bcrORjKaIqCjHd1F6vSRqCkeo82t+AJX86D2xCzyB9KNwj5qbmSoK0XPG1Y/7r915udmW5u52NOpRlp22+BPr7qb3ZfB9VugAbKyK3XVBz+ikut2TvVjGFMbStdujwzHkBua1rsignPLVT6MIlM/a3xM9o6mm55m1P1/2ayl4Qj9mE8uRHTtC3++QE5cmtWmRVboXqYBZ/DcbnNArJkXYEPxInZgxyTn1Ie3xMWZYnq7N85XLGBWm1eQn9yT/aHeq/39/4BKVyWXZq2aeJ5uBxOxF0xewW1P1jJouMcgYbEFIP8C3RFpObk1C3Y8nvx8Iit6H9wWaw3Legt4vgReQWTAssmYG6rrX1gDsSTE8xL9bQaN+K9NVwMD0gt+AJQG5Bi7xqn0GeKE1CyuKHOp//PADuBHILngDkFnRcg02BLPh923FiDc9J9AiEdeTlALkFAAAARgdyCwAAAIwO5BYAAAAYHcgtAAAAMDqQWwDAUzltcRBIPioFlgPkFkwM7xUdzzYGjE3KL28H8Hc7WaIvPwPz50Xk1nuzzEA/OkhLhr4s6U4j6KtyxnwyZl/LM/qzeF4Vz3m8Sh9wB+5Ug6dny9Hek7Ll1inYhOeQc+/AIMYryC39IX3/zuS7krxHC+7+1ToZmh/zK/iHeit5PblNtp9x1HNXBQydXpTUd0rlya37u17VY8nTwQx34Sxfbgd/Tdwt0fu04E6zVBdDYwG5HZP02h24T1l99gxGcvIDLCZPXNFm3oeBzuLlVh2C2vMJ/VJTMNjQAHZhNXBcyiQX8RbHvTi+M5DZzeR987H+dtisU/LysuDqki3ydb9uPaeunHR7FwqRvKSBR37DfkajxOF9W7S2OfmKHSf0LruiKfKL9fEWiziQFbwltLZ7Tgf6XIwudLmsk/JyQj0+joXr266hU9nmg/Oi/xTf8o6lli7wXm52x+q9FHzTNr4Tbl4KWoOr425TnhvziuNHe48T0Y3FPzfw3Z7xIQFmyNLl1vAmUtZVNuOpTBFLPjfvL2Yx2b1RCApESnLr7YVqcpuRl1c83QFf4Kqt9RKz6h5rPI9AbGVzVkeNl2JoFsYQF1Nvrua4ugr92DHuZDlrpedCMUHFmZ6SF/GgR1z4MF0q+gSXkxfzZwvjwrY6F62jvVb8WEd4NuyLyX5evrO/6rjz/QA6HoE2f7Y+ehsZlhzwScbztQK5XQaQW3YACDp93DtdJJbico4xihdp589suc3ISy6fVuSoA76IUsaX1QyJqBbqKLfRV9qLNe8M7rTBIlNTwQpXLUiPovNaIS+yy+8EhQUWJ7dUUpPzkkvcOZPvnNk5ipXvXr632ypamgM+6U7NAV//0KAa/9ANG/BgILdsID2iSSWSj6jFUgf5YDkxQ26ti8npeXlZKF5a/RST5dbie1w0XowRbUoBrb3EDYowL2nx3/gQICeojMtaXiRM9k9bR9RWmBLb8tIKcDlsinNVfxyLQ1nujlV3pebltg2K09SleStBldvqXGwYz7Wa3F4OGz8KvxgOuV0yS5dbffVIlVvtiykPjtoQzYdRC/Nmt+4FWTiz8vLysIiif/Ngs1vNeNkW42RWsp5BVFslkh9Ep8faGmJy31XzsncodxGbbkesvA6VnJdagupcbA6X6lyU7/Xl0C7MtrKUP7sNazyGLLfVudi4G8y22a3nZ14mr7uCebB4uWWeavsfAkU0UO72QrASy5qVb61xdCSDCZVef3RMzsuzVN+75W6Oyy2rX4LcCsYrpkR3a5uUuGk7G0vRQFGI6ab2ek3SEIyUE5RDtLzk9VwvPbJVGOzIr7gZrD0vtwxhmd/Lza4sd7ezUYey7LTNl0B/P7VLkT9zoHUBNlZEbrug5vRTXG7J3q1iCmNoW+3Q4ZnzAnJb12RRzh/nzSu8zNjfYjijqWblp3Xar+MSqBvnlnd7ujoJ5uTl2ckM8bwtUbkVrGcWfw3G5zWKlyNtHT8Spz0Mck59SHt8TFmWJ6uzTIJWK/y8ZAUk2dBW7o1rE4yXy7JTyz4zNAeP24mgK2a3oO4fM1lklDPYgJB6gG+JtpjcnIS6HUt+PxYWuQ3tDzaD5VaF3i6CF5FbMC2wZAbqulYn6fkJpqeYF2to4o/k+M7MG8gteAKQW9Air9pnkCdKk5Cy+KHO5z8PgDuB3IInALkFHddgUyALft92nFjDcxI9AmEdeTn8H9yQCCEpf0olAAAAAElFTkSuQmCC" alt="" />