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

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

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

HSSFSheet.getPhysicalNumberOfRows介绍

[英]Returns the number of physically defined rows (NOT the number of rows in the sheet)
[中]返回物理定义的行数(而不是工作表中的行数)

代码示例

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

rows = sheet.getPhysicalNumberOfRows();

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

HSSFSheet worksheet = workbook.getSheet("Role_Mapping");
int rowsNum = worksheet.getPhysicalNumberOfRows();

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

InputStream fs = new FileInputStream("test.xls");
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);
sheet.getPhysicalNumberOfRows());

代码示例来源:origin: com.bstek.ureport/ureport2-console

private int buildMaxColumn(HSSFSheet sheet){
  int rowCount=sheet.getPhysicalNumberOfRows();
  int maxColumnCount=0;
  for(int i=0;i<rowCount;i++){
    HSSFRow row=sheet.getRow(i);
    if(row==null){
      continue;
    }
    int columnCount=row.getPhysicalNumberOfCells();
    if(columnCount>maxColumnCount){
      maxColumnCount=columnCount;
    }
  }
  return maxColumnCount;
}

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

if(sheet.getPhysicalNumberOfRows()-1>temp-1)

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

rows = sheet.getPhysicalNumberOfRows();

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

rows = sheet.getPhysicalNumberOfRows();

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

int rows = sheet.getPhysicalNumberOfRows();
Insets insets = cellRenderer.getInsets();

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

int rows = sheet.getPhysicalNumberOfRows();
Insets insets = cellRenderer.getInsets();

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

protected float processSheet( HSSFWorkbook workbook, HSSFSheet sheet,
    Element flow )
  final int physicalNumberOfRows = sheet.getPhysicalNumberOfRows();
  if ( physicalNumberOfRows <= 0 )
    return 0;

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

int rows = sheet.getPhysicalNumberOfRows();
System.out.println("Sheet " + wb.getNumberOfSheets() + " \"" + wb.getSheetName(0) + "\" has " + rows    + " row(s).");

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

int rows = sheet.getPhysicalNumberOfRows();
Insets insets = cellRenderer.getInsets();

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

protected float processSheet( HSSFWorkbook workbook, HSSFSheet sheet,
    Element flow )
  final int physicalNumberOfRows = sheet.getPhysicalNumberOfRows();
  if ( physicalNumberOfRows <= 0 )
    return 0;

代码示例来源:origin: dk.eobjects.commons/MetaModel

if (sheet != null && sheet.getPhysicalNumberOfRows() > 1) {
  for (int i = 1; i < sheet.getPhysicalNumberOfRows(); i++) {
    if (maxRows == 0) {
      break;

代码示例来源:origin: riotfamily/riot

private void updateMessages(byte[] data, Site site) throws IOException {
  HSSFWorkbook wb = new HSSFWorkbook(new ByteArrayInputStream(data));
  HSSFSheet sheet = wb.getSheet("Translations");
  
  if (isValid(sheet)) {
    for (int i = 1; i < sheet.getPhysicalNumberOfRows(); i++) {
      HSSFRow row = sheet.getRow(i);
      if (row.getCell(1) != null && row.getCell(3) != null) {
        String code = row.getCell(1).getRichStringCellValue().getString();
        String translation = row.getCell(3).getRichStringCellValue().getString();
        if (StringUtils.hasText(translation)) {
          MessageBundleEntry entry = MessageBundleEntry.loadByBundleAndCode(bundle, code);
          if (entry != null) {
            entry.addTranslation(site.getLocale(), translation);
            entry.save();                    
          }
          else {
            log.info("Message Code does not exist - " + code);
          }
        }
      }
      else {
        log.info("Skipping invalid row {}" , i);
      }
    }
  }
}

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

protected void processSheet( HSSFSheet sheet ) {
  processSheetHeader( htmlDocumentFacade.getBody(), sheet );
  final int physicalNumberOfRows = sheet.getPhysicalNumberOfRows();
  if ( physicalNumberOfRows <= 0 )
    return;

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

final int physicalNumberOfRows = sheet.getPhysicalNumberOfRows();
if ( physicalNumberOfRows <= 0 )
  return;

代码示例来源:origin: riotfamily/riot

for (int i = 1; i < sheet.getPhysicalNumberOfRows(); i++) {
  HSSFRow row = sheet.getRow(i);
  if (row.getCell(1) != null && row.getCell(2) != null) {

代码示例来源:origin: dk.eobjects.commons/MetaModel

if (currentSheet.getPhysicalNumberOfRows() > 0) {
  Table table = new Table(wb.getSheetName(i));
  HSSFRow row = currentSheet.getRow(0);

代码示例来源:origin: paypal/SeLion

public void generateRep(HSSFWorkbook wb, String sheetName, List<BaseReport<?>> lstReports) {
  logger.entering(new Object[] { wb, sheetName, lstReports });
  int rowNum = 0;
  int iColStart = startColNum;
  HSSFSheet sheet;
  if (wb.getSheet(sheetName) == null) {
    sheet = wb.createSheet(sheetName);
  } else {
    sheet = wb.getSheet(sheetName);
    rowNum = sheet.getPhysicalNumberOfRows() + 2;
  }
  for (BaseReport<?> br : lstReports) {
    br.createReportName(sheet, rowNum++, iColStart, Styles.getHeadingStyle());
    br.createTitles(sheet, rowNum++, iColStart, Styles.getSubHeading2Style());
    rowNum = br.fillData(sheet, rowNum++, Styles.getStyleBorderThinCenter());
    rowNum += 3;
  }
  logger.exiting();
}

相关文章

微信公众号

最新文章

更多

HSSFSheet类方法