java poi 限定单元格只能输入数字
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class EasyPoiNumberValidation {
public static void main(String[] args) {
Workbook workbook = new XSSFWorkbook();
Sheet sheet = workbook.createSheet("Sheet1");
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
// 设置单元格的值
cell.setCellValue("Only numbers allowed");
// 数据有效性设置
DataValidationHelper helper = sheet.getDataValidationHelper();
DataValidationConstraint constraint = helper.createNumericConstraint(DataValidationConstraint.ValidationType.INTEGER,
DataValidationConstraint.OperatorType.BETWEEN,
"0",
"100");
CellRangeAddressList addressList = new CellRangeAddressList(0, 0, 0, 0); // 限定单元格A1
DataValidation dataValidation = helper.createValidation(constraint, addressList);
// 处理Excel的bug
if (dataValidation instanceof XSSFDataValidation) {
dataValidation.setSuppressDropDownArrow(true);
dataValidation.setShowErrorBox(true);
} else {
dataValidation.setSuppressDropDownArrow(false);
}
sheet.addValidationData(dataValidation);
// 写入文件
try (OutputStream out = new FileOutputStream("number_validation.xlsx")) {
workbook.write(out);
} catch (Exception e) {
e.printStackTrace();
}
}
}
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· AI编程工具终极对决:字节Trae VS Cursor,谁才是开发者新宠?
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
2021-12-17 vue typescript: Parameter ‘XXX’ implicitly has an ‘any’ type.解决方法