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) 个答案