Sheet sourceCopy = sourceSheet.getWorkbook().cloneSheet(sourceSheet.getWorkbook().getSheetIndex(sourceSheet)); int sourceWidthMinus1 = tilePatternRange.getLastColumn() - tilePatternRange.getFirstColumn(); int sourceHeightMinus1 = tilePatternRange.getLastRow() - tilePatternRange.getFirstRow();
throw new KettleException( BaseMessages.getString( PKG, "ExcelWriterStep.Exception.TemplateNotFound", data.realTemplateSheetName ) ); data.sheet = data.wb.cloneSheet( data.wb.getSheetIndex( ts ) ); data.wb.setSheetName( data.wb.getSheetIndex( data.sheet ), data.realSheetname );
private void cloneSheet(org.apache.poi.ss.usermodel.Workbook hssfWorkbook, int index, String name) { org.apache.poi.ss.usermodel.Sheet hssfSheet = hssfWorkbook.cloneSheet(index); for (int i = 0; i < hssfWorkbook.getNumberOfSheets(); i++) { if(hssfSheet.equals(hssfWorkbook.getSheetAt(i))) { hssfWorkbook.setSheetName(i, name); break; } } }
private void cloneSheet(org.apache.poi.ss.usermodel.Workbook hssfWorkbook, int index, String name) { org.apache.poi.ss.usermodel.Sheet hssfSheet = hssfWorkbook.cloneSheet(index); for (int i = 0; i < hssfWorkbook.getNumberOfSheets(); i++) { if(hssfSheet.equals(hssfWorkbook.getSheetAt(i))) { hssfWorkbook.setSheetName(i, name); break; } } }
/** * Creates a clone of the specified sheet. * @param oldName the name of original sheet * @param newName the created sheet name * @throws IllegalArgumentException if some parameters were {@code null} */ public void copy(String oldName, String newName) { if (oldName == null) { throw new IllegalArgumentException("oldName must not be null"); //$NON-NLS-1$ } if (newName == null) { throw new IllegalArgumentException("newName must not be null"); //$NON-NLS-1$ } Workbook workbook = info.workbook; int oldIndex = workbook.getSheetIndex(oldName); if (oldIndex < 0) { throw new IllegalArgumentException(); } Sheet newSheet = workbook.cloneSheet(oldIndex); int newIndex = workbook.getSheetIndex(newSheet); workbook.setSheetName(newIndex, newName); }
/** * Clones the current sheet. * * @see Workbook#cloneSheet(int) */ public ExportSheet cloneSheet(final int sheetNum, final String name) { final ExportSheet originSheet = getSheet(sheetNum); final Sheet poiSheet = this.poiWorkbook.cloneSheet(sheetNum); this.poiWorkbook.setSheetName(sheets.size(), name); ContentProvider cp = getContentProvider(); if (contentProvider != null) { cp = contentProvider; } else { cp = ExportConfig.getInstance().createNewContentProvider(this); } final ExportSheet sheet = new ExportSheet(cp, poiSheet.getSheetName(), poiSheet); sheet.setImported(originSheet.isImported()); sheets.add(sheet); return sheet; }
Sheet sourceCopy = sourceSheet.getWorkbook().cloneSheet(sourceSheet.getWorkbook().getSheetIndex(sourceSheet)); int sourceWidthMinus1 = tilePatternRange.getLastColumn() - tilePatternRange.getFirstColumn(); int sourceHeightMinus1 = tilePatternRange.getLastRow() - tilePatternRange.getFirstRow();