@Test public void testRowColumnsCount() { String sameRowWidthSheet = "SameRowWidth"; String diffRowWidthSheet = "DifferentRowWidth"; checkRowCount( (OdfSheet) ods341.getSheet( sameRowWidthSheet ), 3, "Row count mismatch for ODF v3.4.1" ); checkRowCount( (OdfSheet) ods24.getSheet( sameRowWidthSheet ), 2, "Row count mismatch for ODF v2.4" ); checkRowCount( (OdfSheet) ods341.getSheet( diffRowWidthSheet ), 3, "Row count mismatch for ODF v3.4.1" ); checkRowCount( (OdfSheet) ods24.getSheet( diffRowWidthSheet ), 2, "Row count mismatch for ODF v2.4" ); checkCellCount( (OdfSheet) ods341.getSheet( sameRowWidthSheet ), 15, "Cell count mismatch for ODF v3.4.1" ); checkCellCount( (OdfSheet) ods24.getSheet( sameRowWidthSheet ), 1, "Cell count mismatch for ODF v2.4" ); checkCellCount( (OdfSheet) ods341.getSheet( diffRowWidthSheet ), new int[] { 15, 15, 12 }, "Cell count mismatch for ODF v3.4.1" ); checkCellCount( (OdfSheet) ods24.getSheet( diffRowWidthSheet ), new int[] { 3, 2 }, "Cell count mismatch for ODF v2.4" ); }
private void jumpToNextFile() throws KettleException { data.sheetnr = 0; // Reset the start-row: data.rownr = -1; // no previous row yet, don't take it from the previous sheet! (that // whould be plain wrong!) data.previousRow = null; // Close the openFile! data.workbook.close(); data.workbook = null; // marker to open again. data.errorHandler.close(); // advance to the next file! data.filenr++; }
.getEncoding(), wPassword.getText() ); int nrSheets = workbook.getNumberOfSheets(); for ( int j = 0; j < nrSheets; j++ ) { KSheet sheet = workbook.getSheet( j ); String sheetname = sheet.getName(); workbook.close(); } catch ( Exception e ) { new ErrorDialog(
int nrSheets = workbook.getNumberOfSheets(); for ( int j = 0; j < nrSheets; j++ ) { KSheet sheet = workbook.getSheet( j );
data.sheetNames = data.workbook.getSheetNames(); data.startColumn = new int[data.sheetNames.length]; data.startRow = new int[data.sheetNames.length]; KSheet sheet = data.workbook.getSheet( sheetName ); if ( sheet != null ) {
public void dispose( StepMetaInterface smi, StepDataInterface sdi ) { meta = (ExcelInputMeta) smi; data = (ExcelInputData) sdi; if ( data.workbook != null ) { data.workbook.close(); } if ( data.file != null ) { try { data.file.close(); } catch ( Exception e ) { // Ignore close errors } } try { data.errorHandler.close(); } catch ( KettleException e ) { if ( log.isDebug() ) { logDebug( BaseMessages.getString( PKG, "ExcelInput.Error.CouldNotCloseErrorHandler", e.toString() ) ); logDebug( Const.getStackTracker( e ) ); } } super.dispose( smi, sdi ); } }
.getEncoding(), wPassword.getText() ); processingWorkbook( fields, info, workbook ); workbook.close(); } catch ( Exception e ) { new ErrorDialog( shell, BaseMessages.getString( PKG, "System.Dialog.Error.Title" ), BaseMessages