RecalcXLSProcessor

java.lang.Object

net.simplace.pipe.control.FWProcessor

net.simplace.client.pipe.processors.RecalcXLSProcessor

public class RecalcXLSProcessor extends FWProcessor

Author:: sbrocks Recalculates the HSSFSheet ${sheet} in the .xls file ${filein}, from ${startcellid} to ${endcellid}, and saves the recalculated to the .xls file ${fileout}, located in the folder ${targetdir} Note: startcell must be to the (upper)left of endcell Note: formulas get changed to the values they calculate to. Note: String formulas are not supported. attention: formulas that where extended across multiple cells in excel by dragging and letting excel automatically change the cells referenced in the formula don't recalculate properly, i suspect a bug in the HSSF library.

Field Summary

Fields inherited from class net.simplace.pipe.control.FWProcessor
iAllreadyLoopedCount, iContainer, iInObservable, iObservable, iProgressTasks
Constructor Summary

Constructors

Constructor

Description

RecalcXLSProcessor()
Method Summary

Modifier and Type

Method

Description

protected boolean

process()

Must be overridden to implement concrete pipe procedure.

Methods inherited from class net.simplace.pipe.control.FWProcessor
checkInParameterMap, checkOutParameterMap, clone, containsParameter, createProcessor, createProcessor, fireTaskEvent, getAllStringInParameters, getConfiguration, getInitialParameters, getInParameter, getInParameter, getInParameters, getNewProgressTask, getOutParameter, getOutParameterKeys, getPipeLine, getProgressTask, getStringInParameter, getStringInParameter, getSystemID, hasConfiguration, isEndOfPipe, pipe, removeOutParameter, setConfiguration, setEndOfPipeFlag, setInitialParameters, setInParameterMap, setLoopedCount, setOutParameter, setStateOfTask, setStateProgressing, toXML

Methods inherited from class java.lang.Object
equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details
- RecalcXLSProcessor
  
  public RecalcXLSProcessor()
Method Details
- process
  
  protected boolean process() throws PipeLineException
  
  Description copied from class: FWProcessor
  
  Must be overridden to implement concrete pipe procedure.
  
  Specified by:
  
  process in class FWProcessor
  
  Returns:
  
  success
  
  Throws:
  
  PipeLineException