EXCEL 下拉框

 
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 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,50,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("C:\\workbook.xls");  
   wb.write(fileOut);  
   fileOut.close();  
  } catch (Exception e) {  
   // TODO Auto-generated catch block  
   e.printStackTrace();  
  }  
    
  //结束  
  System.out.println("Over");  
}  
}