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

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

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

HSSFWorkbook.getNumberOfSheets介绍

[英]get the number of spreadsheets in the workbook (this will be three after serialization)
[中]获取工作簿中的电子表格数（序列化后为三个）

代码示例

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

  1. /**
  2.  * Specifies if the defined name is a local name, and if so, which sheet it is on.
  3.  *
  4.  * @param index if greater than 0, the defined name is a local name and the value MUST be a 0-based index
  5.  * to the collection of sheets as they appear in the workbook.
  6.  * @throws IllegalArgumentException if the sheet index is invalid.
  7.  */
  8. public void setSheetIndex(int index){
  9.   int lastSheetIx = _book.getNumberOfSheets() - 1;
  10.   if (index < -1 || index > lastSheetIx) {
  11.     throw new IllegalArgumentException("Sheet index (" + index +") is out of range" +
  12.         (lastSheetIx == -1 ? "" : (" (0.." +    lastSheetIx + ")")));
  13.   }
  14.   _definedNameRec.setSheetNumber(index + 1);
  15. }

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

  1. private static List<Integer> getSheetsIndexes(String[] params, HSSFWorkbook workbook) {
  2.   List<Integer> list = new ArrayList<>();
  3.   list.addAll(getIndexesByIdArray(params));
  4.   list.addAll(getIndexesByName(params, workbook));
  5.   if (0 == list.size()) {
  6.     int size = workbook.getNumberOfSheets();
  7.     for (int i = 0; i < size; i++) {
  8.       list.add(i);
  9.     }
  10.   }
  11.   return list;
  12. }

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

  1. System.out.println("done");
  2. for(int i = 0; i < wb.getNumberOfSheets(); i++){
  3.   HSSFSheet sheet = wb.getSheetAt(i);
  4.   if(initDrawing) {

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

  1. for(int i=0;i<_wb.getNumberOfSheets();i++) {
  2.   HSSFSheet sheet = _wb.getSheetAt(i);
  3.   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. for(int sheetNum=0; sheetNum<workbook.getNumberOfSheets(); sheetNum++) {
  2.   HSSFSheet s = workbook.getSheetAt(sheetNum);
  3.   for (Row row : s) {

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

  1. for (int sheetNum = 0; sheetNum < workbook.getNumberOfSheets(); sheetNum++) {
  2.   HSSFSheet s = workbook.getSheetAt(sheetNum);
  3.   for (Row row : s) {
  4. for (int sheetNum = 0; sheetNum < workbook.getNumberOfSheets(); sheetNum++) {
  5.   HSSFSheet s = workbook.getSheetAt(sheetNum);
  6.   for (Row row : s) {

代码示例来源：origin: FenixEdu/fenixedu-academic

  1. private String[] getAllSpreadsheets(HSSFWorkbook wb) {
  2.   String[] spreadsheets = new String[wb.getNumberOfSheets()];
  3.   for (int i = 0; i < wb.getNumberOfSheets(); i++) {
  4.     spreadsheets[i] = wb.getSheetName(i);
  5.   }
  6.   return spreadsheets;
  7. }

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

  1. private static List<Integer> getSheetsIndexes(String[] params, HSSFWorkbook workbook) {
  2.   List<Integer> list = new ArrayList<>();
  3.   list.addAll(getIndexesByIdArray(params));
  4.   list.addAll(getIndexesByName(params, workbook));
  5.   if (0 == list.size()) {
  6.     int size = workbook.getNumberOfSheets();
  7.     for (int i = 0; i < size; i++) {
  8.       list.add(i);
  9.     }
  10.   }
  11.   return list;
  12. }

代码示例来源：origin: com.haulmont.thirdparty/poi

  1. private static List<Integer> getSheetsIndexes(String[] params, HSSFWorkbook workbook) {
  2.   List<Integer> list = new ArrayList<Integer>();
  3.   list.addAll(getIndexesByIdArray(params));
  4.   list.addAll(getIndexesByName(params, workbook));
  5.   if (0 == list.size()) {
  6.     int size = workbook.getNumberOfSheets();
  7.     for (int i = 0; i < size; i++) {
  8.       list.add(i);
  9.     }
  10.   }
  11.   return list;
  12. }

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

  1. public static List<String> getCellOfAllSheets (File file, int row, int cell) throws IOException {
  2.   HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(file));
  3.   List<String> rows = new ArrayList<>(workbook.getNumberOfSheets());
  4.   for (int numberOfSheet = 0; numberOfSheet < workbook.getNumberOfSheets(); numberOfSheet++) {
  5.     HSSFSheet sheet = workbook.getSheetAt(numberOfSheet);
  6.     rows.add(sheet.getRow(row).getCell(cell).getStringCellValue());
  7.   }
  8.   return rows;
  9. }

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

  1. public static void main( String [] args ) {
  2.   try {
  4.     InputStream input = POIExample.class.getResourceAsStream( "qa.xls" );
  5.     POIFSFileSystem fs = new POIFSFileSystem( input );
  6.     HSSFWorkbook wb = new HSSFWorkbook(fs);
  8.     for (int i = 0; i < wb.getNumberOfSheets(); i++) {
  9.       HSSFSheet sheet = wb.getSheetAt(i);
  11.       // Do your stuff        
  12.     }
  14.   } catch ( IOException ex ) {
  15.     ex.printStackTrace();
  16.   }
  17. }

代码示例来源：origin: org.seasar.dao-codegen/s2dao-codegen-core

  1. protected Map<String, Table> readCodeData(HSSFWorkbook book) {
  2.   Map<String, Table> tableMap = new LinkedHashMap<String, Table>();
  3.   for (int i = 0; i < book.getNumberOfSheets(); ++i) {
  4.     HSSFSheet sheet = book.getSheetAt(i);
  5.     Table table = getTable(sheet);
  6.     if (table != null) {
  7.       tableMap.put(table.getTableName(), table);
  8.     }
  9.   }
  10.   setupChildLinks(tableMap);
  11.   return tableMap;
  12. }

代码示例来源：origin: cuba-platform/yarg

  1. protected void copyPictures() {
  2.   for (int sheetNumber = 0; sheetNumber < templateWorkbook.getNumberOfSheets(); sheetNumber++) {
  3.     HSSFSheet templateSheet = templateWorkbook.getSheetAt(sheetNumber);
  4.     HSSFSheet resultSheet = resultWorkbook.getSheetAt(sheetNumber);
  5.     copyPicturesFromTemplateToResult(templateSheet, resultSheet);
  6.   }
  7. }

代码示例来源：origin: com.haulmont.yarg/yarg

  1. protected void copyPictures() {
  2.   for (int sheetNumber = 0; sheetNumber < templateWorkbook.getNumberOfSheets(); sheetNumber++) {
  3.     HSSFSheet templateSheet = templateWorkbook.getSheetAt(sheetNumber);
  4.     HSSFSheet resultSheet = resultWorkbook.getSheetAt(sheetNumber);
  5.     copyPicturesFromTemplateToResult(templateSheet, resultSheet);
  6.   }
  7. }

代码示例来源：origin: com.haulmont.thirdparty/poi

  1. void initDrawings(){
  2.   DrawingManager2 mgr = workbook.findDrawingGroup();
  3.   if(mgr != null) {
  4.     for(int i=0; i < getNumberOfSheets(); i++)  {
  5.       getSheetAt(i).getDrawingPatriarch();
  6.     }
  7.   } else {
  8.     workbook.createDrawingGroup();
  9.   }
  10. }

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

  1. void initDrawings(){
  2.   DrawingManager2 mgr = workbook.findDrawingGroup();
  3.   if(mgr != null) {
  4.     for(int i=0; i < getNumberOfSheets(); i++)  {
  5.       getSheetAt(i).getDrawingPatriarch();
  6.     }
  7.   } else {
  8.     workbook.createDrawingGroup();
  9.   }
  10. }

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

  1. public void actionPerformed(ActionEvent e) {
  2.   //Create a new sheet then search for the sheet and make sure that the
  3.   //sheetPane shows it.
  4.   HSSFSheet newSheet = wb.createSheet();
  5.   for (int i=0; i<wb.getNumberOfSheets();i++) {
  6.    HSSFSheet sheet = wb.getSheetAt(i);
  7.    if (newSheet == sheet) {
  8.     sheetPane.insertTab(wb.getSheetName(i), null, makeSheetView(sheet), null, i);
  9.    }
  10.   }
  11.  }
  12. }

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

  1. public void actionPerformed(ActionEvent e) {
  2.   //Create a new sheet then search for the sheet and make sure that the
  3.   //sheetPane shows it.
  4.   HSSFSheet newSheet = wb.createSheet();
  5.   for (int i=0; i<wb.getNumberOfSheets();i++) {
  6.    HSSFSheet sheet = wb.getSheetAt(i);
  7.    if (newSheet == sheet) {
  8.     sheetPane.insertTab(wb.getSheetName(i), null, makeSheetView(sheet), null, i);
  9.    }
  10.   }
  11.  }
  12. }

代码示例来源：origin: ckpoint/CheckPoint

  1. private void createReqUrlSheet(PoiWorkBook workBook, ReqUrl reqUrl) {
  2.   PoiWorkSheet sheet = workBook.createSheet(reqUrl.getSheetName(workBook.getWorkBook().getNumberOfSheets()));
  3.   sheet.nextRow();
  4.   sheet.createTitleCells(1.5, reqUrl.getMethod(), reqUrl.getUrl());
  5.   sheet.nextRow(2);
  6.   for (ParamType paramType : ParamType.values()) {
  7.     if (this.createParamSheet(sheet, paramType, reqUrl)) {
  8.       sheet.nextRow(3);
  9.     }
  10.   }
  11. }

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

HSSFWorkbook

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    HSSFWorkbook类方法

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