How to use
KWorkbook
in
org.pentaho.di.core.spreadsheet

Best Java code snippets using org.pentaho.di.core.spreadsheet.KWorkbook (Showing top 7 results out of 315)

Add the Codota plugin to your IDE and get smart completions

private void myMethod () {
 ScheduledThreadPoolExecutor s =new ScheduledThreadPoolExecutor(corePoolSize)
ThreadFactory threadFactory;new ScheduledThreadPoolExecutor(corePoolSize, threadFactory)
String str;new ScheduledThreadPoolExecutor(1, new ThreadFactoryBuilder().setNameFormat(str).build())
Smart code suggestions by Codota
}

@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

Most used methods

getSheet
Get a sheet with a certain name in a workbook.
close
Close the workbook file
getNumberOfSheets
getSheetNames

Popular in Java

Creating JSON documents from java classes using gson
findViewById (Activity)
onCreateOptionsMenu (Activity)
getSupportFragmentManager (FragmentActivity)
Return the FragmentManager for interacting with fragments associated with this activity.
FileInputStream (java.io)
A FileInputStream obtains input bytes from a file in a file system. What files are available depends
Comparator (java.util)
A Comparator is used to compare two objects to determine their ordering with respect to each other.
Set (java.util)
A collection that contains no duplicate elements. More formally, sets contain no pair of elements e1
Reference (javax.naming)
Scheduler (org.quartz)
This is the main interface of a Quartz Scheduler. A Scheduler maintains a registery of org.quartz
Logger (org.slf4j)
The main user interface to logging. It is expected that logging takes place through concrete impleme

How to useKWorkbook in org.pentaho.di.core.spreadsheet

Best Java code snippets using org.pentaho.di.core.spreadsheet.KWorkbook (Showing top 7 results out of 315)

How to use
KWorkbook
in
org.pentaho.di.core.spreadsheet