java excel下拉框联动_Java 使用POI生成带联动下拉框的excel表格实例代码

废话不多说了，直接给大家贴代码了，具体代码如下所示：

import java.io.File;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.List;

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.hssf.util.HSSFColor;

import org.apache.poi.ss.usermodel.DataValidation;

import org.apache.poi.ss.usermodel.Name;

import org.apache.poi.ss.util.CellRangeAddressList;

public class ExcelLinkage {

// 样式

private HSSFCellStyle cellStyle;

// 初始化省份数据

private List province = new ArrayList(Arrays.asList("湖南","广东"));

// 初始化数据(湖南的市区)

private List hnCity = new ArrayList(Arrays.asList("长沙市","邵阳市"));

// 初始化数据(广东市区)

private List gdCity = new ArrayList(Arrays.asList("深圳市","广州市"));

public void setDataCellStyles(HSSFWorkbook workbook,HSSFSheet sheet) {

cellStyle = workbook.createCellStyle();

// 设置边框

cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);

cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);

cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);

cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);

// 设置背景色

cellStyle.setFillForegroundColor(HSSFColor.LIGHT_GREEN.index);

cellStyle.setFillPattern(HSSF