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

x33g5p2x  于2022-02-02 转载在 其他  
字(7.5k)|赞(0)|评价(0)|浏览(2013)

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

Workbook.getSheetAt介绍

[英]Get the Sheet object at the given index.
[中]获取给定索引处的图纸对象。

代码示例

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

/**
 * 构造
 * 
 * @param book {@link Workbook} 表示一个Excel文件
 * @param sheetIndex sheet序号，0表示第一个sheet
 */
public ExcelReader(Workbook book, int sheetIndex) {
  this(book.getSheetAt(sheetIndex));
}

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

/**
 * 构造
 * 
 * @param book {@link Workbook} 表示一个Excel文件
 * @param sheetIndex sheet序号，0表示第一个sheet
 */
public ExcelReader(Workbook book, int sheetIndex) {
  this(book.getSheetAt(sheetIndex));
}

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

public KSheet getSheet( int sheetNr ) {
 Sheet sheet = workbook.getSheetAt( sheetNr );
 if ( sheet == null ) {
  return null;
 }
 return new PoiSheet( sheet );
}

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

/**
 * 获取此工作簿所有Sheet表
 * 
 * @return sheet表列表
 * @since 4.0.3
 */
public List<Sheet> getSheets() {
  final int totalSheet = getSheetCount();
  final List<Sheet> result = new ArrayList<>(totalSheet);
  for (int i = 0; i < totalSheet; i++) {
    result.add(this.workbook.getSheetAt(i));
  }
  return result;
}

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

/**
 * 获取此工作簿所有Sheet表
 * 
 * @return sheet表列表
 * @since 4.0.3
 */
public List<Sheet> getSheets() {
  final int totalSheet = getSheetCount();
  final List<Sheet> result = new ArrayList<>(totalSheet);
  for (int i = 0; i < totalSheet; i++) {
    result.add(this.workbook.getSheetAt(i));
  }
  return result;
}

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

Workbook wb = WorkbookFactory.create(new File("/path/to/your/excel/file"));
 Sheet mySheet = wb.getSheetAt(0);
 Iterator<Row> rowIter = mySheet.rowIterator();
 System.out.println(mySheet.getRow(1).getCell(0));

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

InputStream inp = new FileInputStream("wb.xls");
 Workbook wb = WorkbookFactory.create(inp);
 Sheet sheet = wb.getSheetAt([sheet index]);
 Row row = sheet.getRow([row index]);
 Cell cell = row.getCell([cell index]);
 String cellContents = cell.getStringCellValue(); 
 //Modify the cellContents here
 // Write the output to a file
 cell.setCellValue(cellContents); 
 FileOutputStream fileOut = new FileOutputStream("wb.xls");
 wb.write(fileOut);
 fileOut.close();

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

/**
 * 获取表名列表
 * 
 * @return 表名列表
 * @since 4.0.3
 */
public List<String> getSheetNames() {
  final int totalSheet = workbook.getNumberOfSheets();
  List<String> result = new ArrayList<>(totalSheet);
  for (int i = 0; i < totalSheet; i++) {
    result.add(this.workbook.getSheetAt(i).getSheetName());
  }
  return result;
}

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

/**
 * 获取表名列表
 * 
 * @return 表名列表
 * @since 4.0.3
 */
public List<String> getSheetNames() {
  final int totalSheet = workbook.getNumberOfSheets();
  List<String> result = new ArrayList<>(totalSheet);
  for (int i = 0; i < totalSheet; i++) {
    result.add(this.workbook.getSheetAt(i).getSheetName());
  }
  return result;
}

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

/**
 * 自定义需要读取或写出的Sheet，如果给定的sheet不存在，创建之（命名为默认）<br>
 * 在读取中，此方法用于切换读取的sheet，在写出时，此方法用于新建或者切换sheet
 * 
 * @param sheetIndex sheet序号，从0开始计数
 * @return this
 * @since 4.0.10
 */
@SuppressWarnings("unchecked")
public T setSheet(int sheetIndex) {
  try {
    this.sheet = this.workbook.getSheetAt(sheetIndex);
  } catch (IllegalArgumentException e) {
    this.sheet = this.workbook.createSheet();
  }
  if(null == this.sheet) {
    this.sheet = this.workbook.createSheet();
  }
  return (T) this;
}

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

/**
 * 自定义需要读取或写出的Sheet，如果给定的sheet不存在，创建之（命名为默认）<br>
 * 在读取中，此方法用于切换读取的sheet，在写出时，此方法用于新建或者切换sheet
 * 
 * @param sheetIndex sheet序号，从0开始计数
 * @return this
 * @since 4.0.10
 */
@SuppressWarnings("unchecked")
public T setSheet(int sheetIndex) {
  try {
    this.sheet = this.workbook.getSheetAt(sheetIndex);
  } catch (IllegalArgumentException e) {
    this.sheet = this.workbook.createSheet();
  }
  if(null == this.sheet) {
    this.sheet = this.workbook.createSheet();
  }
  return (T) this;
}

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

InputStream inp =getClass().getResourceAsStream("filename.xls"));
Workbook wb = WorkbookFactory.create(inp);
DataFormatter objDefaultFormat = new DataFormatter();
FormulaEvaluator objFormulaEvaluator = new HSSFFormulaEvaluator((HSSFWorkbook) wb);

Sheet sheet= wb.getSheetAt(0);
Iterator<Row> objIterator = sheet.rowIterator();

while(objIterator.hasNext()){

  Row row = objIterator.next();
  Cell cellValue = row.getCell(0);
  objFormulaEvaluator.evaluate(cellValue); // This will evaluate the cell, And any type of cell will return string value
  String cellValueStr = objDefaultFormat.formatCellValue(cellValue,objFormulaEvaluator);

}

代码示例来源：origin: alibaba/easyexcel

public static Sheet createOrGetSheet(Workbook workbook, com.alibaba.excel.metadata.Sheet sheet) {
  Sheet sheet1 = null;
  try {
    try {
      sheet1 = workbook.getSheetAt(sheet.getSheetNo()-1);
    } catch (Exception e) {
    }
    if (null == sheet1) {
      sheet1 = createSheet(workbook, sheet);
      buildSheetStyle(sheet1,sheet.getColumnWidthMap());
    }
  } catch (Exception e) {
    throw new RuntimeException("constructCurrentSheet error", e);
  }
  return sheet1;
}

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

protected static void evaluateAllFormulaCells(Workbook wb, FormulaEvaluator evaluator) {
  for(int i=0; i<wb.getNumberOfSheets(); i++) {
    Sheet sheet = wb.getSheetAt(i);
    for(Row r : sheet) {
      for (Cell c : r) {
        if (c.getCellType() == CellType.FORMULA) {
          evaluator.evaluateFormulaCell(c);
        }
      }
    }
  }
}

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

Sheet sheet = wb.getSheetAt(0);
FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();

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

sheet = workbook.getSheet(cellRef.getSheetName());
} else {
  sheet = workbook.getSheetAt(workbook.getActiveSheetIndex());

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

void recalculateAllWorkbookFormulas() {
 if ( data.wb instanceof XSSFWorkbook ) {
  // XLSX needs full reevaluation
  FormulaEvaluator evaluator = data.wb.getCreationHelper().createFormulaEvaluator();
  for ( int sheetNum = 0; sheetNum < data.wb.getNumberOfSheets(); sheetNum++ ) {
   Sheet sheet = data.wb.getSheetAt( sheetNum );
   for ( Row r : sheet ) {
    for ( Cell c : r ) {
     if ( c.getCellType() == Cell.CELL_TYPE_FORMULA ) {
      evaluator.evaluateFormulaCell( c );
     }
    }
   }
  }
 } else if ( data.wb instanceof HSSFWorkbook ) {
  // XLS supports a "dirty" flag to have excel recalculate everything when a sheet is opened
  for ( int sheetNum = 0; sheetNum < data.wb.getNumberOfSheets(); sheetNum++ ) {
   HSSFSheet sheet = ( (HSSFWorkbook) data.wb ).getSheetAt( sheetNum );
   sheet.setForceFormulaRecalculation( true );
  }
 } else {
  String forceRecalc = getVariable( STREAMER_FORCE_RECALC_PROP_NAME, "N" );
  if ( "Y".equals( forceRecalc ) ) {
   data.wb.setForceFormulaRecalculation( true );
  }
 }
}

代码示例来源：origin: alibaba/easyexcel

/**
 * @param sheet
 */
public void currentSheet(com.alibaba.excel.metadata.Sheet sheet) {
  if (null == currentSheetParam || currentSheetParam.getSheetNo() != sheet.getSheetNo()) {
    cleanCurrentSheet();
    currentSheetParam = sheet;
    try {
      this.currentSheet = workbook.getSheetAt(sheet.getSheetNo() - 1);
    } catch (Exception e) {
      this.currentSheet = WorkBookUtil.createSheet(workbook, sheet);
      if (null != afterWriteHandler) {
        this.afterWriteHandler.sheet(sheet.getSheetNo(), currentSheet);
      }
    }
    buildSheetStyle(currentSheet, sheet.getColumnWidthMap());
    /** **/
    this.initCurrentSheet(sheet);
  }
}

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

@Test
 public void forcesToRecalculate_Hssf() throws Exception {
  data.wb = new HSSFWorkbook();
  data.wb.createSheet( "sheet1" );
  data.wb.createSheet( "sheet2" );

  step.recalculateAllWorkbookFormulas();

  if ( !data.wb.getForceFormulaRecalculation() ) {
   int sheets = data.wb.getNumberOfSheets();
   for ( int i = 0; i < sheets; i++ ) {
    Sheet sheet = data.wb.getSheetAt( i );
    assertTrue( "Sheet #" + i + ": " + sheet.getSheetName(), sheet.getForceFormulaRecalculation() );
   }
  }
 }
}

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

Workbook workbook = WorkbookFactory.create(new File("input.xlsx"));
DataFormatter formatter = new DataFormatter();
Sheet s = workbook.getSheetAt(0);
for (Row r : s) {
 for (Cell c : r) {
   System.out.println(formatter.formatCellValue(c));
 }
}

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

Workbook

相关文章

    查看更多
    微信公众号

    热门标签

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

    最新文章

    更多

    Workbook类方法

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