org.apache.poi.hssf.usermodel.HSSFWorkbook.createName()方法的使用及代码示例

x33g5p2x  于2022-01-20 转载在 其他  
字(1.5k)|赞(0)|评价(0)|浏览(129)

本文整理了Java中org.apache.poi.hssf.usermodel.HSSFWorkbook.createName()方法的一些代码示例,展示了HSSFWorkbook.createName()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。HSSFWorkbook.createName()方法的具体详情如下:
包路径:org.apache.poi.hssf.usermodel.HSSFWorkbook
类名称:HSSFWorkbook
方法名:createName

HSSFWorkbook.createName介绍

[英]creates a new named range and add it to the model
[中]创建新的命名范围并将其添加到模型中

代码示例

代码示例来源:origin: org.apache.poi/poi

  1. @Override
  2. public HSSFName createName() {
  3. return _uBook.createName();
  4. }

代码示例来源:origin: stackoverflow.com

  1. HSSFWorkbook workbook = new HSSFWorkbook();
  2. HSSFSheet realSheet = workbook.createSheet("Sheet xls");
  3. HSSFSheet hidden = workbook.createSheet("hidden");
  4. for (int i = 0, length= countryName.length; i < length; i++) {
  5. String name = countryName[i];
  6. HSSFRow row = hidden.createRow(i);
  7. HSSFCell cell = row.createCell(0);
  8. cell.setCellValue(name);
  9. }
  10. Name namedCell = workbook.createName();
  11. namedCell.setNameName("hidden");
  12. namedCell.setRefersToFormula("hidden!$A$1:$A$" + countryName.length);
  13. DVConstraint constraint = DVConstraint.createFormulaListConstraint("hidden");
  14. CellRangeAddressList addressList = new CellRangeAddressList(0, 0, 0, 0);
  15. HSSFDataValidation validation = new HSSFDataValidation(addressList, constraint);
  16. workbook.setSheetHidden(1, true);
  17. realSheet.addValidationData(validation);
  18. FileOutputStream stream = new FileOutputStream("c:\\range.xls");
  19. workbook.write(stream);
  20. stream.close();

代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

  1. @Override
  2. public HSSFName createName() {
  3. return _uBook.createName();
  4. }

相关文章

HSSFWorkbook类方法