HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("first");
HSSFRow row1 = sheet.createRow(0);
HSSFCell cell = row1.createCell(2);
cell.setCellValue("我");//单元格中文显示正常
DVConstraint constraint = DVConstraint.createFormulaListConstraint("$C$1:$C$3");
CellRangeAddressList regions = new CellRangeAddressList(0,200,0,0);
HSSFDataValidation data_validation = new HSSFDataValidation(regions,constraint);
data_validation.setEmptyCellAllowed(false);
data_validation.setShowPromptBox(true);
data_validation.setSuppressDropDownArrow(false);
data_validation.createErrorBox("Invalidate!", "please input again!");
data_validation.createPromptBox("我", "You can select one");
//当在createErrorBox,createPromptBox出现中文的时候,excel打开就出现,下拉菜单也实现不了,而英文就没问题
HSSFSheet sheet = wb.createSheet("first");
HSSFRow row1 = sheet.createRow(0);
HSSFCell cell = row1.createCell(2);
cell.setCellValue("我");//单元格中文显示正常
DVConstraint constraint = DVConstraint.createFormulaListConstraint("$C$1:$C$3");
CellRangeAddressList regions = new CellRangeAddressList(0,200,0,0);
HSSFDataValidation data_validation = new HSSFDataValidation(regions,constraint);
data_validation.setEmptyCellAllowed(false);
data_validation.setShowPromptBox(true);
data_validation.setSuppressDropDownArrow(false);
data_validation.createErrorBox("Invalidate!", "please input again!");
data_validation.createPromptBox("我", "You can select one");
//当在createErrorBox,createPromptBox出现中文的时候,excel打开就出现,下拉菜单也实现不了,而英文就没问题
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货