org.apache.poi.ss.usermodel.Sheet.removeRow()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(4.2k)|赞(0)|评价(0)|浏览(164)

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

Sheet.removeRow介绍

[英]Remove a row from this sheet. All cells contained in the row are removed as well
[中]从这张纸上删除一行。行中包含的所有单元格也将被删除

代码示例

代码示例来源:origin: pentaho/pentaho-kettle

int aNewSheetRowCount = aNewSheet.getLastRowNum();
while ( currentRowNum > aNewSheetRowCount ) {
 templateSheet.removeRow( templateSheet.getRow( currentRowNum ) );
 currentRowNum--;

代码示例来源:origin: SheetJS/jxls

private static void deleteRow(Sheet sheet, Row rowToDelete) {
  if (rowToDelete != null) {
    sheet.removeRow(rowToDelete);
  }
}

代码示例来源:origin: net.sf.jxls/jxls-core

private static void deleteRow(Sheet sheet, Row rowToDelete) {
  if (rowToDelete != null) {
    sheet.removeRow(rowToDelete);
  }
}

代码示例来源:origin: org.paxml/PaxmlCore

@Override
public void remove() {
  Row row = sheet.getRow(index);
  if (row != null) {
    sheet.removeRow(row);
  }
}

代码示例来源:origin: spdx/tools

/**
 * Clears all data from the worksheet
 */
public void clear() {
  for (int i = lastRowNum; i > firstRowNum; i--) {
    Row row = sheet.getRow(i);
    sheet.removeRow(row);
  }
  lastRowNum = firstRowNum;
}

代码示例来源:origin: org.spdx/spdx-tools

/**
 * Clears all data from the worksheet
 */
public void clear() {
  for (int i = lastRowNum; i > firstRowNum; i--) {
    Row row = sheet.getRow(i);
    sheet.removeRow(row);
  }
  lastRowNum = firstRowNum;
}

代码示例来源:origin: org.paxml/paxml-core

@Override
public void remove() {
  Row row = sheet.getRow(index);
  if (row != null) {
    sheet.removeRow(row);
  }
}

代码示例来源:origin: org.eclipse.epsilon/epsilon-spreadsheets

@Override
public void removeRow(final SpreadsheetRow row)
{
  LOGGER.debug("Inside removeRow() method");
  LOGGER.debug("Row: " + row);
  if (row != null)
  {
    final ExcelRow excelRow = (ExcelRow) row;
    final int rowIndex = excelRow.row.getRowNum();
    final int lastRowNum = this.sheet.getLastRowNum();
    this.sheet.removeRow(excelRow.row);
    if (rowIndex >= this.getFirstRowIndex() && rowIndex < lastRowNum)
    {
      sheet.shiftRows(rowIndex + 1, lastRowNum, -1);
    }
  }
}

代码示例来源:origin: cn.t/doc-util

@Override
public void readSheetComplete(Sheet sheet) {
  if (logger.isDebugEnabled()) {
    logger.debug("sheet: {} read complete", sheet.getSheetName());
  }
  for (int i = rowLIndexToBeRemoved.size() - 1; i > -1; i--) {
    Row row = sheet.getRow(rowLIndexToBeRemoved.get(i));
    if (row == null) {
      if (rowLIndexToBeRemoved.get(i) < sheet.getLastRowNum()) {
        sheet.shiftRows(rowLIndexToBeRemoved.get(i) + 1, sheet.getLastRowNum(), -1);
      }
    } else {
      try {
        if (row.getRowNum() < sheet.getLastRowNum()) {
          sheet.shiftRows(row.getRowNum() + 1, sheet.getLastRowNum(), -1);
        } else {
          sheet.removeRow(row);
        }
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  rowLIndexToBeRemoved.clear();
}

代码示例来源:origin: cpesch/RouteConverter

public ExcelPosition remove(int index) {
  // shift all rows one forward to index
  int rowForIndex = getPosition(index).getRow().getRowNum() + 1;
  int lastRowNum = sheet.getLastRowNum();
  sheet.shiftRows(rowForIndex, lastRowNum, -1);
  // remove last row
  Row row = sheet.getRow(lastRowNum);
  if (row != null)
    sheet.removeRow(row);
  return super.remove(index);
}

代码示例来源:origin: apache/metamodel

sheet.removeRow(row);

代码示例来源:origin: org.apache.metamodel/MetaModel-excel

sheet.removeRow(row);

代码示例来源:origin: QihooTest/Leo

private void delBankRow() {
  for (int i = 0; i <= getRowNum(); i++) {
    Row r;
    try {
      r = sheet.getRow(i);
    } catch (Exception e) {
      r = null;
      // sheet.removeRowBreak(i);
      continue;
    }
    if (r == null && i == sheet.getLastRowNum()) {
      // 如果是空行,且到了最后一行,直接将那一行删掉
      sheet.removeRow(r);
    } else if (r == null && i < sheet.getLastRowNum()) {
      // 如果还没到最后一行,则数据往上移一行
      sheet.shiftRows(i + 1, sheet.getLastRowNum(), -1);
    }
  }
}

代码示例来源:origin: org.eobjects.metamodel/MetaModel-excel

sheet.removeRow(row);

代码示例来源:origin: org.teiid.connectors/translator-excel

private void handleDelete() throws TranslatorException {
  while (true) {
    Row row = nextRow();
    if (row == null) {
      break;
    }
    this.rowIterator = null;
    int start = row.getRowNum();
    Sheet sheet = row.getSheet();
    int end = sheet.getLastRowNum();
    //a different iteration style is needed, which will not perform as well for sparse documents
    for (int i = start; i <= end; i++) {
      row = sheet.getRow(i);
      if (row == null) {
        continue;
      }
      if (row.getFirstCellNum() == -1) {
        continue;
      }
      
      if (!this.visitor.allows(row.getRowNum())) {
        continue;
      }
      sheet.removeRow(row);
      result++;
      modified = true;
    }
  }
}

代码示例来源:origin: org.datanucleus/datanucleus-excel

sheet.removeRow(sheet.getRow(rowId));
if (sheet.getLastRowNum()>rowId)

相关文章

微信公众号

最新文章

更多