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

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

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

HSSFSheet.setSelected介绍

[英]Sets whether sheet is selected.
[中]设置是否选择图纸。

代码示例

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

/**
 * create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns
 * the high level representation.  Use this to create new sheets.
 *
 * @return HSSFSheet representing the new sheet.
 */
@Override
public HSSFSheet createSheet()
{
  HSSFSheet sheet = new HSSFSheet(this);
  _sheets.add(sheet);
  workbook.setSheetName(_sheets.size() - 1, "Sheet" + (_sheets.size() - 1));
  boolean isOnlySheet = _sheets.size() == 1;
  sheet.setSelected(isOnlySheet);
  sheet.setActive(isOnlySheet);
  return sheet;
}

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

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

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

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

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

_sheets.add(sheet);
boolean isOnlySheet = _sheets.size() == 1;
sheet.setSelected(isOnlySheet);
sheet.setActive(isOnlySheet);
return sheet;

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

String srcName = workbook.getSheetName(sheetIndex);
HSSFSheet clonedSheet = srcSheet.cloneSheet(this);
clonedSheet.setSelected(false);
clonedSheet.setActive(false);

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

/**
 * create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns
 * the high level representation.  Use this to create new sheets.
 *
 * @return HSSFSheet representing the new sheet.
 */
public HSSFSheet createSheet()
{
  HSSFSheet sheet = new HSSFSheet(this);
  _sheets.add(sheet);
  workbook.setSheetName(_sheets.size() - 1, "Sheet" + (_sheets.size() - 1));
  boolean isOnlySheet = _sheets.size() == 1;
  sheet.setSelected(isOnlySheet);
  sheet.setActive(isOnlySheet);
  return sheet;
}

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

/**
 * create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns
 * the high level representation.  Use this to create new sheets.
 *
 * @return HSSFSheet representing the new sheet.
 */
public HSSFSheet createSheet()
{
  HSSFSheet sheet = new HSSFSheet(this);
  _sheets.add(sheet);
  workbook.setSheetName(_sheets.size() - 1, "Sheet" + (_sheets.size() - 1));
  boolean isOnlySheet = _sheets.size() == 1;
  sheet.setSelected(isOnlySheet);
  sheet.setActive(isOnlySheet);
  return sheet;
}

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

/**
 * create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns
 * the high level representation.  Use this to create new sheets.
 *
 * @return HSSFSheet representing the new sheet.
 */
@Override
public HSSFSheet createSheet()
{
  HSSFSheet sheet = new HSSFSheet(this);
  _sheets.add(sheet);
  workbook.setSheetName(_sheets.size() - 1, "Sheet" + (_sheets.size() - 1));
  boolean isOnlySheet = _sheets.size() == 1;
  sheet.setSelected(isOnlySheet);
  sheet.setActive(isOnlySheet);
  return sheet;
}

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

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

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

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

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

/**
 * Selects a single sheet. This may be different to
 * the 'active' sheet (which is the sheet with focus).
 */
public void setSelectedTab(int index) {
  validateSheetIndex(index);
  int nSheets = _sheets.size();
  for (int i=0; i<nSheets; i++) {
      getSheetAt(i).setSelected(i == index);
  }
  workbook.getWindowOne().setNumSelectedTabs((short)1);
}
/**

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

/**
 * Selects a single sheet. This may be different to
 * the 'active' sheet (which is the sheet with focus).
 */
public void setSelectedTab(int index) {
  validateSheetIndex(index);
  int nSheets = _sheets.size();
  for (int i=0; i<nSheets; i++) {
      getSheetAt(i).setSelected(i == index);
  }
  workbook.getWindowOne().setNumSelectedTabs((short)1);
}
/**

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

public void setSelectedTabs(int[] indexes) {
  for (int i = 0; i < indexes.length; i++) {
    validateSheetIndex(indexes[i]);
  }
  int nSheets = _sheets.size();
  for (int i=0; i<nSheets; i++) {
    boolean bSelect = false;
    for (int j = 0; j < indexes.length; j++) {
      if (indexes[j] == i) {
        bSelect = true;
        break;
      }
    }
      getSheetAt(i).setSelected(bSelect);
  }
  workbook.getWindowOne().setNumSelectedTabs((short)indexes.length);
}
/**

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

_sheets.add(sheet);
boolean isOnlySheet = _sheets.size() == 1;
sheet.setSelected(isOnlySheet);
sheet.setActive(isOnlySheet);
return sheet;

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

_sheets.add(sheet);
boolean isOnlySheet = _sheets.size() == 1;
sheet.setSelected(isOnlySheet);
sheet.setActive(isOnlySheet);
return sheet;

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

_sheets.add(sheet);
boolean isOnlySheet = _sheets.size() == 1;
sheet.setSelected(isOnlySheet);
sheet.setActive(isOnlySheet);
return sheet;

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

public void setSelectedTabs(int[] indexes) {
  for (int i = 0; i < indexes.length; i++) {
    validateSheetIndex(indexes[i]);
  }
  int nSheets = _sheets.size();
  for (int i=0; i<nSheets; i++) {
    boolean bSelect = false;
    for (int j = 0; j < indexes.length; j++) {
      if (indexes[j] == i) {
        bSelect = true;
        break;
      }
    }
      getSheetAt(i).setSelected(bSelect);
  }
  workbook.getWindowOne().setNumSelectedTabs((short)indexes.length);
}
/**

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

String srcName = workbook.getSheetName(sheetIndex);
HSSFSheet clonedSheet = srcSheet.cloneSheet(this);
clonedSheet.setSelected(false);
clonedSheet.setActive(false);

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

String srcName = workbook.getSheetName(sheetIndex);
HSSFSheet clonedSheet = srcSheet.cloneSheet(this);
clonedSheet.setSelected(false);
clonedSheet.setActive(false);

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

/**
 * create an HSSFSheet from an existing sheet in the HSSFWorkbook.
 *
 * @return HSSFSheet representing the cloned sheet.
 */
public HSSFSheet cloneSheet(int sheetIndex) {
  validateSheetIndex(sheetIndex);
  HSSFSheet srcSheet = _sheets.get(sheetIndex);
  String srcName = workbook.getSheetName(sheetIndex);
  HSSFSheet clonedSheet = srcSheet.cloneSheet(this);
  clonedSheet.setSelected(false);
  clonedSheet.setActive(false);
  String name = getUniqueSheetName(srcName);
  int newSheetIndex = _sheets.size();
  _sheets.add(clonedSheet);
  workbook.setSheetName(newSheetIndex, name);
  // Check this sheet has an autofilter, (which has a built-in NameRecord at workbook level)
  int filterDbNameIndex = findExistingBuiltinNameRecordIdx(sheetIndex, NameRecord.BUILTIN_FILTER_DB);
  if (filterDbNameIndex != -1) {
    NameRecord newNameRecord = workbook.cloneFilter(filterDbNameIndex, newSheetIndex);
    HSSFName newName = new HSSFName(this, newNameRecord);
    names.add(newName);
  }
  // TODO - maybe same logic required for other/all built-in name records
  workbook.cloneDrawings(clonedSheet.getSheet());
  return clonedSheet;
}

相关文章

微信公众号

最新文章

更多

HSSFSheet类方法