String literals in formulas can’t be bigger than 255 characters ASCII

/***创建下拉框**/
 private static void creatDropDownList(Sheet taskInfoSheet, String[] dataArray ,
                                       Integer firstRow, Integer lastRow, Integer firstCol, Integer lastCol,Workbook book) {
    



        Sheet hidden = book.createSheet("hidden");
        Cell cell = null;
        for (int i = 0, length = dataArray .length; i < length; i++)
        {
            String name = dataArray[i];
            Row row = hidden.createRow(i);
            cell = row.createCell(0);
            cell.setCellValue(name);
        }

        Name namedCell = wbCreat.createName();
        namedCell.setNameName("hidden");
        namedCell.setRefersToFormula("hidden!$A$1:$A$" + dataArray.length);
        //加载数据,将名称为hiddens的
        DVConstraint constraint = DVConstraint.createFormulaListConstraint("hidden");
        // 设置数据有效性加载在哪个单元格上,四个参数分别是：起始行、终止行、起始列、终止列
        CellRangeAddressList addressList = new CellRangeAddressList(firstRow, endRow, firstCol,
                endCol);
        HSSFDataValidation validation = new HSSFDataValidation(addressList, constraint);
        //将第二个sheet设置为隐藏
        wbCreat.setSheetHidden(1, true);
        if (null != validation)
        {
            sheet.addValidationData(validation);
        }
        return validation;


 }

以上解决  多数据下拉框 参考以为大神的 

https://blog.csdn.net/wangchaox123/article/details/97787470