<span style="font-size:24px;"> HSSFWorkbook workbook = new HSSFWorkbook();//excel文件对象 HSSFSheet userinfosheet1 = workbook.createSheet("jiji");//工作表对象 //创建一个隐藏页和隐藏数据集 // HSSFSheet hideselectinfosheet = workbook.createSheet("hideselectinfosheet");//隐藏一些信息 //设置下拉列表的内容 String[] zjProvinceList = {"杭州","宁波","温州","台州","绍兴","金华","湖州","丽水","衢州","舟山"}; //在隐藏页设置选择信息 HSSFRow provinceRow = userinfosheet1.createRow(8888); TomTestSelect.creatRow(provinceRow, zjProvinceList); //设置隐藏页标志 //workbook.setSheetHidden(workbook.getSheetIndex("hideselectinfosheet"), true); //设置名称数据集 Name namedRange = workbook.createName(); namedRange.setNameName("list1"); namedRange.setRefersToFormula("'tom'!$A$8889:$J$8889"); DVConstraint dvConstraint = DVConstraint.createFormulaListConstraint("list1"); //创建一行数据 CellRangeAddressList addressList = new CellRangeAddressList( <span style="white-space:pre"> </span> 1, 8887, 0, 0); DataValidation dataValidation = new HSSFDataValidation <span style="white-space:pre"> </span> (addressList, dvConstraint); dataValidation.setSuppressDropDownArrow(false); userinfosheet1.addValidationData(dataValidation); HSSFRow row = userinfosheet1.createRow(0); HSSFCell cell = row.createCell(0); cell.setCellValue("浙江"); //生成输入文件 FileOutputStream out=new FileOutputStream("F:/success02.xls"); workbook.write(out); out.close(); </span>