例如:selet
import java.io.FileOutputStream;
import java.util.Date;
import org.apache.poi.hssf.usermodel.DVConstraint;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDataValidation;
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.CellRangeAddressList;
public class TestPOI
{
public static void main(String[] args)
{
String[] list = {"a", "b", "c"};
createListBox(list);
return;
}
public static void createListBox(String[] list)
{
//文件初始化
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("test");
String dateformat = "yyyy-MM-dd";
String s="yyyy-MM-dd HH:mm:ss";
//在第一行第一个单元格,插入下拉框
HSSFRow row = sheet.createRow(0);
HSSFCell cell = row.createCell(0);
//在第一行第二个单元格,插入日期
//生成下拉列表
//四个参数分别是:起始行、终止行、起始列、终止列
CellRangeAddressList regions = new CellRangeAddressList(0, 1001, 0, 0);
// CellRangeAddressList regions = new CellRangeAddressList();
//只对(0,1)单元格有效
CellRangeAddressList regions1 = new CellRangeAddressList(1, 1001, 1, 1);
//生成下拉框内容
DVConstraint constraint = DVConstraint.createExplicitListConstraint(list);
//生成日期
DVConstraint constraint1 = DVConstraint.createDateConstraint(DVConstraint.OperatorType.BETWEEN,
"2009-01-01",
"2009-11-01",
dateformat);
//绑定下拉框和作用区域 .并添加输入内容提示
HSSFDataValidation data_validation = new HSSFDataValidation(regions,
constraint);
data_validation.createPromptBox("tip","select");
//绑定日期和作用区域.并添加输入内容提示
HSSFDataValidation date_validation = new HSSFDataValidation(regions1,
constraint1);
date_validation.createPromptBox("tip","date between 2009-01-01 and 2009-11-01");
//对sheet页生效
sheet.addValidationData(data_validation);
sheet.addValidationData(date_validation);
//写入文件
FileOutputStream fileOut;
try
{
fileOut = new FileOutputStream("c:\\testworkbook.xls");
wb.write(fileOut);
fileOut.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
import java.io.FileOutputStream;
import java.util.Date;
import org.apache.poi.hssf.usermodel.DVConstraint;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDataValidation;
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.CellRangeAddressList;
public class TestPOI
{
public static void main(String[] args)
{
String[] list = {"a", "b", "c"};
createListBox(list);
return;
}
public static void createListBox(String[] list)
{
//文件初始化
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("test");
String dateformat = "yyyy-MM-dd";
String s="yyyy-MM-dd HH:mm:ss";
//在第一行第一个单元格,插入下拉框
HSSFRow row = sheet.createRow(0);
HSSFCell cell = row.createCell(0);
//在第一行第二个单元格,插入日期
//生成下拉列表
//四个参数分别是:起始行、终止行、起始列、终止列
CellRangeAddressList regions = new CellRangeAddressList(0, 1001, 0, 0);
// CellRangeAddressList regions = new CellRangeAddressList();
//只对(0,1)单元格有效
CellRangeAddressList regions1 = new CellRangeAddressList(1, 1001, 1, 1);
//生成下拉框内容
DVConstraint constraint = DVConstraint.createExplicitListConstraint(list);
//生成日期
DVConstraint constraint1 = DVConstraint.createDateConstraint(DVConstraint.OperatorType.BETWEEN,
"2009-01-01",
"2009-11-01",
dateformat);
//绑定下拉框和作用区域 .并添加输入内容提示
HSSFDataValidation data_validation = new HSSFDataValidation(regions,
constraint);
data_validation.createPromptBox("tip","select");
//绑定日期和作用区域.并添加输入内容提示
HSSFDataValidation date_validation = new HSSFDataValidation(regions1,
constraint1);
date_validation.createPromptBox("tip","date between 2009-01-01 and 2009-11-01");
//对sheet页生效
sheet.addValidationData(data_validation);
sheet.addValidationData(date_validation);
//写入文件
FileOutputStream fileOut;
try
{
fileOut = new FileOutputStream("c:\\testworkbook.xls");
wb.write(fileOut);
fileOut.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}