poi-3.6-20091214.jar
package exceltest; import java.io.FileOutputStream; import java.io.IOException; import org.apache.poi.hssf.usermodel.DVConstraint; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFDataValidation; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.util.CellRangeAddressList; public class ExcelUtile { public static void main(String[] args) throws IOException { HSSFWorkbook wb = new HSSFWorkbook();// excel文件对象 HSSFSheet sheetlist = wb.createSheet("sheetlist1");// 工作表对象1 HSSFSheet sheetlist2 = wb.createSheet("sheetlist2");// 工作表对象2 HSSFSheet sheetlist3 = wb.createSheet("sheetlist3");// 工作表对象3 FileOutputStream out = new FileOutputStream("c:/success6.xls"); //新建单元格 HSSFRow row = sheetlist.createRow(0); for(short i=0;i<10;i++){ //HSSFCell cell = row.getCell(i); HSSFCell cell = row.createCell(i); cell.setCellValue("列值" + i); //获取单元格内容。 //System.out.println( cell.getStringCellValue()); } //修改单元格 HSSFRow row2 = sheetlist.getRow(0); HSSFCell cell = row.getCell(2); cell.setCellValue("下拉选择"); HSSFCell cell2 = row.getCell(3); cell2.setCellValue("长度限制在1-5"); //有效性选择所需数据。 String[] textList = {"空闲", "已用"}; //数据有效性验证,下拉选择。 DVConstraint constraint = DVConstraint.createExplicitListConstraint(textList); CellRangeAddressList regions = new CellRangeAddressList((short) 1, (short) 20, (short) 2, (short) 2); HSSFDataValidation data_validation = new HSSFDataValidation(regions, constraint); sheetlist.addValidationData(data_validation); //有效性单元格长度控制。 DVConstraint constraint2 = DVConstraint.createNumericConstraint(DVConstraint.ValidationType.TEXT_LENGTH,DVConstraint.OperatorType.BETWEEN, "1", "5"); CellRangeAddressList regions2 = new CellRangeAddressList((short) 1, (short) 20, (short) 3, (short) 3); HSSFDataValidation data_validation2 = new HSSFDataValidation(regions2, constraint2); sheetlist.addValidationData(data_validation2); wb.write(out); out.close(); } }
- 粉丝: 0
- 资源: 1
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
- 1
- 2
- 3
前往页