Name

adams.flow.transformer.SpreadSheetTransformCells

Synopsis

Finds cells in a spreadsheet and transforms them with a callable transformer.
In case of transformers having Object or Unknown in their types of classes that they accept, no proper type can be inferred automatically. Therefore it is recommended to manually enforce the 'input type'.
If the transformer generates a adams.data.spreadsheet.SpreadSheet object itself, this will get merged with the enclosing one: any additional columns get added and the content of the first row gets added to the row the trasnformed cell belongs to.

Additional information

Flow input/output:
- input: adams.data.spreadsheet.SpreadSheet
- output: adams.data.spreadsheet.SpreadSheet

Options

• loggingLevel
  

  The logging level for outputting errors and debugging output.

  command-line	-logging-level <OFF|SEVERE|WARNING|INFO|CONFIG|FINE|FINER|FINEST>
  default	WARNING
  min-user-mode	Expert

  
  
• name
  

  The name of the actor.

  command-line	-name <java.lang.String>
  default	SpreadSheetTransformCells

  
  
• annotations
  

  The annotations to attach to this actor.

  command-line	-annotation <adams.core.base.BaseAnnotation>
  default

  
  
• skip
  

  If set to true, transformation is skipped and the input token is just forwarded as it is.

  command-line	-skip <boolean>
  default	false

  
  
• stopFlowOnError
  

  If set to true, the flow execution at this level gets stopped in case this actor encounters an error; the error gets propagated; useful for critical actors.

  command-line	-stop-flow-on-error <boolean>
  default	false
  min-user-mode	Expert

  
  
• silent
  

  If enabled, then no errors are output in the console; Note: the enclosing actor handler must have this enabled as well.

  command-line	-silent <boolean>
  default	false
  min-user-mode	Expert

  
  
• noCopy
  

  If enabled, no copy of the spreadsheet is created before processing it.

  command-line	-no-copy <boolean>
  default	false

  
  
• finder
  

  The cell finder to use.

  command-line	-finder <adams.data.spreadsheet.cellfinder.CellFinder>
  default	adams.data.spreadsheet.cellfinder.CellRange

  
  
• forceInputType
  

  If enabled, the input type is forced to a user-specified type, rather than trying to determine type based on data types that the callable transformer accepts.

  command-line	-force-input-type <boolean>
  default	false

  
  
• inputType
  

  The input type to use in case the input type is enforced.

  command-line	-input-type <MISSING|STRING|BOOLEAN|LONG|DOUBLE|DATE|DATETIME|DATETIMEMSEC|TIME|TIMEMSEC|OBJECT>
  default	STRING

  
  
• skipMissing
  

  If enabled, missing cells are skipped.

  command-line	-skip-missing <boolean>
  default	true

  
  
• missingReplacementValue
  

  The string representation of the value to use for replacing missing values.

  command-line	-missing-replacement-value <java.lang.String>
  default

  
  
• missingReplacementType
  

  The data type to use for the replacement value for missing values.

  command-line	-missing-replacement-type <MISSING|STRING|BOOLEAN|LONG|DOUBLE|DATE|DATETIME|DATETIMEMSEC|TIME|TIMEMSEC|OBJECT>
  default	STRING

  
  
• transformer
  

  The callable transformer to apply to the located cells.

  command-line	-transformer <adams.flow.core.CallableActorReference>
  default	unknown