小编教你javaexcel多选下拉列表设置
工具/原料
手机
电脑
方法/步骤
1、需要用到的jar包：poi-3.10-FINAL.jarpoi-ooxml-3.10-FINAL.jarpoi-ooxml-schemas-3.10-FINAL.jargradle引入：compilegroup:'org.apache.poi',name:'poi',version:'3.10'compilegroup:'org.apache.poi',name:'poi-ooxml',version:'3.10-FINAL'
2、publicstaticHSSFWorkbookwrite(InputStreaminputStream)throwsIOException,ClassNotFoundException{//初始一个workbookHSSFWorkbookworkbook=newHSSFWorkbook(inputStream);//创建一个sheet HSSFSheetsheet=workbook.getSheetAt(0);//准备下拉列表数据 String[]strs=newString[]{"刘德华","张学友","黎明","郭富城"};//设置第一列的1-10行为下拉列表 CellRangeAddressListregions=newCellRangeAddressList(0,9,0,0);//创建下拉列表数据 DVConstraintconstraint=DVConstraint.createExplicitListConstraint(strs);//绑定 HSSFDataValidationdataValidation=newHSSFDataValidation(regions,constraint);sheet.addValidationData(dataValidation);returnworkbook;}
3、方案二方案二的思路是在excel中添加一个隐藏的sheet存放数据源（下拉的数据），在真正需要下拉的sheet单元格写入属性。1.需要使用到的util类packagecom.excel.select;importjava.io.InputStream;importorg.apache.poi.hssf.usermodel.HSSFCell;importorg.apache.poi.hssf.usermodel.HSSFCellStyle;importorg.apache.poi.hssf.usermodel.HSSFClientAnchor;importorg.apache.poi.hssf.usermodel.HSSFFont;importorg.apache.poi.hssf.usermodel.HSSFRichTextString;importorg.apache.poi.hssf.usermodel.HSSFWorkbook;importorg.apache.poi.hssf.util.HSSFColor;importorg.apache.poi.ss.usermodel.Cell;importorg.apache.poi.ss.usermodel.CellStyle;importorg.apache.poi.ss.usermodel.Comment;importorg.apache.poi.ss.usermodel.Drawing;importorg.apache.poi.ss.usermodel.Font;importorg.apache.poi.ss.usermodel.RichTextString;importorg.apache.poi.ss.usermodel.Workbook;
4、2.Test类packagecom.excel.select;importjava.io.FileOutputStream;importorg.apache.poi.hssf.usermodel.DVConstraint;importorg.apache.poi.hssf.usermodel.HSSFCell;importorg.apache.poi.hssf.usermodel.HSSFDataFormat;importorg.apache.poi.hssf.usermodel.HSSFDataValidation;importorg.apache.poi.hssf.usermodel.HSSFName;importorg.apache.poi.hssf.usermodel.HSSFRow;importorg.apache.poi.hssf.usermodel.HSSFSheet;importorg.apache.poi.hssf.usermodel.HSSFWorkbook;importorg.apache.poi.hssf.util.CellRangeAddressList;importorg.apache.poi.ss.usermodel.CellStyle;importorg.apache.poi.ss.usermodel.Row;importorg.apache.poi.ss.usermodel.Sheet;importorg.apache.poi.ss.usermodel.Workbook;
