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

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

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

HSSFSheet.getFirstRowNum介绍

[英]Gets the first row on the sheet
[中]获取工作表上的第一行

代码示例

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

/**
 * add a row to the sheet
 *
 * @param addLow whether to add the row to the low level model - false if its already there
 */
private void addRow(HSSFRow row, boolean addLow) {
  _rows.put(Integer.valueOf(row.getRowNum()), row);
  if (addLow) {
    _sheet.addRow(row.getRowRecord());
  }
  boolean firstRow = _rows.size() == 1;
  if (row.getRowNum() > getLastRowNum() || firstRow) {
    _lastrow = row.getRowNum();
  }
  if (row.getRowNum() < getFirstRowNum() || firstRow) {
    _firstrow = row.getRowNum();
  }
}

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

_lastrow = findLastRow(_lastrow);
if (hrow.getRowNum() == getFirstRowNum()) {
  _firstrow = findFirstRow(_firstrow);

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

int firstRow = sheet.getFirstRowNum();
int lastRow = sheet.getLastRowNum();
for(int j=firstRow;j<=lastRow;j++) {

代码示例来源:origin: stackoverflow.com

HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(inputFile));
workbook.setMissingCellPolicy(Row.CREATE_NULL_AS_BLANK);

HSSFSheet sheet = workbook.getSheetAt(0);
for(int rowIndex = sheet.getFirstRowNum(); rowIndex < sheet.getLastRowNum(); rowIndex++)
{
    Cell cell=null;
    Row row = null;

    previousCell = -1;
    currentCell = 0;
    row = sheet.getRow(rowIndex);
    for(int colIndex=row.getFirstCellNum(); colIndex < row.getLastCellNum(); colIndex++)
      {
         cell = row.getCell(colIndex);
         currentCell = cell.getColumnIndex();

         /* Cell processing starts here*/
      }
  }

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

/**
 * add a row to the sheet
 *
 * @param addLow whether to add the row to the low level model - false if its already there
 */
private void addRow(HSSFRow row, boolean addLow) {
  _rows.put(Integer.valueOf(row.getRowNum()), row);
  if (addLow) {
    _sheet.addRow(row.getRowRecord());
  }
  boolean firstRow = _rows.size() == 1;
  if (row.getRowNum() > getLastRowNum() || firstRow) {
    _lastrow = row.getRowNum();
  }
  if (row.getRowNum() < getFirstRowNum() || firstRow) {
    _firstrow = row.getRowNum();
  }
}

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

/**
 * add a row to the sheet
 *
 * @param addLow whether to add the row to the low level model - false if its already there
 */
private void addRow(HSSFRow row, boolean addLow) {
  _rows.put(Integer.valueOf(row.getRowNum()), row);
  if (addLow) {
    _sheet.addRow(row.getRowRecord());
  }
  boolean firstRow = _rows.size() == 1;
  if (row.getRowNum() > getLastRowNum() || firstRow) {
    _lastrow = row.getRowNum();
  }
  if (row.getRowNum() < getFirstRowNum() || firstRow) {
    _firstrow = row.getRowNum();
  }
}

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

/**
 * add a row to the sheet
 *
 * @param addLow whether to add the row to the low level model - false if its already there
 */
private void addRow(HSSFRow row, boolean addLow)
{
  _rows.put(Integer.valueOf(row.getRowNum()), row);
  if (addLow)
  {
    _sheet.addRow(row.getRowRecord());
  }
  boolean firstRow = _rows.size() == 1;
  if (row.getRowNum() > getLastRowNum() || firstRow)
  {
    _lastrow = row.getRowNum();
  }
  if (row.getRowNum() < getFirstRowNum() || firstRow)
  {
    _firstrow = row.getRowNum();
  }
}

代码示例来源:origin: cuba-platform/yarg

protected void cleanupCells(HSSFSheet resultSheet) {
  for (int i = resultSheet.getFirstRowNum(); i <= resultSheet.getLastRowNum(); i++) {
    HSSFRow row = resultSheet.getRow(i);
    if (row != null) {
      for (int j = 0; j < row.getLastCellNum(); j++) {
        HSSFCell cell = row.getCell(j);
        if (cell != null) {
          row.removeCell(cell);
        }
      }
    }
  }
}

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

protected void cleanupCells(HSSFSheet resultSheet) {
  for (int i = resultSheet.getFirstRowNum(); i <= resultSheet.getLastRowNum(); i++) {
    HSSFRow row = resultSheet.getRow(i);
    if (row != null) {
      for (int j = 0; j < row.getLastCellNum(); j++) {
        HSSFCell cell = row.getCell(j);
        if (cell != null) {
          row.removeCell(cell);
        }
      }
    }
  }
}

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

physicalNumberOfRows);
int maxSheetColumns = 1;
for ( int r = sheet.getFirstRowNum(); r <= sheet.getLastRowNum(); r++ )

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

physicalNumberOfRows );
int maxSheetColumns = 1;
for ( int r = sheet.getFirstRowNum(); r <= sheet.getLastRowNum(); r++ )

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

if (hrow.getRowNum() == getFirstRowNum())

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

_lastrow = findLastRow(_lastrow);
if (hrow.getRowNum() == getFirstRowNum()) {
  _firstrow = findFirstRow(_firstrow);

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

_lastrow = findLastRow(_lastrow);
if (hrow.getRowNum() == getFirstRowNum()) {
  _firstrow = findFirstRow(_firstrow);

代码示例来源:origin: ModeShape/modeshape

for (int rowNum = worksheet.getFirstRowNum(); rowNum <= lastRowNum; rowNum++) {
  HSSFRow row = worksheet.getRow(rowNum);

代码示例来源:origin: org.modeshape/modeshape-sequencer-msoffice

for (int rowNum = worksheet.getFirstRowNum(); rowNum <= lastRowNum; rowNum++) {
  HSSFRow row = worksheet.getRow(rowNum);

代码示例来源:origin: com.github.mg365/mg-common

int rowNum = sheet.getFirstRowNum();
while (rowNum <= sheet.getLastRowNum()) {
  Row row = sheet.getRow(rowNum);

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

physicalNumberOfRows);
int maxSheetColumns = 1;
for ( int r = sheet.getFirstRowNum(); r <= sheet.getLastRowNum(); r++ ) {
  HSSFRow row = sheet.getRow( r );

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

TableModel model = getModel();
for (int i = 0; i < model.getRowCount(); i++) {
 Row row = sheet.getRow(i - sheet.getFirstRowNum());
 if (row != null) {
  short h = row.getHeight();

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

physicalNumberOfRows );
int maxSheetColumns = 1;
for ( int r = sheet.getFirstRowNum(); r <= sheet.getLastRowNum(); r++ )

相关文章

微信公众号

最新文章

更多

HSSFSheet类方法