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

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

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

HSSFWorkbook.getSheetAt介绍

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

代码示例

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

  1. @Override
  2. public EvaluationSheet getSheet(int sheetIndex) {
  3.   // TODO Cache these evaluation sheets so they aren't re-generated on every getSheet call
  4.   return new HSSFEvaluationSheet(_uBook.getSheetAt(sheetIndex));
  5. }
  6. @Override

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

  1. /**
  2.  * Gets the selected sheets (if more than one, Excel calls these a [Group]). 
  3.  *
  4.  * @return indices of selected sheets
  5.  */
  6. public Collection<Integer> getSelectedTabs() {
  7.   Collection<Integer> indexes = new ArrayList<>();
  8.   int nSheets = _sheets.size();
  9.   for (int i=0; i<nSheets; i++) {
  10.     HSSFSheet sheet = getSheetAt(i);
  11.     if (sheet.isSelected()) {
  12.       indexes.add(i);
  13.     }
  14.   }
  15.   return Collections.unmodifiableCollection(indexes);
  16. }

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

  1. HSSFWorkbook myWorkBook = new HSSFWorkbook(new POIFSFileSystem(new FileInputStream("E:/Project/SpringHibernet/MultiplexTicketBookingNew/web/excelSheets/Country.xlsx")));
  2.  HSSFSheet mySheet = myWorkBook.getSheetAt(0);
  3.  Iterator rowIter = mySheet.rowIterator();
  4.  System.out.println(mySheet.getRow(1).getCell(0));

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

  1. HSSFSheet sheet = wb.getSheetAt(i);
  2. if(initDrawing) {

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

  1. /**
  2.  * Selects multiple sheets as a group. This is distinct from
  3.  * the 'active' sheet (which is the sheet with focus).
  4.  * Unselects sheets that are not in <code>indexes</code>.
  5.  *
  6.  * @param indexes Collection of sheets to select, the index is 0-based.
  7.  */
  8. public void setSelectedTabs(Collection<Integer> indexes) {
  9.   for (int index : indexes) {
  10.     validateSheetIndex(index);
  11.   }
  12.   // ignore duplicates
  13.   Set<Integer> set = new HashSet<>(indexes);
  14.   int nSheets = _sheets.size();
  15.   for (int i=0; i<nSheets; i++) {
  16.     boolean bSelect = set.contains(i);
  17.     getSheetAt(i).setSelected(bSelect);
  18.   }
  19.   // this is true only if all values in set were valid sheet indexes (between 0 and nSheets-1, inclusive)
  20.   short nSelected = (short) set.size();
  21.   workbook.getWindowOne().setNumSelectedTabs(nSelected);
  22. }

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

  1. /**
  2.  * Selects a single sheet. This may be different to
  3.  * the 'active' sheet (which is the sheet with focus).
  4.  */
  5. @Override
  6. public void setSelectedTab(int index) {
  7.   validateSheetIndex(index);
  8.   int nSheets = _sheets.size();
  9.   for (int i=0; i<nSheets; i++) {
  10.       getSheetAt(i).setSelected(i == index);
  11.   }
  12.   workbook.getWindowOne().setNumSelectedTabs((short)1);
  13. }

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

  1. public static void writeToFile(OutputStream fos, InputStream xlsWorkbook, boolean excludeWorkbookRecords, String[] params) throws IOException {
  2.   HSSFWorkbook workbook = new HSSFWorkbook(xlsWorkbook);
  3.   InternalWorkbook internalWorkbook = workbook.getInternalWorkbook();
  4.   DrawingGroupRecord r = (DrawingGroupRecord) internalWorkbook.findFirstRecordBySid(DrawingGroupRecord.sid);
  5.   StringBuilder builder = new StringBuilder();
  6.   builder.append("<workbook>\n");
  7.   String tab = "\t";
  8.   if (!excludeWorkbookRecords && r != null) {
  9.     r.decode();
  10.     List<EscherRecord> escherRecords = r.getEscherRecords();
  11.     for (EscherRecord record : escherRecords) {
  12.       builder.append(record.toXml(tab));
  13.     }
  14.   }
  15.   List<Integer> sheets = getSheetsIndexes(params, workbook);
  16.   for (Integer i : sheets) {
  17.     HSSFPatriarch p = workbook.getSheetAt(i).getDrawingPatriarch();
  18.     if(p != null ) {
  19.       builder.append(tab).append("<sheet").append(i).append(">\n");
  20.       builder.append(p.getBoundAggregate().toXml(tab + "\t"));
  21.       builder.append(tab).append("</sheet").append(i).append(">\n");
  22.     }
  23.   }
  24.   builder.append("</workbook>\n");
  25.   fos.write(builder.toString().getBytes(StringUtil.UTF8));
  26.   fos.close();
  27.   workbook.close();
  28. }

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

  1. /**
  2.  * Convenience method to set the active sheet.  The active sheet is is the sheet
  3.  * which is currently displayed when the workbook is viewed in Excel.
  4.  * 'Selected' sheet(s) is a distinct concept.
  5.  */
  6. @Override
  7. public void setActiveSheet(int index) {
  8.   validateSheetIndex(index);
  9.   int nSheets = _sheets.size();
  10.   for (int i=0; i<nSheets; i++) {
  11.      getSheetAt(i).setActive(i == index);
  12.   }
  13.   workbook.getWindowOne().setActiveSheetIndex(index);
  14. }

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

  1. POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(file));
  2. HSSFWorkbook wb = new HSSFWorkbook(fs);
  3. HSSFSheet sheet = wb.getSheetAt(0);
  4. HSSFRow row;
  5. HSSFCell cell;

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

  1. /**
  2.  * 获取XLS工作簿指定sheet中图片列表
  3.  * 
  4.  * @param workbook 工作簿{@link Workbook}
  5.  * @param sheetIndex sheet的索引
  6.  * @return 图片映射，键格式：行_列，值：{@link PictureData}
  7.  */
  8. private static Map<String, PictureData> getPicMapXls(HSSFWorkbook workbook, int sheetIndex) {
  9.   final Map<String, PictureData> picMap = new HashMap<>();
  10.   final List<HSSFPictureData> pictures = workbook.getAllPictures();
  11.   if (CollectionUtil.isNotEmpty(pictures)) {
  12.     final HSSFSheet sheet = workbook.getSheetAt(sheetIndex);
  13.     HSSFClientAnchor anchor;
  14.     int pictureIndex;
  15.     for (HSSFShape shape : sheet.getDrawingPatriarch().getChildren()) {
  16.       if (shape instanceof HSSFPicture) {
  17.         pictureIndex = ((HSSFPicture) shape).getPictureIndex() - 1;
  18.         anchor = (HSSFClientAnchor) shape.getAnchor();
  19.         picMap.put(StrUtil.format("{}_{}", anchor.getRow1(), anchor.getCol1()), pictures.get(pictureIndex));
  20.       }
  21.     }
  22.   }
  23.   return picMap;
  24. }

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

  1. /**
  2.  * 获取XLS工作簿指定sheet中图片列表
  3.  * 
  4.  * @param workbook 工作簿{@link Workbook}
  5.  * @param sheetIndex sheet的索引
  6.  * @return 图片映射，键格式：行_列，值：{@link PictureData}
  7.  */
  8. private static Map<String, PictureData> getPicMapXls(HSSFWorkbook workbook, int sheetIndex) {
  9.   final Map<String, PictureData> picMap = new HashMap<>();
  10.   final List<HSSFPictureData> pictures = workbook.getAllPictures();
  11.   if (CollectionUtil.isNotEmpty(pictures)) {
  12.     final HSSFSheet sheet = workbook.getSheetAt(sheetIndex);
  13.     HSSFClientAnchor anchor;
  14.     int pictureIndex;
  15.     for (HSSFShape shape : sheet.getDrawingPatriarch().getChildren()) {
  16.       if (shape instanceof HSSFPicture) {
  17.         pictureIndex = ((HSSFPicture) shape).getPictureIndex() - 1;
  18.         anchor = (HSSFClientAnchor) shape.getAnchor();
  19.         picMap.put(StrUtil.format("{}_{}", anchor.getRow1(), anchor.getCol1()), pictures.get(pictureIndex));
  20.       }
  21.     }
  22.   }
  23.   return picMap;
  24. }

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

  1. public void removeSheetAt(int index) {
  2.   validateSheetIndex(index);
  3.   boolean wasSelected = getSheetAt(index).isSelected();
  4.     boolean someOtherSheetIsStillSelected = false;
  5.     for (int i =0; i < nSheets; i++) {
  6.       if (getSheetAt(i).isSelected()) {
  7.         someOtherSheetIsStillSelected = true;
  8.         break;

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

  1. void recalculateAllWorkbookFormulas() {
  2.  if ( data.wb instanceof XSSFWorkbook ) {
  3.   // XLSX needs full reevaluation
  4.   FormulaEvaluator evaluator = data.wb.getCreationHelper().createFormulaEvaluator();
  5.   for ( int sheetNum = 0; sheetNum < data.wb.getNumberOfSheets(); sheetNum++ ) {
  6.    Sheet sheet = data.wb.getSheetAt( sheetNum );
  7.    for ( Row r : sheet ) {
  8.     for ( Cell c : r ) {
  9.      if ( c.getCellType() == Cell.CELL_TYPE_FORMULA ) {
  10.       evaluator.evaluateFormulaCell( c );
  11.      }
  12.     }
  13.    }
  14.   }
  15.  } else if ( data.wb instanceof HSSFWorkbook ) {
  16.   // XLS supports a "dirty" flag to have excel recalculate everything when a sheet is opened
  17.   for ( int sheetNum = 0; sheetNum < data.wb.getNumberOfSheets(); sheetNum++ ) {
  18.    HSSFSheet sheet = ( (HSSFWorkbook) data.wb ).getSheetAt( sheetNum );
  19.    sheet.setForceFormulaRecalculation( true );
  20.   }
  21.  } else {
  22.   String forceRecalc = getVariable( STREAMER_FORCE_RECALC_PROP_NAME, "N" );
  23.   if ( "Y".equals( forceRecalc ) ) {
  24.    data.wb.setForceFormulaRecalculation( true );
  25.   }
  26.  }
  27. }

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

  1. HSSFSheet sheet = _wb.getSheetAt(i);
  2. if(sheet == null) { continue; }

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

  1. private void updateFormulasForShift(FormulaShifter formulaShifter) {
  2.   int sheetIndex = _workbook.getSheetIndex(this);
  3.   short externSheetIndex = _book.checkExternSheet(sheetIndex);
  4.   // update formulas on this sheet that point to rows which have been moved
  5.   _sheet.updateFormulasAfterCellShift(formulaShifter, externSheetIndex);
  6.   // update formulas on other sheets that point to rows that have been moved on this sheet
  7.   int nSheets = _workbook.getNumberOfSheets();
  8.   for (int i = 0; i < nSheets; i++) {
  9.     InternalSheet otherSheet = _workbook.getSheetAt(i).getSheet();
  10.     if (otherSheet == this._sheet) {
  11.       continue;
  12.     }
  13.     short otherExtSheetIx = _book.checkExternSheet(i);
  14.     otherSheet.updateFormulasAfterCellShift(formulaShifter, otherExtSheetIx);
  15.   }
  16.   _workbook.getWorkbook().updateNamesAfterCellShift(formulaShifter);
  17. }

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

  1. HSSFSheet s = workbook.getSheetAt(sheetNum);
  2. for (Row row : s) {
  3.   for (Cell cell : row) {

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

  1. HSSFWorkbook wb = new HSSFWorkbook();
  2. HSSFSheet sheet = wb.createSheet("Sheet1");
  3. sheet = wb.getSheetAt(0);
  5. for (Row myrow : sheet) {
  6.   for (Cell mycell : myrow) {
  7.     //set foreground color here
  8.   }
  9. }

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

  1. HSSFSheet mySheet = myWorkBook.getSheetAt(0);

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

  1. HSSFSheet s = workbook.getSheetAt(sheetNum);
  2. for (Row row : s) {
  3.   for (Cell cellI : row) {
  4. HSSFSheet s = workbook.getSheetAt(sheetNum);
  5. for (Row row : s) {
  6.   for (Cell cell : row) {

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

  1. public void addCoverType(HSSFWorkbook workbook, List<Book> books) {
  3.   HSSFSheet sheet = workbook.getSheetAt(0);
  4.   HSSFCell cell = null;
  6.  //row 0 is the header (not automatically added by primefaces)
  7.  //add a fifth cell to each row
  8.   for (int i = 1; i < sheet.getLastRowNum() + 1; i++) {
  9.     sheet.getRow(i).createCell(4);
  10.     cell = sheet.getRow(i).getCell(4);
  11.     cell.setCellValue(book.get(i - 1).getCoverType());
  12.   }
  13.   log.debug("cover type added");
  14. }

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

HSSFWorkbook

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    HSSFWorkbook类方法

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