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

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

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

HSSFWorkbook.getSheetName介绍

暂无

代码示例

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

  1. @Override
  2. public String getSheetName(int sheetIndex) {
  3.   return _uBook.getSheetName(sheetIndex);
  4. }

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

  1. /**
  2.  * Returns the name of this sheet
  3.  *
  4.  * @return the name of this sheet
  5.  */
  6. @SuppressWarnings("resource")
  7. @Override
  8. public String getSheetName() {
  9.   HSSFWorkbook wb = getWorkbook();
  10.   int idx = wb.getSheetIndex(this);
  11.   return wb.getSheetName(idx);
  12. }

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

  1. /**
  2.  * Sets the printarea for the sheet provided
  3.  * <p>
  4.  * i.e. Reference = $A$1:$B$2
  5.  * @param sheetIndex Zero-based sheet index (0 Represents the first sheet to keep consistent with java)
  6.  * @param reference Valid name Reference for the Print Area
  7.  */
  8. @Override
  9. public void setPrintArea(int sheetIndex, String reference)
  10. {
  11.   NameRecord name = workbook.getSpecificBuiltinRecord(NameRecord.BUILTIN_PRINT_AREA, sheetIndex+1);
  12.   if (name == null) {
  13.     name = workbook.createBuiltInName(NameRecord.BUILTIN_PRINT_AREA, sheetIndex+1);
  14.     // adding one here because 0 indicates a global named region; doesn't make sense for print areas
  15.   }
  16.   String[] parts = COMMA_PATTERN.split(reference);
  17.   StringBuilder sb = new StringBuilder(32);
  18.   for (int i = 0; i < parts.length; i++) {
  19.     if(i>0) {
  20.       sb.append(",");
  21.     }
  22.     SheetNameFormatter.appendFormat(sb, getSheetName(sheetIndex));
  23.     sb.append("!");
  24.     sb.append(parts[i]);
  25.   }
  26.   name.setNameDefinition(HSSFFormulaParser.parse(sb.toString(), this, FormulaType.NAMEDRANGE, sheetIndex));
  27. }

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

  1. /**
  2.  * Shifts columns in range [startColumn, endColumn] for n places to the right.
  3.  * For n < 0, it will shift columns left.
  4.  * Additionally adjusts formulas.
  5.  * Probably should also process other features (hyperlinks, comments...) in the way analog to shiftRows method 
  6.  * @param startRow               the row to start shifting
  7.  * @param endRow                 the row to end shifting
  8.  * @param n                      the number of rows to shift
  9.  */
  10. @Beta
  11. @Override
  12. public void shiftColumns(int startColumn, int endColumn, int n){ 
  13.   HSSFColumnShifter columnShifter = new HSSFColumnShifter(this); 
  14.   columnShifter.shiftColumns(startColumn, endColumn, n); 
  15.   
  16.   int sheetIndex = _workbook.getSheetIndex(this);
  17.   short externSheetIndex = _book.checkExternSheet(sheetIndex);
  18.   String sheetName = _workbook.getSheetName(sheetIndex);
  19.   FormulaShifter formulaShifter = FormulaShifter.createForColumnShift(
  20.       externSheetIndex, sheetName, startColumn, endColumn, n, SpreadsheetVersion.EXCEL97);
  21.   updateFormulasForShift(formulaShifter); 
  22.   // add logic for hyperlinks etc, like in shiftRows() 
  23. }

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

  1. String name = _wb.getSheetName(i);
  2. if(name != null) {
  3.   text.append(name);

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

  1. String sheetName = _workbook.getSheetName(sheetIndex);
  2. FormulaShifter formulaShifter = FormulaShifter.createForRowShift(
  3.     externSheetIndex, sheetName, startRow, endRow, n, SpreadsheetVersion.EXCEL97);

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

  1. @Override
  2. public String getSheetName(int sheetIndex) {
  3.   return _uBook.getSheetName(sheetIndex);
  4. }

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

  1. public String getSheetName(int sheetIndex) {
  2.   return _uBook.getSheetName(sheetIndex);
  3. }

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

  1. public String getSheetName(int sheetIndex) {
  2.   return _uBook.getSheetName(sheetIndex);
  3. }

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

  1. /**
  2.  * Returns the name of this sheet
  3.  *
  4.  * @return the name of this sheet
  5.  */
  6. public String getSheetName() {
  7.   HSSFWorkbook wb = getWorkbook();
  8.   int idx = wb.getSheetIndex(this);
  9.   return wb.getSheetName(idx);
  10. }

代码示例来源：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. /**
  2.  * Returns the name of this sheet
  3.  *
  4.  * @return the name of this sheet
  5.  */
  6. @SuppressWarnings("resource")
  7. @Override
  8. public String getSheetName() {
  9.   HSSFWorkbook wb = getWorkbook();
  10.   int idx = wb.getSheetIndex(this);
  11.   return wb.getSheetName(idx);
  12. }

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

  1. /**
  2.  * Returns the name of this sheet
  3.  *
  4.  * @return the name of this sheet
  5.  */
  6. public String getSheetName() {
  7.   HSSFWorkbook wb = getWorkbook();
  8.   int idx = wb.getSheetIndex(this);
  9.   return wb.getSheetName(idx);
  10. }

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

  1. FileInputStream fileInputStream = null;  
  2.      try {  
  3.       fileInputStream = new FileInputStream("PATH_TO_EXCEL_FILE+FILE_NAME");  
  4.       HSSFWorkbook workbook = new HSSFWorkbook(fileInputStream);  
  5.       for (int i = 0; i < workbook.getNumberOfSheets(); i++) {  
  6.        if (workbook.getSheetName(i).equals("MY_OLD_SHEET_NAME")) {
  7.          workbook.createSheet("MY_OLD_SHEET_NAME");
  8.          workbook.setSheetOrder("MY_OLD_SHEET_NAME", i);
  9.          // TO DO: add contents to new sheet 
  10.        }
  11.       }
  12.       }
  13.       ............

代码示例来源：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: org.apache.poi/poi-examples

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

代码示例来源：origin: QihooTest/Leo

  1. /**
  2.  * Creates a new XlsDataSet object that loads the specified Excel document.
  3.  */
  4. public XlsDataSet(InputStream in) throws IOException, DataSetException {
  5.   _tables = super.createTableNameMap();
  6.   HSSFWorkbook workbook = new HSSFWorkbook(in);
  7.   int sheetCount = workbook.getNumberOfSheets();
  8.   for (int i = 0; i < sheetCount; i++) {
  9.     ITable table = new XlsTable(workbook, workbook.getSheetName(i),
  10.         workbook.getSheetAt(i));
  11.     _tables.add(table.getTableMetaData().getTableName(), table);
  12.   }
  13. }

代码示例来源：origin: QihooTest/Leo

  1. /**
  2.  * 从Excel的工作簿中创建XlsDataSet.
  3.  */
  4. @Deprecated
  5. public XlsDataSet(HSSFWorkbook workbook) throws IOException, DataSetException {
  6.   _tables = super.createTableNameMap();
  7.   int sheetCount = workbook.getNumberOfSheets();
  8.   for (int i = 0; i < sheetCount; i++) {
  9.     ITable table = new XlsTable(workbook, workbook.getSheetName(i),
  10.         workbook.getSheetAt(i));
  11.     _tables.add(table.getTableMetaData().getTableName(), table);
  12.   }
  13. }

代码示例来源：origin: micromata/projectforge

  1. public void doImport(final ImportStorage<KontoDO> storage, final InputStream is, final ActionLog actionLog) throws Exception
  2. {
  3.  final ExcelImport<KontenplanExcelRow> imp = new ExcelImport<KontenplanExcelRow>(is);
  4.  for (short idx = 0; idx < imp.getWorkbook().getNumberOfSheets(); idx++) {
  5.   imp.setActiveSheet(idx);
  6.   final String name = imp.getWorkbook().getSheetName(idx);
  7.   if (NAME_OF_EXCEL_SHEET.equals(name)) {
  8.    imp.setActiveSheet(idx);
  9.    final HSSFSheet sheet = imp.getWorkbook().getSheetAt(idx);
  10.    importKontenplan(storage, imp, sheet, actionLog);
  11.    return;
  12.   }
  13.  }
  14.  log.error("Oups, no sheet named 'Kontenplan' found.");
  15. }

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

HSSFWorkbook

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    HSSFWorkbook类方法

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