Name

adams.flow.transformer.SpreadSheetInsertColumn

Synopsis

Inserts a column at a specific position into spreadsheets coming through.
The cells are initialized with a pre-defined value.

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	SpreadSheetInsertColumn

  
  
• 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

  
  
• position
  

  The position where to insert the column; An index is a number starting with 1; column names (case-sensitive) as well as the following placeholders can be used: first, second, third, last_2, last_1, last; numeric indices can be enforced by preceding them with '#' (eg '#12'); column names can be surrounded by double quotes.

  command-line	-position <adams.data.spreadsheet.SpreadSheetColumnIndex>
  default	last
  example	An index is a number starting with 1; column names (case-sensitive) as well as the following placeholders can be used: first, second, third, last_2, last_1, last; numeric indices can be enforced by preceding them with '#' (eg '#12'); column names can be surrounded by double quotes.

  
  
• after
  

  If enabled, the column is inserted after the position instead of at the position.

  command-line	-after <boolean>
  default	false

  
  
• header
  

  The name of the new column.

  command-line	-header <java.lang.String>
  default	New

  
  
• value
  

  The value to intialize the cells with; you can use '\t' for tab, '\n' for line-feed and '\r' for carriage-return.

  command-line	-value <java.lang.String>
  default	?

  
  
• valueContainsPlaceholder
  

  Set this to true to enable automatic placeholder expansion for the value string.

  command-line	-placeholder <boolean>
  default	false

  
  
• valueContainsVariable
  

  Set this to true to enable automatic variable expansion for the value string.

  command-line	-variable <boolean>
  default	false

  
  
• forceString
  

  If enabled, the value is set as string, even if it resembles a number.

  command-line	-force-string <boolean>
  default	false