poi 级联

最新推荐文章于 2023-04-23 09:31:24 发布

月冷无双

最新推荐文章于 2023-04-23 09:31:24 发布

阅读量457

点赞数

分类专栏： Java 文章标签： poi 级联

本文链接：https://blog.csdn.net/u014452858/article/details/44044897

版权

Java 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

  <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>