ExcelOutputMeta

java.lang.Object
- org.pentaho.di.trans.step.BaseStepMeta
- - org.pentaho.di.trans.steps.exceloutput.ExcelOutputMeta

All Implemented Interfaces:

Cloneable, StepAttributesInterface, StepMetaInterface
```
public class ExcelOutputMeta
extends BaseStepMeta
implements StepMetaInterface
```
Metadata of the Excel Output step.

Since:

on 6-sep-2006

Author:

Matt

Field Summary

Fields
Modifier and Type	Field and Description
`static int`	`DEFAULT_FONT_SIZE`
`static int`	`DEFAULT_ROW_HEIGHT`
`static int`	`DEFAULT_ROW_WIDTH`
`static int`	`FONT_ALIGNMENT_CENTER`
`static String[]`	`font_alignment_code`
`static String[]`	`font_alignment_desc`
`static int`	`FONT_ALIGNMENT_FILL`
`static int`	`FONT_ALIGNMENT_GENERAL`
`static int`	`FONT_ALIGNMENT_JUSTIFY`
`static int`	`FONT_ALIGNMENT_LEFT`
`static int`	`FONT_ALIGNMENT_RIGHT`
`static int`	`FONT_COLOR_AQUA`
`static int`	`FONT_COLOR_BLACK`
`static int`	`FONT_COLOR_BLUE`
`static int`	`FONT_COLOR_BLUE_GREY`
`static int`	`FONT_COLOR_BRIGHT_GREEN`
`static int`	`FONT_COLOR_BROWN`
`static String[]`	`font_color_code`
`static int`	`FONT_COLOR_CORAL`
`static int`	`FONT_COLOR_DARK_BLUE`
`static int`	`FONT_COLOR_DARK_GREEN`
`static int`	`FONT_COLOR_DARK_PURPLE`
`static int`	`FONT_COLOR_DARK_RED`
`static int`	`FONT_COLOR_DARK_TEAL`
`static int`	`FONT_COLOR_DARK_YELLOW`
`static String[]`	`font_color_desc`
`static int`	`FONT_COLOR_GOLD`
`static int`	`FONT_COLOR_GREEN`
`static int`	`FONT_COLOR_GREY_25pct`
`static int`	`FONT_COLOR_GREY_40pct`
`static int`	`FONT_COLOR_GREY_50pct`
`static int`	`FONT_COLOR_GREY_80pct`
`static int`	`FONT_COLOR_ICE_BLUE`
`static int`	`FONT_COLOR_IVORY`
`static int`	`FONT_COLOR_LAVENDER`
`static int`	`FONT_COLOR_LIGHT_BLUE`
`static int`	`FONT_COLOR_LIGHT_GREEN`
`static int`	`FONT_COLOR_LIGHT_ORANGE`
`static int`	`FONT_COLOR_LIGHT_TURQUOISE`
`static int`	`FONT_COLOR_LIME`
`static int`	`FONT_COLOR_NONE`
`static int`	`FONT_COLOR_OCEAN_BLUE`
`static int`	`FONT_COLOR_OLIVE_GREEN`
`static int`	`FONT_COLOR_ORANGE`
`static int`	`FONT_COLOR_PALE_BLUE`
`static int`	`FONT_COLOR_PERIWINKLEpct`
`static int`	`FONT_COLOR_PINK`
`static int`	`FONT_COLOR_PLUM`
`static int`	`FONT_COLOR_RED`
`static int`	`FONT_COLOR_ROSE`
`static int`	`FONT_COLOR_SEA_GREEN`
`static int`	`FONT_COLOR_SKY_BLUE`
`static int`	`FONT_COLOR_TAN`
`static int`	`FONT_COLOR_TEAL`
`static int`	`FONT_COLOR_TURQOISE`
`static int`	`FONT_COLOR_TURQUOISE`
`static int`	`FONT_COLOR_VERY_LIGHT_YELLOW`
`static int`	`FONT_COLOR_VIOLET`
`static int`	`FONT_COLOR_WHITE`
`static int`	`FONT_COLOR_YELLOW`
`static int`	`FONT_NAME_ARIAL`
`static String[]`	`font_name_code`
`static int`	`FONT_NAME_COURIER`
`static String[]`	`font_name_desc`
`static int`	`FONT_NAME_TAHOMA`
`static int`	`FONT_NAME_TIMES`
`static String[]`	`font_orientation_code`
`static String[]`	`font_orientation_desc`
`static int`	`FONT_ORIENTATION_HORIZONTAL`
`static int`	`FONT_ORIENTATION_MINUS_45`
`static int`	`FONT_ORIENTATION_MINUS_90`
`static int`	`FONT_ORIENTATION_PLUS_45`
`static int`	`FONT_ORIENTATION_PLUS_90`
`static int`	`FONT_ORIENTATION_STACKED`
`static int`	`FONT_ORIENTATION_VERTICAL`
`static String[]`	`font_underline_code`
`static String[]`	`font_underline_desc`
`static int`	`FONT_UNDERLINE_DOUBLE`
`static int`	`FONT_UNDERLINE_DOUBLE_ACCOUNTING`
`static int`	`FONT_UNDERLINE_NO`
`static int`	`FONT_UNDERLINE_SINGLE`
`static int`	`FONT_UNDERLINE_SINGLE_ACCOUNTING`

Fields inherited from class org.pentaho.di.trans.step.BaseStepMeta
loggingObject, STEP_ATTRIBUTES_FILE

Constructor Summary

Constructors
Constructor and Description

ExcelOutputMeta()

Constructors
Constructor and Description
`ExcelOutputMeta()`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`void`	`allocate(int nrfields)`
`String`	`buildFilename(org.pentaho.di.core.variables.VariableSpace space, int stepnr, int splitnr)`
`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)` Checks the settings of this step and puts the findings in a remarks List.
`Object`	`clone()` Make an exact copy of this step, make sure to explicitly copy Collections etc.
`String`	`exportResources(org.pentaho.di.core.variables.VariableSpace space, Map<String,ResourceDefinition> definitions, ResourceNamingInterface resourceNamingInterface, Repository repository, org.pentaho.metastore.api.IMetaStore metaStore)`
`String`	`getDateTimeFormat()`
`String`	`getEncoding()`
`String`	`getExtension()`
`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)` Gets the fields.
`String`	`getFileName()`
`String[]`	`getFiles(org.pentaho.di.core.variables.VariableSpace space)`
`static int`	`getFontAlignmentByDesc(String tt)`
`static String`	`getFontAlignmentDesc(int i)`
`static int`	`getFontColorByDesc(String tt)`
`static String`	`getFontColorDesc(int i)`
`static int`	`getFontNameByDesc(String tt)`
`static String`	`getFontNameDesc(int i)`
`static int`	`getFontOrientationByDesc(String tt)`
`static String`	`getFontOrientationDesc(int i)`
`static int`	`getFontUnderlineByDesc(String tt)`
`static String`	`getFontUnderlineDesc(int i)`
`int`	`getHeaderAlignment()`
`int`	`getHeaderBackGroundColor()`
`int`	`getHeaderFontColor()`
`int`	`getHeaderFontName()`
`int`	`getHeaderFontOrientation()`
`String`	`getHeaderFontSize()`
`int`	`getHeaderFontUnderline()`
`String`	`getHeaderImage()`
`String`	`getHeaderRowHeight()`
`String`	`getNewline()`
`String`	`getNewLine(String fformat)`
`ExcelField[]`	`getOutputFields()`
`String`	`getPassword()`
`int`	`getRowBackGroundColor()`
`int`	`getRowFontColor()`
`int`	`getRowFontName()`
`String`	`getRowFontSize()`
`String`	`getSheetname()`
`int`	`getSplitEvery()`
`StepInterface`	`getStep(StepMeta stepMeta, StepDataInterface stepDataInterface, int cnr, TransMeta transMeta, Trans trans)` Get the executing step, needed by Trans to launch a step.
`StepDataInterface`	`getStepData()` Get a new instance of the appropriate data class.
`String`	`getTempDirectory()`
`String`	`getTemplateFileName()`
`String[]`	`getUsedLibraries()`
`String`	`getXML()` Produces the XML string that describes this step's information.
`boolean`	`isAddToResultFiles()`
`boolean`	`isAppend()`
`boolean`	`isAutoSizeColumns()`
`boolean`	`isAutoSizeColums()` Deprecated. due to typo
`boolean`	`isCreateParentFolder()`
`boolean`	`isDateInFilename()`
`boolean`	`isDoNotOpenNewFileInit()`
`boolean`	`isFooterEnabled()`
`boolean`	`isHeaderEnabled()`
`boolean`	`isHeaderFontBold()`
`boolean`	`isHeaderFontItalic()`
`boolean`	`isNullBlank()`
`boolean`	`isSheetProtected()`
`boolean`	`isSpecifyFormat()`
`boolean`	`isStepNrInFilename()`
`boolean`	`isTemplateAppend()`
`boolean`	`isTemplateEnabled()`
`boolean`	`isTimeInFilename()`
`boolean`	`isUseTempFiles()`
`void`	`loadXML(Node stepnode, List<org.pentaho.di.core.database.DatabaseMeta> databases, org.pentaho.metastore.api.IMetaStore metaStore)` Load the values for this step from an XML Node
`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)` Read the steps information from a Kettle repository
`void`	`saveRep(Repository rep, org.pentaho.metastore.api.IMetaStore metaStore, org.pentaho.di.repository.ObjectId id_transformation, org.pentaho.di.repository.ObjectId id_step)` Save the steps data into a Kettle repository
`void`	`setAddToResultFiles(boolean addtoresultfilenamesin)`
`void`	`setAppend(boolean append)`
`void`	`setAutoSizeColumns(boolean autosizecolums)`
`void`	`setAutoSizeColums(boolean autosizecolums)` Deprecated. due to typo
`void`	`setCreateParentFolder(boolean createparentfolder)`
`void`	`setDateInFilename(boolean dateInFilename)`
`void`	`setDateTimeFormat(String date_time_format)`
`void`	`setDefault()` Set default values
`void`	`setDoNotOpenNewFileInit(boolean doNotOpenNewFileInit)`
`void`	`setEncoding(String encoding)`
`void`	`setExtension(String extension)`
`void`	`setFileName(String fileName)`
`void`	`setFooterEnabled(boolean footer)`
`void`	`setHeaderAlignment(int alignment)`
`void`	`setHeaderAlignment(String alignment)`
`void`	`setHeaderBackGroundColor(int fontcolor)`
`void`	`setHeaderEnabled(boolean header)`
`void`	`setHeaderFontBold(boolean font_bold)`
`void`	`setHeaderFontColor(int fontcolor)`
`void`	`setHeaderFontItalic(boolean fontitalic)`
`void`	`setHeaderFontName(int fontname)`
`void`	`setHeaderFontName(String fontname)`
`void`	`setHeaderFontOrientation(int fontorientation)`
`void`	`setHeaderFontOrientation(String fontorientation)`
`void`	`setHeaderFontSize(String fontsize)`
`void`	`setHeaderFontUnderline(int fontunderline)`
`void`	`setHeaderFontUnderline(String fontunderline)`
`void`	`setHeaderImage(String image)`
`void`	`setHeaderRowHeight(String height)`
`void`	`setNewline(String newline)`
`void`	`setNullIsBlank(boolean nullIsBlank)`
`void`	`setOutputFields(ExcelField[] outputFields)`
`void`	`setPassword(String password)`
`void`	`setProtectSheet(boolean protectsheet)`
`void`	`setRowBackGroundColor(int fontcolor)`
`void`	`setRowFontColor(int fontcolor)`
`void`	`setRowFontName(int fontname)`
`void`	`setRowFontName(String fontname)`
`void`	`setRowFontSize(String fontsize)`
`void`	`setSheetname(String sheetname)`
`void`	`setSpecifyFormat(boolean SpecifyFormat)`
`void`	`setSplitEvery(int splitEvery)`
`void`	`setStepNrInFilename(boolean stepNrInFilename)`
`void`	`setTempDirectory(String directory)`
`void`	`setTemplateAppend(boolean templateAppend)`
`void`	`setTemplateEnabled(boolean template)`
`void`	`setTemplateFileName(String templateFileName)`
`void`	`setTimeInFilename(boolean timeInFilename)`
`void`	`setUseTempFiles(boolean usetempfiles)`

Methods inherited from class org.pentaho.di.trans.step.BaseStepMeta
analyseImpact, analyseImpact, cancelQueries, check, check, excludeFromCopyDistributeVerification, excludeFromRowLayoutVerification, exportResources, extractStepMetadataEntries, findAttribute, findParent, getActiveReferencedObjectDescription, getDescription, getDialogClassName, getFields, getLog, getLogChannelId, getName, getObjectCopy, getObjectId, getObjectRevision, getObjectType, getOptionalStreams, getParent, getParentStepMeta, getReferencedObjectDescriptions, getRepCode, getRepositoryDirectory, getRequiredFields, getRequiredFields, getResourceDependencies, getSQLStatements, getSQLStatements, getStepInjectionMetadataEntries, getStepIOMeta, getStepMetaInjectionInterface, getSupportedTransformationTypes, getTableFields, getTooltip, getUsedArguments, getUsedDatabaseConnections, getXmlCode, handleStreamSelection, hasChanged, hasRepositoryReferences, isBasic, isDebug, isDetailed, isReferencedObjectEnabled, isRowLevel, loadReferencedObject, loadReferencedObject, loadXML, loadXML, logBasic, logBasic, logDebug, logDebug, logDetailed, logDetailed, logError, logError, logError, logMinimal, logMinimal, logRowlevel, logRowlevel, lookupRepositoryReferences, readRep, readRep, resetStepIoMeta, saveRep, searchInfoAndTargetSteps, setChanged, setChanged, setParentStepMeta, supportsErrorHandling

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

Methods inherited from interface org.pentaho.di.trans.step.StepMetaInterface
analyseImpact, analyseImpact, cancelQueries, check, excludeFromCopyDistributeVerification, excludeFromRowLayoutVerification, exportResources, extractStepMetadataEntries, getActiveReferencedObjectDescription, getDialogClassName, getFields, getOptionalStreams, getParentStepMeta, getReferencedObjectDescriptions, getRequiredFields, getResourceDependencies, getSQLStatements, getSQLStatements, getStepIOMeta, getStepMetaInjectionInterface, getSupportedTransformationTypes, getTableFields, getUsedArguments, getUsedDatabaseConnections, handleStreamSelection, hasChanged, hasRepositoryReferences, isReferencedObjectEnabled, loadReferencedObject, loadXML, lookupRepositoryReferences, readRep, resetStepIoMeta, saveRep, searchInfoAndTargetSteps, setChanged, setParentStepMeta, supportsErrorHandling

- Field Detail
  - FONT_NAME_ARIAL
```
public static final int FONT_NAME_ARIAL
```
    See Also:
    
    Constant Field Values
  - FONT_NAME_COURIER
```
public static final int FONT_NAME_COURIER
```
    See Also:
    
    Constant Field Values
  - FONT_NAME_TAHOMA
```
public static final int FONT_NAME_TAHOMA
```
    See Also:
    
    Constant Field Values
  - FONT_NAME_TIMES
```
public static final int FONT_NAME_TIMES
```
    See Also:
    
    Constant Field Values
  - font_name_code
```
public static final String[] font_name_code
```
  - font_name_desc
```
public static final String[] font_name_desc
```
  - FONT_UNDERLINE_NO
```
public static final int FONT_UNDERLINE_NO
```
    See Also:
    
    Constant Field Values
  - FONT_UNDERLINE_SINGLE
```
public static final int FONT_UNDERLINE_SINGLE
```
    See Also:
    
    Constant Field Values
  - FONT_UNDERLINE_SINGLE_ACCOUNTING
```
public static final int FONT_UNDERLINE_SINGLE_ACCOUNTING
```
    See Also:
    
    Constant Field Values
  - FONT_UNDERLINE_DOUBLE
```
public static final int FONT_UNDERLINE_DOUBLE
```
    See Also:
    
    Constant Field Values
  - FONT_UNDERLINE_DOUBLE_ACCOUNTING
```
public static final int FONT_UNDERLINE_DOUBLE_ACCOUNTING
```
    See Also:
    
    Constant Field Values
  - font_underline_code
```
public static final String[] font_underline_code
```
  - font_underline_desc
```
public static final String[] font_underline_desc
```
  - FONT_ORIENTATION_HORIZONTAL
```
public static final int FONT_ORIENTATION_HORIZONTAL
```
    See Also:
    
    Constant Field Values
  - FONT_ORIENTATION_MINUS_45
```
public static final int FONT_ORIENTATION_MINUS_45
```
    See Also:
    
    Constant Field Values
  - FONT_ORIENTATION_MINUS_90
```
public static final int FONT_ORIENTATION_MINUS_90
```
    See Also:
    
    Constant Field Values
  - FONT_ORIENTATION_PLUS_45
```
public static final int FONT_ORIENTATION_PLUS_45
```
    See Also:
    
    Constant Field Values
  - FONT_ORIENTATION_PLUS_90
```
public static final int FONT_ORIENTATION_PLUS_90
```
    See Also:
    
    Constant Field Values
  - FONT_ORIENTATION_STACKED
```
public static final int FONT_ORIENTATION_STACKED
```
    See Also:
    
    Constant Field Values
  - FONT_ORIENTATION_VERTICAL
```
public static final int FONT_ORIENTATION_VERTICAL
```
    See Also:
    
    Constant Field Values
  - font_orientation_code
```
public static final String[] font_orientation_code
```
  - font_orientation_desc
```
public static final String[] font_orientation_desc
```
  - FONT_COLOR_NONE
```
public static final int FONT_COLOR_NONE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_BLACK
```
public static final int FONT_COLOR_BLACK
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_WHITE
```
public static final int FONT_COLOR_WHITE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_RED
```
public static final int FONT_COLOR_RED
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_BRIGHT_GREEN
```
public static final int FONT_COLOR_BRIGHT_GREEN
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_BLUE
```
public static final int FONT_COLOR_BLUE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_YELLOW
```
public static final int FONT_COLOR_YELLOW
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_PINK
```
public static final int FONT_COLOR_PINK
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_TURQUOISE
```
public static final int FONT_COLOR_TURQUOISE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_DARK_RED
```
public static final int FONT_COLOR_DARK_RED
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_GREEN
```
public static final int FONT_COLOR_GREEN
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_DARK_BLUE
```
public static final int FONT_COLOR_DARK_BLUE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_DARK_YELLOW
```
public static final int FONT_COLOR_DARK_YELLOW
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_VIOLET
```
public static final int FONT_COLOR_VIOLET
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_TEAL
```
public static final int FONT_COLOR_TEAL
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_GREY_25pct
```
public static final int FONT_COLOR_GREY_25pct
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_GREY_50pct
```
public static final int FONT_COLOR_GREY_50pct
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_PERIWINKLEpct
```
public static final int FONT_COLOR_PERIWINKLEpct
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_PLUM
```
public static final int FONT_COLOR_PLUM
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_IVORY
```
public static final int FONT_COLOR_IVORY
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_LIGHT_TURQUOISE
```
public static final int FONT_COLOR_LIGHT_TURQUOISE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_DARK_PURPLE
```
public static final int FONT_COLOR_DARK_PURPLE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_CORAL
```
public static final int FONT_COLOR_CORAL
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_OCEAN_BLUE
```
public static final int FONT_COLOR_OCEAN_BLUE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_ICE_BLUE
```
public static final int FONT_COLOR_ICE_BLUE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_TURQOISE
```
public static final int FONT_COLOR_TURQOISE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_SKY_BLUE
```
public static final int FONT_COLOR_SKY_BLUE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_LIGHT_GREEN
```
public static final int FONT_COLOR_LIGHT_GREEN
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_VERY_LIGHT_YELLOW
```
public static final int FONT_COLOR_VERY_LIGHT_YELLOW
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_PALE_BLUE
```
public static final int FONT_COLOR_PALE_BLUE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_ROSE
```
public static final int FONT_COLOR_ROSE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_LAVENDER
```
public static final int FONT_COLOR_LAVENDER
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_TAN
```
public static final int FONT_COLOR_TAN
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_LIGHT_BLUE
```
public static final int FONT_COLOR_LIGHT_BLUE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_AQUA
```
public static final int FONT_COLOR_AQUA
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_LIME
```
public static final int FONT_COLOR_LIME
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_GOLD
```
public static final int FONT_COLOR_GOLD
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_LIGHT_ORANGE
```
public static final int FONT_COLOR_LIGHT_ORANGE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_ORANGE
```
public static final int FONT_COLOR_ORANGE
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_BLUE_GREY
```
public static final int FONT_COLOR_BLUE_GREY
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_GREY_40pct
```
public static final int FONT_COLOR_GREY_40pct
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_DARK_TEAL
```
public static final int FONT_COLOR_DARK_TEAL
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_SEA_GREEN
```
public static final int FONT_COLOR_SEA_GREEN
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_DARK_GREEN
```
public static final int FONT_COLOR_DARK_GREEN
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_OLIVE_GREEN
```
public static final int FONT_COLOR_OLIVE_GREEN
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_BROWN
```
public static final int FONT_COLOR_BROWN
```
    See Also:
    
    Constant Field Values
  - FONT_COLOR_GREY_80pct
```
public static final int FONT_COLOR_GREY_80pct
```
    See Also:
    
    Constant Field Values
  - font_color_code
```
public static final String[] font_color_code
```
  - font_color_desc
```
public static final String[] font_color_desc
```
  - FONT_ALIGNMENT_LEFT
```
public static final int FONT_ALIGNMENT_LEFT
```
    See Also:
    
    Constant Field Values
  - FONT_ALIGNMENT_RIGHT
```
public static final int FONT_ALIGNMENT_RIGHT
```
    See Also:
    
    Constant Field Values
  - FONT_ALIGNMENT_CENTER
```
public static final int FONT_ALIGNMENT_CENTER
```
    See Also:
    
    Constant Field Values
  - FONT_ALIGNMENT_FILL
```
public static final int FONT_ALIGNMENT_FILL
```
    See Also:
    
    Constant Field Values
  - FONT_ALIGNMENT_GENERAL
```
public static final int FONT_ALIGNMENT_GENERAL
```
    See Also:
    
    Constant Field Values
  - FONT_ALIGNMENT_JUSTIFY
```
public static final int FONT_ALIGNMENT_JUSTIFY
```
    See Also:
    
    Constant Field Values
  - font_alignment_code
```
public static final String[] font_alignment_code
```
  - font_alignment_desc
```
public static final String[] font_alignment_desc
```
  - DEFAULT_FONT_SIZE
```
public static final int DEFAULT_FONT_SIZE
```
    See Also:
    
    Constant Field Values
  - DEFAULT_ROW_HEIGHT
```
public static final int DEFAULT_ROW_HEIGHT
```
    See Also:
    
    Constant Field Values
  - DEFAULT_ROW_WIDTH
```
public static final int DEFAULT_ROW_WIDTH
```
    See Also:
    
    Constant Field Values
- Constructor Detail
  - ExcelOutputMeta
```
public ExcelOutputMeta()
```
- Method Detail
  - isCreateParentFolder
```
public boolean isCreateParentFolder()
```
    Returns:
    
    Returns the createparentfolder.
  - setCreateParentFolder
```
public void setCreateParentFolder(boolean createparentfolder)
```
    Parameters:
    
    createparentfolder - The createparentfolder to set.
  - isDateInFilename
```
public boolean isDateInFilename()
```
    Returns:
    
    Returns the dateInFilename.
  - setDateInFilename
```
public void setDateInFilename(boolean dateInFilename)
```
    Parameters:
    
    dateInFilename - The dateInFilename to set.
  - 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.
  - isAutoSizeColumns
```
public boolean isAutoSizeColumns()
```
    Returns:
    
    Returns the autosizecolumns.
  - setAutoSizeColumns
```
public void setAutoSizeColumns(boolean autosizecolums)
```
    Parameters:
    
    autosizecolumns - The autosizecolumns to set.
  - isAutoSizeColums
```
@Deprecated
public boolean isAutoSizeColums()
```
    Deprecated. due to typo
    
    Returns:
    
    Returns the autosizecolums.
  - setAutoSizeColums
```
@Deprecated
public void setAutoSizeColums(boolean autosizecolums)
```
    Deprecated. due to typo
    
    Parameters:
    
    autosizecolums - The autosizecolums to set.
  - setTempDirectory
```
public void setTempDirectory(String directory)
```
  - getTempDirectory
```
public String getTempDirectory()
```
  - isNullBlank
```
public boolean isNullBlank()
```
    Returns:
    
    Returns whether or not null values are written as blank cells.
  - setNullIsBlank
```
public void setNullIsBlank(boolean nullIsBlank)
```
    Parameters:
    
    setNullIsBlank - The boolean indicating whether or not to write null values as blank cells
  - 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)
```
  - getNewline
```
public String getNewline()
```
    Returns:
    
    Returns the newline.
  - setNewline
```
public void setNewline(String newline)
```
    Parameters:
    
    newline - The newline to set.
  - 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.
  - isUseTempFiles
```
public boolean isUseTempFiles()
```
    Returns:
    
    Returns the usetempfile.
  - setUseTempFiles
```
public void setUseTempFiles(boolean usetempfiles)
```
    Parameters:
    
    usetempfiles - The usetempfiles to set.
  - getOutputFields
```
public ExcelField[] getOutputFields()
```
    Returns:
    
    Returns the outputFields.
  - setOutputFields
```
public void setOutputFields(ExcelField[] outputFields)
```
    Parameters:
    
    outputFields - The outputFields to set.
  - getEncoding
```
public String getEncoding()
```
    Returns:
    
    The desired encoding of output file, null or empty if the default system encoding needs to be used.
  - setEncoding
```
public void setEncoding(String encoding)
```
    Parameters:
    
    encoding - The desired encoding of output file, null or empty if the default system encoding needs to be used.
  - isTemplateEnabled
```
public boolean isTemplateEnabled()
```
    Returns:
    
    Returns the template.
  - setTemplateEnabled
```
public void setTemplateEnabled(boolean template)
```
    Parameters:
    
    template - The template to set.
  - isTemplateAppend
```
public boolean isTemplateAppend()
```
    Returns:
    
    Returns the templateAppend.
  - setTemplateAppend
```
public void setTemplateAppend(boolean templateAppend)
```
    Parameters:
    
    templateAppend - The templateAppend to set.
  - getTemplateFileName
```
public String getTemplateFileName()
```
    Returns:
    
    Returns the templateFileName.
  - setTemplateFileName
```
public void setTemplateFileName(String templateFileName)
```
    Parameters:
    
    templateFileName - The templateFileName to set.
  - 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.
  - isAppend
```
public boolean isAppend()
```
    Returns:
    
    Returns the append.
  - setAppend
```
public void setAppend(boolean append)
```
    Parameters:
    
    append - The append to set.
  - 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)
```
  - clone
```
public Object clone()
```
    Description copied from interface: StepMetaInterface
    
    Make an exact copy of this step, make sure to explicitly copy Collections etc.
    
    Specified by:
    
    clone in interface StepMetaInterface
    
    Overrides:
    
    clone in class BaseStepMeta
    
    Returns:
    
    an exact copy of this step
  - getNewLine
```
public String getNewLine(String fformat)
```
  - setDefault
```
public void setDefault()
```
    Description copied from interface: StepMetaInterface
    
    Set default values
    
    Specified by:
    
    setDefault in interface StepMetaInterface
  - 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.
  - getUsedLibraries
```
public String[] getUsedLibraries()
```
    Specified by:
    
    getUsedLibraries in interface StepMetaInterface
    
    Overrides:
    
    getUsedLibraries in class BaseStepMeta
    
    Returns:
    
    the libraries that this step or plug-in uses.
  - getFontNameDesc
```
public static String getFontNameDesc(int i)
```
  - getFontUnderlineDesc
```
public static String getFontUnderlineDesc(int i)
```
  - getFontOrientationDesc
```
public static String getFontOrientationDesc(int i)
```
  - getFontColorDesc
```
public static String getFontColorDesc(int i)
```
  - getFontAlignmentDesc
```
public static String getFontAlignmentDesc(int i)
```
  - getHeaderFontName
```
public int getHeaderFontName()
```
  - getRowFontName
```
public int getRowFontName()
```
  - getHeaderFontUnderline
```
public int getHeaderFontUnderline()
```
  - getHeaderFontOrientation
```
public int getHeaderFontOrientation()
```
  - getHeaderAlignment
```
public int getHeaderAlignment()
```
  - getHeaderFontColor
```
public int getHeaderFontColor()
```
  - getRowFontColor
```
public int getRowFontColor()
```
  - getHeaderBackGroundColor
```
public int getHeaderBackGroundColor()
```
  - getRowBackGroundColor
```
public int getRowBackGroundColor()
```
  - getFontNameByDesc
```
public static int getFontNameByDesc(String tt)
```
  - getFontUnderlineByDesc
```
public static int getFontUnderlineByDesc(String tt)
```
  - getFontOrientationByDesc
```
public static int getFontOrientationByDesc(String tt)
```
  - getFontColorByDesc
```
public static int getFontColorByDesc(String tt)
```
  - getFontAlignmentByDesc
```
public static int getFontAlignmentByDesc(String tt)
```
  - setHeaderFontName
```
public void setHeaderFontName(int fontname)
```
  - setHeaderFontName
```
public void setHeaderFontName(String fontname)
```
  - setRowFontName
```
public void setRowFontName(int fontname)
```
  - setRowFontName
```
public void setRowFontName(String fontname)
```
  - setHeaderFontUnderline
```
public void setHeaderFontUnderline(int fontunderline)
```
  - setHeaderFontUnderline
```
public void setHeaderFontUnderline(String fontunderline)
```
  - setHeaderFontOrientation
```
public void setHeaderFontOrientation(int fontorientation)
```
  - setHeaderFontOrientation
```
public void setHeaderFontOrientation(String fontorientation)
```
  - setHeaderFontColor
```
public void setHeaderFontColor(int fontcolor)
```
  - setRowFontColor
```
public void setRowFontColor(int fontcolor)
```
  - setHeaderBackGroundColor
```
public void setHeaderBackGroundColor(int fontcolor)
```
  - setRowBackGroundColor
```
public void setRowBackGroundColor(int fontcolor)
```
  - setHeaderAlignment
```
public void setHeaderAlignment(int alignment)
```
  - setHeaderAlignment
```
public void setHeaderAlignment(String alignment)
```
  - setHeaderFontSize
```
public void setHeaderFontSize(String fontsize)
```
  - setRowFontSize
```
public void setRowFontSize(String fontsize)
```
  - getHeaderFontSize
```
public String getHeaderFontSize()
```
  - getRowFontSize
```
public String getRowFontSize()
```
  - setHeaderImage
```
public void setHeaderImage(String image)
```
  - getHeaderImage
```
public String getHeaderImage()
```
  - setHeaderRowHeight
```
public void setHeaderRowHeight(String height)
```
  - getHeaderRowHeight
```
public String getHeaderRowHeight()
```
  - isHeaderFontBold
```
public boolean isHeaderFontBold()
```
  - setHeaderFontItalic
```
public void setHeaderFontItalic(boolean fontitalic)
```
  - isHeaderFontItalic
```
public boolean isHeaderFontItalic()
```
  - setHeaderFontBold
```
public void setHeaderFontBold(boolean font_bold)
```

Class ExcelOutputMeta

Field Summary

Fields inherited from class org.pentaho.di.trans.step.BaseStepMeta

Constructor Summary

Method Summary

Methods inherited from class org.pentaho.di.trans.step.BaseStepMeta

Methods inherited from class java.lang.Object

Methods inherited from interface org.pentaho.di.trans.step.StepMetaInterface

Field Detail

FONT_NAME_ARIAL

FONT_NAME_COURIER

FONT_NAME_TAHOMA

FONT_NAME_TIMES

font_name_code

font_name_desc

FONT_UNDERLINE_NO

FONT_UNDERLINE_SINGLE

FONT_UNDERLINE_SINGLE_ACCOUNTING

FONT_UNDERLINE_DOUBLE

FONT_UNDERLINE_DOUBLE_ACCOUNTING

font_underline_code

font_underline_desc

FONT_ORIENTATION_HORIZONTAL

FONT_ORIENTATION_MINUS_45

FONT_ORIENTATION_MINUS_90

FONT_ORIENTATION_PLUS_45

FONT_ORIENTATION_PLUS_90

FONT_ORIENTATION_STACKED

FONT_ORIENTATION_VERTICAL

font_orientation_code

font_orientation_desc

FONT_COLOR_NONE

FONT_COLOR_BLACK

FONT_COLOR_WHITE

FONT_COLOR_RED

FONT_COLOR_BRIGHT_GREEN

FONT_COLOR_BLUE

FONT_COLOR_YELLOW

FONT_COLOR_PINK

FONT_COLOR_TURQUOISE

FONT_COLOR_DARK_RED

FONT_COLOR_GREEN

FONT_COLOR_DARK_BLUE

FONT_COLOR_DARK_YELLOW

FONT_COLOR_VIOLET

FONT_COLOR_TEAL

FONT_COLOR_GREY_25pct

FONT_COLOR_GREY_50pct

FONT_COLOR_PERIWINKLEpct

FONT_COLOR_PLUM

FONT_COLOR_IVORY

FONT_COLOR_LIGHT_TURQUOISE

FONT_COLOR_DARK_PURPLE

FONT_COLOR_CORAL

FONT_COLOR_OCEAN_BLUE

FONT_COLOR_ICE_BLUE

FONT_COLOR_TURQOISE

FONT_COLOR_SKY_BLUE

FONT_COLOR_LIGHT_GREEN

FONT_COLOR_VERY_LIGHT_YELLOW

FONT_COLOR_PALE_BLUE

FONT_COLOR_ROSE

FONT_COLOR_LAVENDER

FONT_COLOR_TAN

FONT_COLOR_LIGHT_BLUE

FONT_COLOR_AQUA

FONT_COLOR_LIME

FONT_COLOR_GOLD

FONT_COLOR_LIGHT_ORANGE

FONT_COLOR_ORANGE

FONT_COLOR_BLUE_GREY

FONT_COLOR_GREY_40pct

FONT_COLOR_DARK_TEAL

FONT_COLOR_SEA_GREEN

FONT_COLOR_DARK_GREEN

FONT_COLOR_OLIVE_GREEN

FONT_COLOR_BROWN

FONT_COLOR_GREY_80pct

font_color_code

font_color_desc