Name

adams.flow.transformer.SpreadSheetConvertCells

Synopsis

Finds cells in a spreadsheet and converts them with a conversion scheme.
If the conversion scheme 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 converted 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	SpreadSheetConvertCells

  
  
• 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

  
  
• 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

  
  
• conversion
  

  The conversion to apply to the located cells.

  command-line	-conversion <adams.data.conversion.Conversion>
  default	adams.data.conversion.ObjectToObject