JavaWeb 利用poi导出下拉框excel模版

 private HSSFWorkbook workbook = null;   
    private HSSFCellStyle titleStyle = null;   
    private HSSFCellStyle dataStyle = null;  
  
    /** 
     * 列头样式 


     * @param workbook 
     * @param sheet 
     */  
    public void setTitleCellStyles(HSSFWorkbook workbook,HSSFSheet sheet){  
        titleStyle = workbook.createCellStyle();  
  
        //设置边框  
        titleStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);  
        titleStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);  
        titleStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);  
        titleStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);  
        //设置背景色  
        titleStyle.setFillForegroundColor(HSSFColor.WHITE.index);  
        titleStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);  
        //设置居中  
        titleStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);  
        //设置字体  
        HSSFFont font = workbook.createFont();  
        font.setFontName("宋体");  
        font.setFontHeightInPoints((short) 11); //设置字体大小  
        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);//粗体显示  
        titleStyle.setFont(font);//选择需要用到的字体格式  
        //设置自动换行  
        titleStyle.setWrapText(true);  
        //设置列宽 ,第一个参数代表列id(从0开始),第2个参数代表宽度值  
        sheet.setColumnWidth(0, 5000);   
        sheet.setColumnWidth(1, 5000);   
        sheet.setColumnWidth(2, 3000);   
        sheet.setColumnWidth(3, 7000);   
        sheet.setColumnWidth(4, 5000);   
        sheet.setColumnWidth(5, 5000);   
        sheet.setColumnWidth(6, 3000);   
        sheet.setColumnWidth(7, 3000);   
        sheet.setColumnWidth(8, 5000);   
        sheet.setColumnWidth(9, 5000);   
        sheet.setColumnWidth(10, 3000);   
        sheet.setColumnWidth(11, 3000);   
        sheet.setColumnWidth(12, 3000);   
        sheet.setColumnWidth(13, 3000);   
        sheet.setColumnWidth(14, 7000);   
        sheet.setColumnWidth(15, 7000);   
        sheet.setColumnWidth(16, 7000);   
        sheet.setColumnWidth(17, 7000);   
        sheet.setColumnWidth(18, 10000);   
    }  
    /** 
     * 数据样式 
     * @param workbook 
     * @param sheet 
     */  
    public void setDataCellStyles(HSSFWorkbook workbook,HSSFSheet sheet){  
        dataStyle = workbook.createCellStyle();  
  
        //设置边框  
        dataStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);  
        dataStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);  
        dataStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);  
        dataStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);  
        //设置背景色  
        dataStyle.setFillForegroundColor(HSSFColor.WHITE.index);  
        dataStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);  
        //设置居中  
        dataStyle.setAlignment(HSSFCellStyle.ALIGN_LEFT);  
        //设置字体  
        HSSFFont font = workbook.createFont();  
        font.setFontName("宋体");  
        font.setFontHeightInPoints((short) 11); //设置字体大小  
        dataStyle.setFont(font);//选择需要用到的字体格式  
        //设置自动换行  
        dataStyle.setWrapText(true);  
    }  

/** 
     * 创建一列数据 
     * @param currentRow 
     * @param textList 
     */  
    public