有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

java Apache POI在excel工作表中插入逗号(,)

我有一个字符串数组,我正试图将其作为下拉列表插入。正如在ApachePOIdocumentation上所建议的那样

其中一个元素包含逗号-Member, Non-member

String[] arr = {"Group", "Member, Non-member"};
XSSFDataValidationHelper dvHelper = new XSSFDataValidationHelper((XSSFSheet) sheet);
XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint) dvHelper
                .createExplicitListConstraint(options);
CellRangeAddressList optionAddressList = new CellRangeAddressList(0, 0, 0, 0);
XSSFDataValidation pickListDataValidation = (XSSFDataValidation) dvHelper.createValidation(dvConstraint,
                optionAddressList);
        pickListDataValidation.setShowErrorBox(true);
        pickListDataValidation.setSuppressDropDownArrow(true);
        pickListDataValidation.setShowPromptBox(true);
sheet.addValidationData(pickListDataValidation);

但POI所做的是,每当遇到逗号时,它就将行分成2行。 所以结果下拉列表是:

Group
Member
Non-member

请建议我如何处理它


共 (0) 个答案