@Override public String getSheetName(int sheetIndex) { return _uBook.getSheetName(sheetIndex); }
/** * Set the sheet name * * @param sheet sheet number (0 based) * @return Sheet name */ @Override public String getSheetName(int sheet) { return _wb.getSheetName(sheet); }
@Override public String getSheetFirstNameByExternSheet(int externSheetIndex) { int sheetIndex = convertFromExternalSheetIndex(externSheetIndex); return _uBook.getSheetName(sheetIndex); } @Override
/** * For the Convenience of Java Programmers maintaining pointers. * @see #setPrintArea(int, String) * @param sheetIndex Zero-based sheet index (0 = First Sheet) * @param startColumn Column to begin printarea * @param endColumn Column to end the printarea * @param startRow Row to begin the printarea * @param endRow Row to end the printarea */ @Override public void setPrintArea(int sheetIndex, int startColumn, int endColumn, int startRow, int endRow) { String reference=getReferencePrintArea(getSheetName(sheetIndex), startColumn, endColumn, startRow, endRow); setPrintArea(sheetIndex, reference); }
/** * Sets the printarea for the sheet provided * <p> * i.e. Reference = $A$1:$B$2 * @param sheetIndex Zero-based sheet index (0 Represents the first sheet to keep consistent with java) * @param reference Valid name Reference for the Print Area */ @Override public void setPrintArea(int sheetIndex, String reference) { XSSFName name = getBuiltInName(XSSFName.BUILTIN_PRINT_AREA, sheetIndex); if (name == null) { name = createBuiltInName(XSSFName.BUILTIN_PRINT_AREA, sheetIndex); } //short externSheetIndex = getWorkbook().checkExternSheet(sheetIndex); //name.setExternSheetNumber(externSheetIndex); String[] parts = COMMA_PATTERN.split(reference); StringBuilder sb = new StringBuilder(32); for (int i = 0; i < parts.length; i++) { if(i>0) { sb.append(','); } SheetNameFormatter.appendFormat(sb, getSheetName(sheetIndex)); sb.append('!'); sb.append(parts[i]); } name.setRefersToFormula(sb.toString()); }
String oldSheetName = getSheetName(sheetIndex);
/** * Get the sheets name which this named range is referenced to * * @return sheet name, which this named range referred to. * Empty string if the referenced sheet name was not found. */ public String getSheetName() { if (_ctName.isSetLocalSheetId()) { // Given as explicit sheet id int sheetId = (int)_ctName.getLocalSheetId(); return _workbook.getSheetName(sheetId); } String ref = getRefersToFormula(); AreaReference areaRef = new AreaReference(ref, SpreadsheetVersion.EXCEL2007); return areaRef.getFirstCell().getSheetName(); }
nextSheet(workbook.getSheetName(currentTestSheetIndex++)); String testSheetName = currentSheet.getSheetName();
String sheetName = getWorkbook().getSheetName(sheetIndex); FormulaShifter formulaShifter = FormulaShifter.createForRowShift( sheetIndex, sheetName, startRow, endRow, n, SpreadsheetVersion.EXCEL2007);
final String sheetName = _sheet.getWorkbook().getSheetName(sheetIndex); final int srcRowNum = srcRow.getRowNum(); final int destRowNum = getRowNum();
/** * Set the sheet name * * @param sheet sheet number (0 based) * @return Sheet name */ @Override public String getSheetName(int sheet) { return _wb.getSheetName(sheet); }
/** * Set the sheet name * * @param sheet sheet number (0 based) * @return Sheet name */ public String getSheetName(int sheet) { return _wb.getSheetName(sheet); }
@Override public String getSheetName(int sheetIndex) { return _uBook.getSheetName(sheetIndex); }
public String getSheetName(int sheetIndex) { return _uBook.getSheetName(sheetIndex); }
@Override public String getSheetFirstNameByExternSheet(int externSheetIndex) { int sheetIndex = convertFromExternalSheetIndex(externSheetIndex); return _uBook.getSheetName(sheetIndex); } @Override
public String getSheetNameByExternSheet(int externSheetIndex) { int sheetIndex = convertFromExternalSheetIndex(externSheetIndex); return _uBook.getSheetName(sheetIndex); }
private void open() { try { _workbook = new XSSFWorkbook(new FileInputStream(_file)); for (int i = 0; i < _workbook.getNumberOfSheets(); i++) { ITable res = new ExcelTable(i); _tablesById.put(_workbook.getSheetName(i), res); _tables.add(res); } } catch (Exception e) { throw new KlabRuntimeException(e); } }
/** * For the Convenience of Java Programmers maintaining pointers. * @see #setPrintArea(int, String) * @param sheetIndex Zero-based sheet index (0 = First Sheet) * @param startColumn Column to begin printarea * @param endColumn Column to end the printarea * @param startRow Row to begin the printarea * @param endRow Row to end the printarea */ public void setPrintArea(int sheetIndex, int startColumn, int endColumn, int startRow, int endRow) { String reference=getReferencePrintArea(getSheetName(sheetIndex), startColumn, endColumn, startRow, endRow); setPrintArea(sheetIndex, reference); }
/** * For the Convenience of Java Programmers maintaining pointers. * @see #setPrintArea(int, String) * @param sheetIndex Zero-based sheet index (0 = First Sheet) * @param startColumn Column to begin printarea * @param endColumn Column to end the printarea * @param startRow Row to begin the printarea * @param endRow Row to end the printarea */ @Override public void setPrintArea(int sheetIndex, int startColumn, int endColumn, int startRow, int endRow) { String reference=getReferencePrintArea(getSheetName(sheetIndex), startColumn, endColumn, startRow, endRow); setPrintArea(sheetIndex, reference); }
/** * Change active sheet. * * @author SulakkhanaW * @param sheetName the sheet name */ public static void changeActiveSheet(String sheetName){ int sheetIndex = workbook.getSheetIndex(sheetName); workbook.setActiveSheet(sheetIndex); sheet = workbook.getSheetAt(sheetIndex); activeSheetName = workbook.getSheetName(sheetIndex); return; }