How to use

getSheet

method

in

org.pentaho.di.core.spreadsheet.KWorkbook

@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" );
}

KSheet sheet = data.workbook.getSheet( sheetName );
if ( sheet != null ) {

KSheet sheet = workbook.getSheet( j );
String sheetname = sheet.getName();

int nrSheets = workbook.getNumberOfSheets();
for ( int j = 0; j < nrSheets; j++ ) {
 KSheet sheet = workbook.getSheet( j );