Excel展示如下,注意左上角部分:
代码如下:
int i=1;
int j=2;
Label brokerGender = new Label(i++, j, "1-女", yellowFormate);//性别
WritableCellFeatures wcf=new WritableCellFeatures();
List<String> gList = new ArrayList<String>();
gList.add("0-男");
gList.add("1-女");
gList.add("2-不详");
wcf.setDataValidationList(gList);
brokerGender.setCellFeatures(wcf);
sheet.addCell(brokerGender);