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