Package org.pentaho.di.trans.steps.excelwriter

Class ExcelWriterStepMeta

    • Constructor Detail

      • ExcelWriterStepMeta

        public ExcelWriterStepMeta()

    • Method Detail

      • getAppendOffset

        public int getAppendOffset()

      • setAppendOffset

        public void setAppendOffset​(int appendOffset)

      • getAppendEmpty

        public int getAppendEmpty()

      • setAppendEmpty

        public void setAppendEmpty​(int appendEmpty)

      • isDateInFilename

        public boolean isDateInFilename()
        Returns:
        Returns the dateInFilename.

      • setDateInFilename

        public void setDateInFilename​(boolean dateInFilename)
        Parameters:
        dateInFilename - The dateInFilename to set.

      • isAppendOmitHeader

        public boolean isAppendOmitHeader()

      • setAppendOmitHeader

        public void setAppendOmitHeader​(boolean appendOmitHeader)

      • getStartingCell

        public String getStartingCell()

      • setStartingCell

        public void setStartingCell​(String startingCell)

      • getRowWritingMethod

        public String getRowWritingMethod()

      • setRowWritingMethod

        public void setRowWritingMethod​(String rowWritingMethod)

      • getIfFileExists

        public String getIfFileExists()

      • setIfFileExists

        public void setIfFileExists​(String ifFileExists)

      • getIfSheetExists

        public String getIfSheetExists()

      • setIfSheetExists

        public void setIfSheetExists​(String ifSheetExists)

      • getProtectedBy

        public String getProtectedBy()

      • setProtectedBy

        public void setProtectedBy​(String protectedBy)

      • getExtension

        public String getExtension()
        Returns:
        Returns the extension.

      • setExtension

        public void setExtension​(String extension)
        Parameters:
        extension - The extension to set.

      • getFileName

        public String getFileName()
        Returns:
        Returns the fileName.

      • getPassword

        public String getPassword()
        Returns:
        Returns the password.

      • getSheetname

        public String getSheetname()
        Returns:
        Returns the sheet name.

      • setSheetname

        public void setSheetname​(String sheetname)
        Parameters:
        sheetname - The sheet name.

      • setFileName

        public void setFileName​(String fileName)
        Parameters:
        fileName - The fileName to set.

      • setPassword

        public void setPassword​(String password)
        Parameters:
        password - teh passwoed to set.

      • isFooterEnabled

        public boolean isFooterEnabled()
        Returns:
        Returns the footer.

      • setFooterEnabled

        public void setFooterEnabled​(boolean footer)
        Parameters:
        footer - The footer to set.

      • isAutoSizeColums

        public boolean isAutoSizeColums()
        Returns:
        Returns the autosizecolums.

      • setAutoSizeColums

        public void setAutoSizeColums​(boolean autosizecolums)
        Parameters:
        autosizecolums - The autosizecolums to set.

      • isHeaderEnabled

        public boolean isHeaderEnabled()
        Returns:
        Returns the header.

      • setHeaderEnabled

        public void setHeaderEnabled​(boolean header)
        Parameters:
        header - The header to set.

      • isSpecifyFormat

        public boolean isSpecifyFormat()

      • setSpecifyFormat

        public void setSpecifyFormat​(boolean SpecifyFormat)

      • getDateTimeFormat

        public String getDateTimeFormat()

      • setDateTimeFormat

        public void setDateTimeFormat​(String date_time_format)

      • getSplitEvery

        public int getSplitEvery()
        Returns:
        Returns the splitEvery.

      • isAddToResultFiles

        public boolean isAddToResultFiles()
        Returns:
        Returns the add to result filesname.

      • setAddToResultFiles

        public void setAddToResultFiles​(boolean addtoresultfilenamesin)
        Parameters:
        addtoresultfilenamesin - The addtoresultfilenames to set.

      • setSplitEvery

        public void setSplitEvery​(int splitEvery)
        Parameters:
        splitEvery - The splitEvery to set.

      • isStepNrInFilename

        public boolean isStepNrInFilename()
        Returns:
        Returns the stepNrInFilename.

      • setStepNrInFilename

        public void setStepNrInFilename​(boolean stepNrInFilename)
        Parameters:
        stepNrInFilename - The stepNrInFilename to set.

      • isTimeInFilename

        public boolean isTimeInFilename()
        Returns:
        Returns the timeInFilename.

      • isSheetProtected

        public boolean isSheetProtected()
        Returns:
        Returns the protectsheet.

      • setTimeInFilename

        public void setTimeInFilename​(boolean timeInFilename)
        Parameters:
        timeInFilename - The timeInFilename to set.

      • setProtectSheet

        public void setProtectSheet​(boolean protectsheet)
        Parameters:
        protectsheet - the value to set.

      • getOutputFields

        public ExcelWriterStepField[] getOutputFields()
        Returns:
        Returns the outputFields.

      • setOutputFields

        public void setOutputFields​(ExcelWriterStepField[] outputFields)
        Parameters:
        outputFields - The outputFields to set.

      • isTemplateEnabled

        public boolean isTemplateEnabled()
        Returns:
        Returns the template.

      • setTemplateEnabled

        public void setTemplateEnabled​(boolean template)
        Parameters:
        template - The template to set.

      • isTemplateSheetEnabled

        public boolean isTemplateSheetEnabled()

      • setTemplateSheetEnabled

        public void setTemplateSheetEnabled​(boolean templateSheetEnabled)

      • getTemplateFileName

        public String getTemplateFileName()
        Returns:
        Returns the templateFileName.

      • setTemplateFileName

        public void setTemplateFileName​(String templateFileName)
        Parameters:
        templateFileName - The templateFileName to set.

      • getTemplateSheetName

        public String getTemplateSheetName()

      • setTemplateSheetName

        public void setTemplateSheetName​(String templateSheetName)

      • isDoNotOpenNewFileInit

        public boolean isDoNotOpenNewFileInit()
        Returns:
        Returns the "do not open new file at init" flag.

      • setDoNotOpenNewFileInit

        public void setDoNotOpenNewFileInit​(boolean doNotOpenNewFileInit)
        Parameters:
        doNotOpenNewFileInit - The "do not open new file at init" flag to set.

      • isAppendLines

        public boolean isAppendLines()
        Returns:
        Returns the appendLines.

      • setAppendLines

        public void setAppendLines​(boolean append)
        Parameters:
        append - The appendLines to set.

      • setMakeSheetActive

        public void setMakeSheetActive​(boolean makeSheetActive)

      • isMakeSheetActive

        public boolean isMakeSheetActive()

      • isForceFormulaRecalculation

        public boolean isForceFormulaRecalculation()

      • setForceFormulaRecalculation

        public void setForceFormulaRecalculation​(boolean forceFormulaRecalculation)

      • isLeaveExistingStylesUnchanged

        public boolean isLeaveExistingStylesUnchanged()

      • setLeaveExistingStylesUnchanged

        public void setLeaveExistingStylesUnchanged​(boolean leaveExistingStylesUnchanged)

      • loadXML

        public void loadXML​(Node stepnode,
                    List<org.pentaho.di.core.database.DatabaseMeta> databases,
                    org.pentaho.metastore.api.IMetaStore metaStore)
             throws org.pentaho.di.core.exception.KettleXMLException
        Description copied from interface: StepMetaInterface
        Load the values for this step from an XML Node
        Specified by:
        loadXML in interface StepMetaInterface
        Overrides:
        loadXML in class BaseStepMeta
        Parameters:
        stepnode - the Node to get the info from
        databases - The available list of databases to reference to
        metaStore - the metastore to optionally load external reference metadata from
        Throws:
        org.pentaho.di.core.exception.KettleXMLException - When an unexpected XML error occurred. (malformed etc.)

      • allocate

        public void allocate​(int nrfields)

      • getFiles

        public String[] getFiles​(org.pentaho.di.core.variables.VariableSpace space)

      • buildFilename

        public String buildFilename​(org.pentaho.di.core.variables.VariableSpace space,
                            int stepnr,
                            int splitnr)

      • getFields

        public void getFields​(org.pentaho.di.core.row.RowMetaInterface r,
                      String name,
                      org.pentaho.di.core.row.RowMetaInterface[] info,
                      StepMeta nextStep,
                      org.pentaho.di.core.variables.VariableSpace space,
                      Repository repository,
                      org.pentaho.metastore.api.IMetaStore metaStore)
        Description copied from class: BaseStepMeta
        Gets the fields.
        Specified by:
        getFields in interface StepMetaInterface
        Overrides:
        getFields in class BaseStepMeta
        Parameters:
        r - the input row meta that is modified in this method to reflect the output row metadata of the step
        name - Name of the step to use as input for the origin field in the values
        info - Fields used as extra lookup information
        nextStep - the next step that is targeted
        space - the space The variable space to use to replace variables
        repository - the repository to use to load Kettle metadata objects impacting the output fields
        metaStore - the MetaStore to use to load additional external data or metadata impacting the output fields

      • getXML

        public String getXML()
        Description copied from class: BaseStepMeta
        Produces the XML string that describes this step's information.
        Specified by:
        getXML in interface StepMetaInterface
        Overrides:
        getXML in class BaseStepMeta
        Returns:
        String containing the XML describing this step.

      • readRep

        public void readRep​(Repository rep,
                    org.pentaho.metastore.api.IMetaStore metaStore,
                    org.pentaho.di.repository.ObjectId id_step,
                    List<org.pentaho.di.core.database.DatabaseMeta> databases)
             throws org.pentaho.di.core.exception.KettleException
        Description copied from interface: StepMetaInterface
        Read the steps information from a Kettle repository
        Specified by:
        readRep in interface StepMetaInterface
        Overrides:
        readRep in class BaseStepMeta
        Parameters:
        rep - The repository to read from
        metaStore - The MetaStore to read external information from
        id_step - The step ID
        databases - The databases to reference
        Throws:
        org.pentaho.di.core.exception.KettleException - When an unexpected error occurred (database, network, etc)

      • saveRep

        public void saveRep​(Repository rep,
                    org.pentaho.metastore.api.IMetaStore metaStore,
                    org.pentaho.di.repository.ObjectId id_transformation,
                    org.pentaho.di.repository.ObjectId id_step)
             throws org.pentaho.di.core.exception.KettleException
        Description copied from interface: StepMetaInterface
        Save the steps data into a Kettle repository
        Specified by:
        saveRep in interface StepMetaInterface
        Overrides:
        saveRep in class BaseStepMeta
        Parameters:
        rep - The Kettle repository to save to
        metaStore - the metaStore to optionally write to
        id_transformation - The transformation ID
        id_step - The step ID
        Throws:
        org.pentaho.di.core.exception.KettleException - When an unexpected error occurred (database, network, etc)

      • check

        public void check​(List<org.pentaho.di.core.CheckResultInterface> remarks,
                  TransMeta transMeta,
                  StepMeta stepMeta,
                  org.pentaho.di.core.row.RowMetaInterface prev,
                  String[] input,
                  String[] output,
                  org.pentaho.di.core.row.RowMetaInterface info,
                  org.pentaho.di.core.variables.VariableSpace space,
                  Repository repository,
                  org.pentaho.metastore.api.IMetaStore metaStore)
        Description copied from interface: StepMetaInterface
        Checks the settings of this step and puts the findings in a remarks List.
        Specified by:
        check in interface StepMetaInterface
        Overrides:
        check in class BaseStepMeta
        Parameters:
        remarks - The list to put the remarks in @see org.pentaho.di.core.CheckResult
        stepMeta - The stepMeta to help checking
        prev - The fields coming from the previous step
        input - The input step names
        output - The output step names
        info - The fields that are used as information by the step
        space - the variable space to resolve variable expressions with
        repository - the repository to use to load Kettle metadata objects impacting the output fields
        metaStore - the MetaStore to use to load additional external data or metadata impacting the output fields

      • exportResources

        public String exportResources​(org.pentaho.di.core.variables.VariableSpace space,
                              Map<String,​ResourceDefinition> definitions,
                              ResourceNamingInterface resourceNamingInterface,
                              Repository repository,
                              org.pentaho.metastore.api.IMetaStore metaStore)
                       throws org.pentaho.di.core.exception.KettleException
        Specified by:
        exportResources in interface StepMetaInterface
        Overrides:
        exportResources in class BaseStepMeta
        Parameters:
        space - the variable space to use
        definitions -
        resourceNamingInterface -
        repository - The repository to optionally load other resources from (to be converted to XML)
        metaStore - the metaStore in which non-kettle metadata could reside.
        Returns:
        the filename of the exported resource
        Throws:
        org.pentaho.di.core.exception.KettleException

      • getStep

        public StepInterface getStep​(StepMeta stepMeta,
                             StepDataInterface stepDataInterface,
                             int cnr,
                             TransMeta transMeta,
                             Trans trans)
        Description copied from interface: StepMetaInterface
        Get the executing step, needed by Trans to launch a step.
        Specified by:
        getStep in interface StepMetaInterface
        Parameters:
        stepMeta - The step info
        stepDataInterface - the step data interface linked to this step. Here the step can store temporary data, database connections, etc.
        cnr - The copy nr to get
        transMeta - The transformation info
        trans - The launching transformation

      • getStepData

        public StepDataInterface getStepData()
        Description copied from interface: StepMetaInterface
        Get a new instance of the appropriate data class. This data class implements the StepDataInterface. It basically contains the persisting data that needs to live on, even if a worker thread is terminated.
        Specified by:
        getStepData in interface StepMetaInterface
        Returns:
        The appropriate StepDataInterface class.

      • isStreamingData

        public boolean isStreamingData()
        Returns:
        the streamingData

      • setStreamingData

        public void setStreamingData​(boolean streamingData)
        Parameters:
        streamingData - the streamingData to set

      • isTemplateSheetHidden

        public boolean isTemplateSheetHidden()

      • setTemplateSheetHidden

        public void setTemplateSheetHidden​(boolean hide)