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

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

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

HSSFWorkbook.validateSheetIndex介绍

暂无

代码示例

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

  1. /**
  2. * Get the HSSFSheet object at the given index.
  3. * @param index of the sheet number (0-based physical & logical)
  4. * @return HSSFSheet at the provided index
  5. * @throws IllegalArgumentException if the index is out of range (index
  6. * < 0 || index >= getNumberOfSheets()).
  7. */
  8. @Override
  9. public HSSFSheet getSheetAt(int index)
  10. {
  11. validateSheetIndex(index);
  12. return _sheets.get(index);
  13. }

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

  1. /**
  2. * @return Sheet name for the specified index
  3. */
  4. @Override
  5. public String getSheetName(int sheetIndex) {
  6. validateSheetIndex(sheetIndex);
  7. return workbook.getSheetName(sheetIndex);
  8. }

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

  1. @Override
  2. public boolean isSheetHidden(int sheetIx) {
  3. validateSheetIndex(sheetIx);
  4. return workbook.isSheetHidden(sheetIx);
  5. }

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

  1. @Override
  2. public boolean isSheetVeryHidden(int sheetIx) {
  3. validateSheetIndex(sheetIx);
  4. return workbook.isSheetVeryHidden(sheetIx);
  5. }

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

  1. @Override
  2. public void setSheetVisibility(int sheetIx, SheetVisibility visibility) {
  3. validateSheetIndex(sheetIx);
  4. workbook.setSheetHidden(sheetIx, visibility);
  5. }

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

  1. /**
  2. * Set the sheet name.
  3. *
  4. * @param sheetIx number (0 based)
  5. * @throws IllegalArgumentException if the name is null or invalid
  6. * or workbook already contains a sheet with this name
  7. * @see #createSheet(String)
  8. * @see org.apache.poi.ss.util.WorkbookUtil#createSafeSheetName(String nameProposal)
  9. */
  10. @Override
  11. public void setSheetName(int sheetIx, String name) {
  12. if (name == null) {
  13. throw new IllegalArgumentException("sheetName must not be null");
  14. }
  15. if (workbook.doesContainsSheetName(name, sheetIx)) {
  16. throw new IllegalArgumentException("The workbook already contains a sheet named '" + name + "'");
  17. }
  18. validateSheetIndex(sheetIx);
  19. workbook.setSheetName(sheetIx, name);
  20. }

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

  1. /**
  2. * Selects multiple sheets as a group. This is distinct from
  3. * the 'active' sheet (which is the sheet with focus).
  4. * Unselects sheets that are not in <code>indexes</code>.
  5. *
  6. * @param indexes Collection of sheets to select, the index is 0-based.
  7. */
  8. public void setSelectedTabs(Collection<Integer> indexes) {
  9. for (int index : indexes) {
  10. validateSheetIndex(index);
  11. }
  12. // ignore duplicates
  13. Set<Integer> set = new HashSet<>(indexes);
  14. int nSheets = _sheets.size();
  15. for (int i=0; i<nSheets; i++) {
  16. boolean bSelect = set.contains(i);
  17. getSheetAt(i).setSelected(bSelect);
  18. }
  19. // this is true only if all values in set were valid sheet indexes (between 0 and nSheets-1, inclusive)
  20. short nSelected = (short) set.size();
  21. workbook.getWindowOne().setNumSelectedTabs(nSelected);
  22. }

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

  1. /**
  2. * Selects a single sheet. This may be different to
  3. * the 'active' sheet (which is the sheet with focus).
  4. */
  5. @Override
  6. public void setSelectedTab(int index) {
  7. validateSheetIndex(index);
  8. int nSheets = _sheets.size();
  9. for (int i=0; i<nSheets; i++) {
  10. getSheetAt(i).setSelected(i == index);
  11. }
  12. workbook.getWindowOne().setNumSelectedTabs((short)1);
  13. }

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

  1. /**
  2. * Convenience method to set the active sheet. The active sheet is is the sheet
  3. * which is currently displayed when the workbook is viewed in Excel.
  4. * 'Selected' sheet(s) is a distinct concept.
  5. */
  6. @Override
  7. public void setActiveSheet(int index) {
  8. validateSheetIndex(index);
  9. int nSheets = _sheets.size();
  10. for (int i=0; i<nSheets; i++) {
  11. getSheetAt(i).setActive(i == index);
  12. }
  13. workbook.getWindowOne().setActiveSheetIndex(index);
  14. }

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

  1. validateSheetIndex(sheetIndex);
  2. HSSFSheet srcSheet = _sheets.get(sheetIndex);
  3. String srcName = workbook.getSheetName(sheetIndex);

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

  1. validateSheetIndex(index);
  2. boolean wasSelected = getSheetAt(index).isSelected();

代码示例来源:origin: com.haulmont.thirdparty/poi

  1. /**
  2. * Get the HSSFSheet object at the given index.
  3. * @param index of the sheet number (0-based physical & logical)
  4. * @return HSSFSheet at the provided index
  5. */
  6. public HSSFSheet getSheetAt(int index)
  7. {
  8. validateSheetIndex(index);
  9. return (HSSFSheet) _sheets.get(index);
  10. }

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

  1. @Override
  2. public void setSheetVisibility(int sheetIx, SheetVisibility visibility) {
  3. validateSheetIndex(sheetIx);
  4. workbook.setSheetHidden(sheetIx, visibility);
  5. }

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

  1. /**
  2. * @return Sheet name for the specified index
  3. */
  4. @Override
  5. public String getSheetName(int sheetIndex) {
  6. validateSheetIndex(sheetIndex);
  7. return workbook.getSheetName(sheetIndex);
  8. }

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

  1. @Override
  2. public boolean isSheetHidden(int sheetIx) {
  3. validateSheetIndex(sheetIx);
  4. return workbook.isSheetHidden(sheetIx);
  5. }

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

  1. @Override
  2. public boolean isSheetVeryHidden(int sheetIx) {
  3. validateSheetIndex(sheetIx);
  4. return workbook.isSheetVeryHidden(sheetIx);
  5. }

代码示例来源:origin: org.openl.rules/org.openl.lib.poi.dev

  1. /**
  2. * @return Sheet name for the specified index
  3. */
  4. public String getSheetName(int sheetIndex) {
  5. validateSheetIndex(sheetIndex);
  6. return workbook.getSheetName(sheetIndex);
  7. }

代码示例来源:origin: com.haulmont.thirdparty/poi

  1. /**
  2. * @return Sheet name for the specified index
  3. */
  4. public String getSheetName(int sheetIndex) {
  5. validateSheetIndex(sheetIndex);
  6. return workbook.getSheetName(sheetIndex);
  7. }

代码示例来源:origin: com.haulmont.thirdparty/poi

  1. public void setSheetHidden(int sheetIx, int hidden) {
  2. validateSheetIndex(sheetIx);
  3. WorkbookUtil.validateSheetState(hidden);
  4. workbook.setSheetHidden(sheetIx, hidden);
  5. }

代码示例来源:origin: org.openl.rules/org.openl.lib.poi.dev

  1. public void setSheetHidden(int sheetIx, int hidden) {
  2. validateSheetIndex(sheetIx);
  3. WorkbookUtil.validateSheetState(hidden);
  4. workbook.setSheetHidden(sheetIx, hidden);
  5. }

相关文章

HSSFWorkbook类方法