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

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

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

HSSFWorkbook.getSheet介绍

[英]Get sheet with the given name (case insensitive match)
[中]获取具有给定名称的工作表（不区分大小写匹配）

代码示例

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

  1. @Test
  2. public void testProtectSheet() throws Exception {
  3.  step.protectSheet( wb.getSheet( SHEET_NAME ), "aa" );
  4.  assertTrue( wb.getSheet( SHEET_NAME ).getProtect() );
  5. }

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

  1. private static HSSFSheet sheet(String uri, String sheetName) throws IOException {
  2.   HSSFWorkbook workbook = new HSSFWorkbook(IOUtil.getInputStreamForURI(uri));
  3.   HSSFSheet sheet = sheetName != null ? workbook.getSheet(sheetName) : workbook.getSheetAt(0);
  4.   if (sheet == null)
  5.     throw new IllegalArgumentException("Sheet not found in file " + uri + ": " + sheetName);
  6.   return sheet;
  7. }

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

  1. File destFile = new File("/test.xls");
  2. FileInputStream fileStream = new FileInputStream(destFile);
  3. POIFSFileSystem fsPoi = new POIFSFileSystem(fileStream);
  5. HSSFWorkbook workbook = new HSSFWorkbook(fsPoi);
  7. int index = 0;
  9. HSSFSheet sheet = workbook.getSheet("Setup");
  10. if(sheet != null)   {
  11.   index = workbook.getSheetIndex(sheet);
  12.   workbook.removeSheetAt(index);
  13. }
  14. workbook.createSheet("Setup");
  15. FileOutputStream output = new FileOutputStream(destFile);
  16. workbook.write(output);
  17. output.close();

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

  1. FileInputStream input=new FileInputStream(new File("../../TestCase.xls"));
  2. HSSFWorkbook workbook=new HSSFWorkbook(input);
  3. HSSFSheet sheet=workbook.getSheet("KeywordFramework");
  4. System.out.println("i am in");

代码示例来源：origin: de.adorsys.sts/sts-worksheet-loader

  1. private void updateLogin(HSSFWorkbook workbook) {
  2.     HSSFSheet sheet = workbook.getSheet("Login");
  3.     if (sheet == null)
  4.       return;
  6.     Iterator<Row> rowIterator = sheet.rowIterator();
  7.     rowIterator.next();
  9.     while (rowIterator.hasNext()) {
  10.       Row row = rowIterator.next();
  11.       loginLoader.update(row);
  12.     }
  13.   }
  14. }

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

  1. public extractDataFromXls(String fileName, sheetName) throws FileNotFoundException {
  2.    FileInputStream fileInputStream = new FileInputStream(fileName);
  3.    HSSFWorkbook workbook = new HSSFWorkbook(fileInputStream);
  4.    HSSFSheet worksheet = workbook.getSheet(sheetName);
  5.    HSSFRow row = worksheet.getRow(0);
  6.    for (short i = 0; i < 5; i++) {
  7.      HSSFCell cell = row.getCell(i);
  8.      String value = cell.getStringCellValue();
  9.      System.out.println(value);
  10.    }
  11.  }

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

  1. FileInputStream fileInputStream = new FileInputStream(fileName);
  2.    HSSFWorkbook workbook = new HSSFWorkbook(fileInputStream);
  3.    HSSFSheet worksheet = workbook.getSheet(sheetName);
  4.    Iterator<Row> it = worksheet.rowIterator();
  5.    while(it.hasNext()){
  6.      HSSFRow r = (HSSFRow) it.next();
  7.      Iterator<Cell> it1=r.cellIterator();
  8.      while(it1.hasNext()){
  9.        HSSFCell cell = (HSSFCell)it1.next();
  10.        System.out.println("Row: "+cell.getRowIndex()+" ,Column: "+cell.getColumnIndex());
  11.        System.out.println(cell);
  12.      }
  13.      System.out.println();
  14.    }
  15.  } catch (FileNotFoundException e) {
  16.    e.printStackTrace();
  17.  } catch (IOException e) {
  18.    e.printStackTrace();
  19.  }

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

  1. HSSFWorkbook book1 = new HSSFWorkbook();
  2.     HSSFSheet sheet = book1.getSheet("sheetName");
  3.     int rowIndex=sheet.getLastRowNum()+1;//
  4.     int columnIndex = sheet.getRow(sheet.getLastRowNum()).getPhysicalNumberOfCells()

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

  1. public static HSSFSheet getTemplateSheetForRangeName(HSSFWorkbook workbook, String rangeName) {
  2.     int rangeNameIdx = workbook.getNameIndex(rangeName);
  3.     if (rangeNameIdx == -1) return null;
  5.     HSSFName aNamedRange = workbook.getNameAt(rangeNameIdx);
  6.     String sheetName = aNamedRange.getSheetName();
  7.     return workbook.getSheet(sheetName);
  8.   }
  9. }

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

  1. private HSSFSheet getOrCreateSheet(E bean, String sheetName) {
  2.   // create file
  3.   if (workbook == null)
  4.     createWorkbook();
  5.   HSSFSheet sheet = workbook.getSheet(sheetName);
  6.   if (sheet == null) {
  7.     sheet = workbook.createSheet(sheetName);
  8.     writeHeaderRow(bean, sheet);
  9.   }
  10.   return sheet;
  11. }

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

  1. public static HSSFSheet getTemplateSheetForRangeName(HSSFWorkbook workbook, String rangeName) {
  2.     int rangeNameIdx = workbook.getNameIndex(rangeName);
  3.     if (rangeNameIdx == -1) return null;
  5.     HSSFName aNamedRange = workbook.getNameAt(rangeNameIdx);
  6.     String sheetName = aNamedRange.getSheetName();
  7.     return workbook.getSheet(sheetName);
  8.   }
  9. }

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

  1. FileInputStream file = new FileInputStream(new File("D://DEQ//"+selectitem.getRefDeq()+"//Comparatif.xls"));        
  2.      HSSFWorkbook workbook1 = new HSSFWorkbook(file);
  3.      HSSFSheet sheet1 = workbook1.getSheet("Comparatif");
  4.      //Get first sheet from the workbook
  5.      HSSFSheetConditionalFormatting cf =sheet1.getSheetConditionalFormatting();
  6.      int i;
  7.      i=17;
  8.      for(;i<=ligne;i++){
  9.      HSSFConditionalFormattingRule cfrole=cf.createConditionalFormattingRule(ComparisonOperator.NOT_EQUAL,"$C$"+i ); 
  10.      HSSFPatternFormatting fill_pattern = cfrole.createPatternFormatting();
  11.      fill_pattern.setFillBackgroundColor(IndexedColors.YELLOW.index);
  12.      CellRangeAddress[] my_data_range = {CellRangeAddress.valueOf("B"+i+":B"+i)};
  13.      cf.addConditionalFormatting(my_data_range,cfrole);
  14.      }
  15.      for(i=17;i<=ligne;i++){
  16.        HSSFConditionalFormattingRule cfrole=cf.createConditionalFormattingRule(ComparisonOperator.NOT_EQUAL,"$B$"+i ); 
  17.        HSSFPatternFormatting fill_pattern = cfrole.createPatternFormatting();
  18.        fill_pattern.setFillBackgroundColor(IndexedColors.YELLOW.index);
  19.        CellRangeAddress[] my_data_range = {CellRangeAddress.valueOf("C"+i+":C"+i)};
  20.        cf.addConditionalFormatting(my_data_range,cfrole);
  21.        }
  22.  FileOutputStream out = new FileOutputStream(new File("D://DEQ//"+selectitem.getRefDeq()+"//Comparatif.xls"));
  23.      workbook1.write(out);
  24.      out.close();

代码示例来源：origin: Impetus/jumbune

  1. /**
  2.  * Adds a sheet in the Workbook
  3.  * @param worksheet the worksheet
  4.  * @param sheetName name of sheet
  5.  */
  6. public static void addSheet(Worksheet worksheet, String sheetName) {
  7.   HSSFWorkbook workbook = null;
  8.   HSSFSheet sheet= null;
  9.   String classSymbol = null;
  10.   
  11.   workbook = worksheet.getWorkbook();
  12.   if (workbook.getSheet(sheetName) != null) {
  13.     return;
  14.   }
  15.   sheet = workbook.createSheet(sheetName);
  16.   
  17.   Map<String, HSSFSheet> sheets = worksheet.getSheets();
  18.   Map<String, String> sheetSymbol = worksheet.getSheetSymbol();
  19.   
  20.   classSymbol = sheetSymbol.get(sheetName);
  21.    if ( classSymbol != null) {
  22.      sheets.put(classSymbol, sheet);
  23.    } else {
  24.      sheets.put(sheetName, sheet);
  25.    }
  26. }

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

  1. FileInputStream file = new FileInputStream(new File("/output.xls"));
  2. HSSFWorkbook workbook = new HSSFWorkbook(file);
  3. HSSFSheet sheet = workbook.getSheet("Sheet1");

代码示例来源：origin: us.ihmc/ihmc-avatar-interfaces

  1. public ReachabilityMapFileLoader(File fileToLoad, String robotName, RigidBodyBasics rootBody, HumanoidReferenceFrames referenceFrames)
  2. {
  3.  try
  4.  {
  5.    fileSystem = new NPOIFSFileSystem(fileToLoad);
  6.    workBookToLoad = new HSSFWorkbook(fileSystem.getRoot(), true);
  7.  }
  8.  catch (IOException e)
  9.  {
  10.    e.printStackTrace();
  11.  }
  12.  HSSFSheet descriptionSheet = workBookToLoad.getSheet("Description");
  13.  checkRobotMatchesData(robotName, rootBody, descriptionSheet);
  14.  ReferenceFrame gridFrame = createGridReferenceFrame(rootBody, referenceFrames, descriptionSheet);
  15.  loadedGrid = createGrid(descriptionSheet, gridFrame);
  16.  loadData();
  17.  close();
  18. }

代码示例来源：origin: us.ihmc/DarpaRoboticsChallenge

  1. public ReachabilityMapFileLoader(File fileToLoad, String robotName, RigidBody rootBody, HumanoidReferenceFrames referenceFrames)
  2. {
  3.  try
  4.  {
  5.    fileSystem = new NPOIFSFileSystem(fileToLoad);
  6.    workBookToLoad = new HSSFWorkbook(fileSystem.getRoot(), true);
  7.  }
  8.  catch (IOException e)
  9.  {
  10.    e.printStackTrace();
  11.  }
  12.  HSSFSheet descriptionSheet = workBookToLoad.getSheet("Description");
  13.  checkRobotMatchesData(robotName, rootBody, descriptionSheet);
  14.  ReferenceFrame gridFrame = createGridReferenceFrame(rootBody, referenceFrames, descriptionSheet);
  15.  loadedGrid = createGrid(descriptionSheet, gridFrame);
  16.  loadData();
  17.  close();
  18. }

代码示例来源：origin: paypal/SeLion

  1. public void generateRep(HSSFWorkbook wb, String sheetName, List<BaseReport<?>> lstReports) {
  2.   logger.entering(new Object[] { wb, sheetName, lstReports });
  3.   int rowNum = 0;
  4.   int iColStart = startColNum;
  5.   HSSFSheet sheet;
  6.   if (wb.getSheet(sheetName) == null) {
  7.     sheet = wb.createSheet(sheetName);
  8.   } else {
  9.     sheet = wb.getSheet(sheetName);
  10.     rowNum = sheet.getPhysicalNumberOfRows() + 2;
  11.   }
  12.   for (BaseReport<?> br : lstReports) {
  13.     br.createReportName(sheet, rowNum++, iColStart, Styles.getHeadingStyle());
  14.     br.createTitles(sheet, rowNum++, iColStart, Styles.getSubHeading2Style());
  15.     rowNum = br.fillData(sheet, rowNum++, Styles.getStyleBorderThinCenter());
  16.     rowNum += 3;
  17.   }
  18.   logger.exiting();
  19. }

代码示例来源：origin: us.ihmc/DarpaRoboticsChallenge

  1. private void loadData()
  2. {
  3.  HSSFRow currentRow;
  4.  HSSFSheet currentDataSheet;
  5.  int currentDataSheetNameIndex = 1;
  6.  currentDataSheet = workBookToLoad.getSheet("Data" + currentDataSheetNameIndex++);
  7.  while (currentDataSheet != null)
  8.  {
  9.    int currentRowIndex = 1;
  10.    currentRow = currentDataSheet.getRow(currentRowIndex++);
  11.    int cellIndex = 0;
  12.    while (currentRow != null)
  13.    {
  14.     cellIndex = 0;
  15.     int xIndex = (int) currentRow.getCell(cellIndex++).getNumericCellValue();
  16.     int yIndex = (int) currentRow.getCell(cellIndex++).getNumericCellValue();
  17.     int zIndex = (int) currentRow.getCell(cellIndex++).getNumericCellValue();
  18.     int rayIndex = (int) currentRow.getCell(cellIndex++).getNumericCellValue();
  19.     int rotationAroundRayIndex = (int) currentRow.getCell(cellIndex++).getNumericCellValue();
  20.     loadedGrid.registerReachablePose(xIndex, yIndex, zIndex, rayIndex, rotationAroundRayIndex);
  21.     currentRow = currentDataSheet.getRow(currentRowIndex++);
  22.    }
  23.    currentDataSheet = workBookToLoad.getSheet("Data" + currentDataSheetNameIndex++);
  24.  }
  25. }

代码示例来源：origin: org.drools/drools-scorecards

  1. @Override
  2. public List<ScorecardError>  parseFile(InputStream inStream, String worksheetName) throws ScorecardParseException {
  3.   try {
  4.     excelDataCollector = new XLSEventDataCollector();
  5.     excelDataCollector.setParser(this);
  6.     HSSFWorkbook workbook = new HSSFWorkbook(inStream);
  7.     HSSFSheet worksheet = workbook.getSheet(worksheetName);
  8.     if (worksheet != null) {
  9.       currentWorksheet = worksheet;
  10.       excelDataCollector.sheetStart(worksheetName);
  11.       excelDataCollector.setMergedRegionsInSheet(getMergedCellRangeList(worksheet));
  12.       processSheet(worksheet);
  13.       excelDataCollector.sheetComplete();
  14.       parseErrors = excelDataCollector.getParseErrors();
  15.       scorecard = excelDataCollector.getScorecard();
  16.     } else {
  17.       throw new ScorecardParseException("No worksheet found with name '" + worksheetName + "'.");
  18.     }
  19.   } catch (IOException e) {
  20.     throw new ScorecardParseException(e);
  21.   }
  22.   return parseErrors;
  23. }

代码示例来源：origin: bedatadriven/activityinfo

  1. /**
  2.    * Exporter obey following rules:
  3.    * - only activities of selected DB
  4.    * - number of sheets must be the same as number of activities
  5.    */
  6.   @Test
  7.   public void numberOfSheets() {
  9.     Filter filter = new Filter();
  10.     filter.addRestriction(DimensionType.Database, PEAR_DB);
  12.     SiteExporter exporter = new SiteExporter(new TaskContext(getDispatcherSync(), new NullStorageProvider(), "XY"));
  13.     exporter.buildExcelWorkbook(filter);
  15.     assertEquals(exporter.getBook().getNumberOfSheets(), 2);
  16.     assertNotNull(exporter.getBook().getSheet("NFI"));
  17.   }
  18. }

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

HSSFWorkbook

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    HSSFWorkbook类方法

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