本文整理了Java中org.apache.poi.ss.usermodel.Sheet.removeRow()
方法的一些代码示例,展示了Sheet.removeRow()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Sheet.removeRow()
方法的具体详情如下:
包路径:org.apache.poi.ss.usermodel.Sheet
类名称: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)
内容来源于网络,如有侵权,请联系作者删除!