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

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

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

Sheet.getFirstRowNum介绍

[英]Gets the first row on the sheet. Note: rows which had content before and were set to empty later might still be counted as rows by Excel and Apache POI, so the result of this method will include such rows and thus the returned value might be lower than expected!
[中]获取工作表上的第一行。注意：Excel和Apache POI可能仍会将之前有内容但后来设置为空的行计为行，因此此方法的结果将包括这些行，因此返回值可能低于预期值！

代码示例

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

/**
 * Compute width of a column and return the result
 *
 * @param sheet the sheet to calculate
 * @param column    0-based index of the column
 * @param useMergedCells    whether to use merged cells
 * @return  the width in pixels or -1 if all cells are empty
 */
public static double getColumnWidth(Sheet sheet, int column, boolean useMergedCells) {
  return getColumnWidth(sheet, column, useMergedCells, sheet.getFirstRowNum(), sheet.getLastRowNum());
}

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

public KCell[] getRow( int rownr ) {
 if ( rownr < sheet.getFirstRowNum() ) {
  return new KCell[] {};
 } else if ( rownr > sheet.getLastRowNum() ) {
  throw new ArrayIndexOutOfBoundsException( "Read beyond last row: " + rownr );
 }
 Row row = sheet.getRow( rownr );
 if ( row == null ) { // read an empty row
  return new KCell[] {};
 }
 int cols = row.getLastCellNum();
 if ( cols < 0 ) { // this happens if a row has no cells, POI returns -1 then
  return new KCell[] {};
 }
 PoiCell[] xlsCells = new PoiCell[cols];
 for ( int i = 0; i < cols; i++ ) {
  Cell cell = row.getCell( i );
  if ( cell != null ) {
   xlsCells[i] = new PoiCell( cell );
  }
 }
 return xlsCells;
}

代码示例来源：origin: looly/hutool

List<List<Object>> resultList = new ArrayList<>();
startRowIndex = Math.max(startRowIndex, this.sheet.getFirstRowNum());// 读取起始行（包含）
endRowIndex = Math.min(endRowIndex, this.sheet.getLastRowNum());// 读取结束行（包含）
boolean isFirstLine = true;

代码示例来源：origin: looly/hutool

List<List<Object>> resultList = new ArrayList<>();
startRowIndex = Math.max(startRowIndex, this.sheet.getFirstRowNum());// 读取起始行（包含）
endRowIndex = Math.min(endRowIndex, this.sheet.getLastRowNum());// 读取结束行（包含）
boolean isFirstLine = true;

代码示例来源：origin: looly/hutool

checkNotClosed();
final int firstRowNum = sheet.getFirstRowNum();
final int lastRowNum = sheet.getLastRowNum();
if (headerRowIndex < firstRowNum) {

代码示例来源：origin: looly/hutool

checkNotClosed();
final int firstRowNum = sheet.getFirstRowNum();
final int lastRowNum = sheet.getLastRowNum();
if (headerRowIndex < firstRowNum) {

代码示例来源：origin: neo4j-contrib/neo4j-apoc-procedures

public XLSSpliterator(Sheet sheet, Selection selection, String[] header, String url, long skip, long limit, boolean ignore, Map<String, Mapping> mapping, List<Object> nullValues) throws IOException {
  super(Long.MAX_VALUE, Spliterator.ORDERED);
  this.sheet = sheet;
  this.selection = selection;
  this.header = header;
  this.url = url;
  this.ignore = ignore;
  this.mapping = mapping;
  this.nullValues = nullValues;
  int headerOffset = header != null ? 1 : 0;
  this.skip = skip + selection.getOrDefault(selection.top, sheet.getFirstRowNum()) + headerOffset;
  this.limit = limit == Long.MAX_VALUE ? selection.getOrDefault(selection.bottom, sheet.getLastRowNum()) : skip + limit;
  lineNo = this.skip;
}

代码示例来源：origin: neo4j-contrib/neo4j-apoc-procedures

@Procedure("apoc.load.xls")
@Description("apoc.load.xls('url','selector',{config}) YIELD lineNo, list, map - load XLS fom URL as stream of row values,\n config contains any of: {skip:1,limit:5,header:false,ignore:['tmp'],arraySep:';',mapping:{years:{type:'int',arraySep:'-',array:false,name:'age',ignore:false, dateFormat:'iso_date', dateParse:['dd-MM-yyyy']}}")
public Stream<XLSResult> xls(@Name("url") String url, @Name("selector") String selector, @Name(value = "config",defaultValue = "{}") Map<String, Object> config) {
  boolean failOnError = booleanValue(config, "failOnError", true);
  try (CountingInputStream stream = FileUtils.inputStreamFor(url)) {
    Selection selection = new Selection(selector);
    char arraySep = separator(config, "arraySep", DEFAULT_ARRAY_SEP);
    long skip = longValue(config, "skip", 0L);
    boolean hasHeader = booleanValue(config, "header", true);
    long limit = longValue(config, "limit", Long.MAX_VALUE);
    List<String> ignore = value(config, "ignore", emptyList());
    List<Object> nullValues = value(config, "nullValues", emptyList());
    Map<String, Map<String, Object>> mapping = value(config, "mapping", Collections.emptyMap());
    Map<String, Mapping> mappings = createMapping(mapping, arraySep, ignore);
    Workbook workbook = WorkbookFactory.create(stream);
    Sheet sheet = workbook.getSheet(selection.sheet);
    if (sheet==null) throw new IllegalStateException("Sheet "+selection.sheet+" not found");
    selection.updateVertical(sheet.getFirstRowNum(),sheet.getLastRowNum());
    Row firstRow = sheet.getRow(selection.top);
    selection.updateHorizontal(firstRow.getFirstCellNum(), firstRow.getLastCellNum());
    String[] header = getHeader(hasHeader, firstRow,selection, ignore, mappings);
    boolean checkIgnore = !ignore.isEmpty() || mappings.values().stream().anyMatch( m -> m.ignore);
    return StreamSupport.stream(new XLSSpliterator(sheet, selection, header, url, skip, limit, checkIgnore,mappings, nullValues), false);
  } catch (Exception e) {
    if(!failOnError)
      return Stream.of(new  XLSResult(new String[0], new Object[0], 0, true, Collections.emptyMap(), emptyList()));
    else
      throw new RuntimeException("Can't read XLS from URL " + cleanUrl(url), e);
  }
}

代码示例来源：origin: openl-tablets/openl-tablets

public static int getMinRowIndex(Sheet sheet) {
  return sheet.getFirstRowNum();
}

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

for (Sheet sheet : workbook) {
int rowStart = sheet.getFirstRowNum();
int rowEnd = sheet.getLastRowNum();
for(int rowNum=rowStart;rowNum<rowEnd;rowNum++){
fblist.add(sheet.getRow(rowNum).getCell(0, Row.RETURN_BLANK_AS_NULL));
}
}

代码示例来源：origin: org.mazarineblue/MazarineBlue-DataSources

private int getFirstContentRow() {
  int index = sheet.getFirstRowNum();
  if (hasHeaders())
    ++index;
  return index;
}

代码示例来源：origin: org.gephi/io-importer-plugin

private void initHeaderInfo() {
  Row firstRow = sheet.getRow(sheet.getFirstRowNum());
  int zeroBasedIndex = 0;
  for (int i = rowsFirstIndex; i <= rowsLastIndex; i++) {
    Cell cell = firstRow.getCell(i);
    String header = ExcelSheetRow.getRowCellAsString(cell, i);
    if (header != null && !header.trim().isEmpty()) {
      headerMap.put(header.trim(), zeroBasedIndex);
    }
    zeroBasedIndex++;
  }
}

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

/**
 * Compute width of a column and return the result
 *
 * @param sheet the sheet to calculate
 * @param column    0-based index of the column
 * @param useMergedCells    whether to use merged cells
 * @return  the width in pixels or -1 if all cells are empty
 */
public static double getColumnWidth(Sheet sheet, int column, boolean useMergedCells) {
  return getColumnWidth(sheet, column, useMergedCells, sheet.getFirstRowNum(), sheet.getLastRowNum());
}

代码示例来源：origin: org.tinygroup/org.tinygroup.tinyscript.excel

private int getFirstRowNum() {
  if (xlsArea != null && xlsArea.getDataY() > 0) {
    return xlsArea.getDataY();
  }
  return sheet.getFirstRowNum();
}

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

public int getMaxColNum(){
  int maxColNum = 0;
  for(int i = hssfSheet.getFirstRowNum(); i <= hssfSheet.getLastRowNum(); i++){
    Row hssfRow = hssfSheet.getRow( i );
    if( hssfRow != null && (hssfRow.getLastCellNum() > maxColNum)){
        maxColNum = hssfRow.getLastCellNum();
    }
  }
  return maxColNum;
}

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

public int getMaxColNum(){
  int maxColNum = 0;
  for(int i = hssfSheet.getFirstRowNum(); i <= hssfSheet.getLastRowNum(); i++){
    Row hssfRow = hssfSheet.getRow( i );
    if( hssfRow != null && (hssfRow.getLastCellNum() > maxColNum)){
        maxColNum = hssfRow.getLastCellNum();
    }
  }
  return maxColNum;
}

代码示例来源：origin: org.databene/databene-formats

public static void autoSizeColumns(Workbook workbook) {
  int sheetCount = workbook.getNumberOfSheets();
  for (int i = 0; i < sheetCount; i++) {
    Sheet sheet = workbook.getSheetAt(i);
    int firstRowNum = sheet.getFirstRowNum();
    if (firstRowNum >= 0) {
      Row firstRow = sheet.getRow(firstRowNum);
      for (int cellnum = firstRow.getFirstCellNum(); cellnum < firstRow.getLastCellNum(); cellnum++)
        sheet.autoSizeColumn(cellnum);
    }
  }
}

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

public static void setPrintArea(Workbook resultWorkbook, int sheetNum) {
  int maxColumnNum = 0;
  for (int j = resultWorkbook.getSheetAt(sheetNum).getFirstRowNum(), c = resultWorkbook.getSheetAt(sheetNum).getLastRowNum(); j <= c; j++) {
    org.apache.poi.ss.usermodel.Row row = resultWorkbook.getSheetAt(sheetNum).getRow(j);
    if (row != null) {
      maxColumnNum = Math.max(maxColumnNum, row.getLastCellNum());
    }
  }
  resultWorkbook.setPrintArea(sheetNum, 0, maxColumnNum, 0,
      resultWorkbook.getSheetAt(sheetNum).getLastRowNum());
}
protected static final String regexCellRef = "[a-zA-Z]+[0-9]+";

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

public static void setPrintArea(Workbook resultWorkbook, int sheetNum) {
  int maxColumnNum = 0;
  for (int j = resultWorkbook.getSheetAt(sheetNum).getFirstRowNum(), c = resultWorkbook.getSheetAt(sheetNum).getLastRowNum(); j <= c; j++) {
    org.apache.poi.ss.usermodel.Row row = resultWorkbook.getSheetAt(sheetNum).getRow(j);
    if (row != null) {
      maxColumnNum = row.getLastCellNum();
    }
  }
  resultWorkbook.setPrintArea(sheetNum, 0, maxColumnNum, 0,
      resultWorkbook.getSheetAt(sheetNum).getLastRowNum());
}

代码示例来源：origin: org.apache.any23.plugins/apache-any23-office-scraper

private void writeSheetMetadata(IRI sheetIRI, Sheet sheet, ExtractionResult er) {
  final String sheetName   = sheet.getSheetName();
  final int    firstRowNum = sheet.getFirstRowNum();
  final int    lastRowNum  = sheet.getLastRowNum();
  er.writeTriple(sheetIRI, excel.sheetName, RDFUtils.literal(sheetName));
  er.writeTriple(sheetIRI, excel.firstRow, RDFUtils.literal(firstRowNum));
  er.writeTriple(sheetIRI, excel.lastRow  , RDFUtils.literal(lastRowNum ));
}

内容来源于网络，如有侵权，请联系作者删除！

sheet

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    Sheet类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com