java导出excel文件的下拉框

我就直接贴代码了

 

 

 

package com.util;

import java.io.UnsupportedEncodingException;
import javax.servlet.http.HttpServletResponse;
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.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.util.CellRangeAddressList;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFFont;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ExcelUtil {

    public static HSSFWorkbook getHSSFWorkbook(HSSFWorkbook wb, String[] title, String[] stuffs) {

        // 第二步，在workbook中添加一个sheet,对应Excel文件中的sheet
        HSSFSheet sheet = wb.createSheet("Sheet");
        // 第三步，在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制
        HSSFRow row = sheet.createRow(0);
        // 第四步，创建单元格，并设置值表头 设置表头居中
        HSSFCellStyle style = wb.createCellStyle();
        
        style.setFillForegroundColor((short) 13);
//        style.setFillPattern(XSSFCellStyle.SOLID_FOREGROUND);
        sheet.setColumnWidth(0, 4000);
        sheet.setColumnWidth(1, 5000);
        sheet.setColumnWidth(2, 5000);

        //style.setVerticalAlignment(XSSFCellStyle.VERTICAL_CENTER);
        //style.setAlignment(XSSFCellStyle);
        HSSFFont font = wb.createFont();
        font.setFontHeightInPoints((short) 16);
        //font.setBoldweight(XSSFFont.BOLDWEIGHT_BOLD);

        // 声明列对象
        HSSFCell cell = null;

        // 创建标题
        for (int i = 0; i < title.length; i++) {
            cell = row.createCell(i);
            cell.setCellValue(title[i]);
            cell.setCellStyle(style);
        }

  //参数分别是 开始行  结束行  开始列  结束列     

 CellRangeAddressList regions = new CellRangeAddressList(1, 65535, 2, 2);
        // 生成下拉框内容
        DVConstraint constraint = DVConstraint.createExplicitListConstraint(stuffs);
        // 绑定下拉框和作用区域
        HSSFDataValidation data_validation = new HSSFDataValidation(regions, constraint);
        // 对sheet页生效
        sheet.addValidationData(data_validation);

        return wb;
    }

  
}