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

HSSFSheet.getCellRange介绍

[英]Also creates cells if they don't exist
[中]如果单元格不存在，也会创建单元格

代码示例

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

@Override
public CellRange<HSSFCell> removeArrayFormula(Cell cell) {
  if (cell.getSheet() != this) {
    throw new IllegalArgumentException("Specified cell does not belong to this sheet.");
  }
  CellValueRecordInterface rec = ((HSSFCell) cell).getCellValueRecord();
  if (!(rec instanceof FormulaRecordAggregate)) {
    String ref = new CellReference(cell).formatAsString();
    throw new IllegalArgumentException("Cell " + ref + " is not part of an array formula.");
  }
  FormulaRecordAggregate fra = (FormulaRecordAggregate) rec;
  CellRangeAddress range = fra.removeArrayFormula(cell.getRowIndex(), cell.getColumnIndex());
  CellRange<HSSFCell> result = getCellRange(range);
  // clear all cells in the range
  for (Cell c : result) {
    c.setCellType(CellType.BLANK);
  }
  return result;
}

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

@Override
public CellRange<HSSFCell> setArrayFormula(String formula, CellRangeAddress range) {
  // make sure the formula parses OK first
  int sheetIndex = _workbook.getSheetIndex(this);
  Ptg[] ptgs = HSSFFormulaParser.parse(formula, _workbook, FormulaType.ARRAY, sheetIndex);
  CellRange<HSSFCell> cells = getCellRange(range);
  for (HSSFCell c : cells) {
    c.setCellArrayFormula(range);
  }
  HSSFCell mainArrayFormulaCell = cells.getTopLeftCell();
  FormulaRecordAggregate agg = (FormulaRecordAggregate) mainArrayFormulaCell.getCellValueRecord();
  agg.setArrayFormula(range, ptgs);
  return cells;
}

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

public CellRange<HSSFCell> removeArrayFormula(Cell cell) {
  if (cell.getSheet() != this) {
    throw new IllegalArgumentException("Specified cell does not belong to this sheet.");
  }
  CellValueRecordInterface rec = ((HSSFCell) cell).getCellValueRecord();
  if (!(rec instanceof FormulaRecordAggregate)) {
    String ref = new CellReference(cell).formatAsString();
    throw new IllegalArgumentException("Cell " + ref + " is not part of an array formula.");
  }
  FormulaRecordAggregate fra = (FormulaRecordAggregate) rec;
  CellRangeAddress range = fra.removeArrayFormula(cell.getRowIndex(), cell.getColumnIndex());
  CellRange<HSSFCell> result = getCellRange(range);
  // clear all cells in the range
  for (Cell c : result) {
    c.setCellType(Cell.CELL_TYPE_BLANK);
  }
  return result;
}

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

public CellRange<HSSFCell> removeArrayFormula(Cell cell) {
  if (cell.getSheet() != this) {
    throw new IllegalArgumentException("Specified cell does not belong to this sheet.");
  }
  CellValueRecordInterface rec = ((HSSFCell) cell).getCellValueRecord();
  if (!(rec instanceof FormulaRecordAggregate)) {
    String ref = new CellReference(cell).formatAsString();
    throw new IllegalArgumentException("Cell " + ref + " is not part of an array formula.");
  }
  FormulaRecordAggregate fra = (FormulaRecordAggregate) rec;
  CellRangeAddress range = fra.removeArrayFormula(cell.getRowIndex(), cell.getColumnIndex());
  CellRange<HSSFCell> result = getCellRange(range);
  // clear all cells in the range
  for (Cell c : result) {
    c.setCellType(Cell.CELL_TYPE_BLANK);
  }
  return result;
}

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

@Override
public CellRange<HSSFCell> removeArrayFormula(Cell cell) {
  if (cell.getSheet() != this) {
    throw new IllegalArgumentException("Specified cell does not belong to this sheet.");
  }
  CellValueRecordInterface rec = ((HSSFCell) cell).getCellValueRecord();
  if (!(rec instanceof FormulaRecordAggregate)) {
    String ref = new CellReference(cell).formatAsString();
    throw new IllegalArgumentException("Cell " + ref + " is not part of an array formula.");
  }
  FormulaRecordAggregate fra = (FormulaRecordAggregate) rec;
  CellRangeAddress range = fra.removeArrayFormula(cell.getRowIndex(), cell.getColumnIndex());
  CellRange<HSSFCell> result = getCellRange(range);
  // clear all cells in the range
  for (Cell c : result) {
    c.setCellType(CellType.BLANK);
  }
  return result;
}

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

public CellRange<HSSFCell> setArrayFormula(String formula, CellRangeAddress range) {
  // make sure the formula parses OK first
  int sheetIndex = _workbook.getSheetIndex(this);
  Ptg[] ptgs = HSSFFormulaParser.parse(formula, _workbook, FormulaType.ARRAY, sheetIndex);
  CellRange<HSSFCell> cells = getCellRange(range);
  for (HSSFCell c : cells) {
    c.setCellArrayFormula(range);
  }
  HSSFCell mainArrayFormulaCell = cells.getTopLeftCell();
  FormulaRecordAggregate agg = (FormulaRecordAggregate) mainArrayFormulaCell.getCellValueRecord();
  agg.setArrayFormula(range, ptgs);
  return cells;
}

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

public CellRange<HSSFCell> setArrayFormula(String formula, CellRangeAddress range) {
  // make sure the formula parses OK first
  int sheetIndex = _workbook.getSheetIndex(this);
  Ptg[] ptgs = HSSFFormulaParser.parse(formula, _workbook, FormulaType.ARRAY, sheetIndex);
  CellRange<HSSFCell> cells = getCellRange(range);
  for (HSSFCell c : cells) {
    c.setCellArrayFormula(range);
  }
  HSSFCell mainArrayFormulaCell = cells.getTopLeftCell();
  FormulaRecordAggregate agg = (FormulaRecordAggregate)mainArrayFormulaCell.getCellValueRecord();
  agg.setArrayFormula(range, ptgs);
  return cells;
}

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

@Override
public CellRange<HSSFCell> setArrayFormula(String formula, CellRangeAddress range) {
  // make sure the formula parses OK first
  int sheetIndex = _workbook.getSheetIndex(this);
  Ptg[] ptgs = HSSFFormulaParser.parse(formula, _workbook, FormulaType.ARRAY, sheetIndex);
  CellRange<HSSFCell> cells = getCellRange(range);
  for (HSSFCell c : cells) {
    c.setCellArrayFormula(range);
  }
  HSSFCell mainArrayFormulaCell = cells.getTopLeftCell();
  FormulaRecordAggregate agg = (FormulaRecordAggregate) mainArrayFormulaCell.getCellValueRecord();
  agg.setArrayFormula(range, ptgs);
  return cells;
}