| | |
|---|
| | | DataValidation subjectValidation = dataValidationHelper.createValidation(subjectConstraint, subjectTypeRange); |
|---|
| | | sheet.addValidationData(subjectValidation); |
|---|
| | | |
|---|
| | | // 设置选项下拉范围，第4列，1500行内 |
|---|
| | | CellRangeAddressList optionRange = new CellRangeAddressList(2, 1500, 3, 3); |
|---|
| | | // 添加选项下拉 |
|---|
| | | DataValidationConstraint optionConstraint = dataValidationHelper.createExplicitListConstraint(optionList); |
|---|
| | | DataValidation optionValidation = dataValidationHelper.createValidation(optionConstraint, optionRange); |
|---|
| | | sheet.addValidationData(optionValidation); |
|---|
| | | // // 设置选项下拉范围，第4列，1500行内 |
|---|
| | | // CellRangeAddressList optionRange = new CellRangeAddressList(2, 1500, 3, 3); |
|---|
| | | // // 添加选项下拉 |
|---|
| | | // DataValidationConstraint optionConstraint = dataValidationHelper.createExplicitListConstraint(optionList); |
|---|
| | | // DataValidation optionValidation = dataValidationHelper.createValidation(optionConstraint, optionRange); |
|---|
| | | // sheet.addValidationData(optionValidation); |
|---|
| | | |
|---|
| | | // 设置选项下拉范围，第4列，1500行内 |
|---|
| | | CellRangeAddressList answerRange = new CellRangeAddressList(2, 1500, 5, 5); |
|---|
