最近在项目中使用poi创建excel文件时,需要生成单元格下拉选。
下面是一个demo,注释比较清楚,以此参考。
package poi;
import java.io.FileOutputStream;
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.ss.util.CellRangeAddressList;
public class ExcelSetCheckbox {
public static void main(String[] args) {
String[] list={"广州","深圳","东莞","珠海"};
new ExcelSetCheckbox().createListBox(list);