Java使用POI操作Excel并创建下拉框

Java使用POI操作Excel并创建下拉框Java代码

package poiexcel;

import java.io.FileOutputStream;

import java.util.Date;

import ermodel.DVConstraint;

import ermodel.HSSFCell;

import ermodel.HSSFDataValidation;

import ermodel.HSSFRow;

import ermodel.HSSFSheet;

import ermodel.HSSFWorkbook;

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

public class POI

{

public static void main(String [] args)

{

String [] list={"东软","华信","SAP","海辉"};

new POI().createListBox(list);

return;

}

public void createListBox (String [] list)

{

//文件初始化

HSSFWorkbook wb = new HSSFWorkbook();

HSSFSheet sheet = wb.createSheet("new sheet");

//在第一行第一个单元格，插入下拉框

HSSFRow row = sheet.createRow(0);

HSSFCell cell = row.createCell(0);

//普通写入操作

cell.setCellValue("请选择");//这是实验

//生成下拉列表

//只对（0，0）单元格有效

CellRangeAddressList regions = new CellRangeAddressList(0,0,0,0);

//生成下拉框内容

DVConstraint constraint = DVConstraint.createExplicitListConstraint(list);

//绑定下拉框和作用区域

HSSFDataValidation data_validation = new HSSFDataValidation(regions,constraint); //对sheet页生效

sheet.addValidationData(data_validation);

//写入文件

FileOutputStream fileOut;

try {

fileOut = new FileOutputStream("workbook.xls");

wb.write(fileOut);

fileOut.close();

} catch (Exception e) {

// TODO Auto-generated catch block e.printStackTrace();

}

//结束

System.out.println("Over");

}

}