Question

急！！！HSSFWorkbook生成的execl的下拉列表时如何设置此单元格的默认值，请同志们指教！求大神帮助

Answer 1

HSSFWorkbook wb = null; try { wb = new HSSFWorkbook(multipartFile.getInputStream()); logger.debug(wb.getNumberOfSheets()); HSSFSheet sheet = wb.getSheetAt(0); Iterator<Row> rows = sheet.rowIterator(); List<List<String>> content = new ArrayList<List<String>>(); while(rows.hasNext()){ Row row = rows.next(); Iterator<Cell> cells = row.cellIterator(); List<String> line = new ArrayList<String>(); while(cells.hasNext()){ Cell cell = cells.next(); line.add(cell.getCellComment().getString().getString()); } content.add(line); } return content; } catch (Exception e) { logger.error(e); // throw new // BusinessServiceException("未知原因！保存Excel文件时，请不要将鼠标最终定位在Excel中的可以下拉选值的列上。"); }

Answer 2

直接赋值就可以了，只要是列表里的值，到时候都会自动选择上的