|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.pentaho.di.trans.step.BaseStepMeta org.pentaho.di.trans.steps.exceloutput.ExcelOutputMeta
public class ExcelOutputMeta
Metadata of the Excel Output step.
Fields inherited from class org.pentaho.di.trans.step.BaseStepMeta |
---|
loggingObject, STEP_ATTRIBUTES_FILE |
Constructor Summary | |
---|---|
ExcelOutputMeta()
|
Method Summary | |
---|---|
void |
allocate(int nrfields)
|
String |
buildFilename(VariableSpace space,
int stepnr,
int splitnr)
|
void |
check(List<CheckResultInterface> remarks,
TransMeta transMeta,
StepMeta stepMeta,
RowMetaInterface prev,
String[] input,
String[] output,
RowMetaInterface info)
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(VariableSpace space,
Map<String,ResourceDefinition> definitions,
ResourceNamingInterface resourceNamingInterface,
Repository repository)
Since the exported transformation that runs this will reside in a ZIP file, we can't reference files relatively. |
String |
getDateTimeFormat()
|
String |
getEncoding()
|
String |
getExtension()
|
void |
getFields(RowMetaInterface r,
String name,
RowMetaInterface[] info,
StepMeta nextStep,
VariableSpace space)
Get the fields that are emitted by this step |
String |
getFileName()
|
String[] |
getFiles(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 |
isAutoSizeColums()
|
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<DatabaseMeta> databases,
Map<String,Counter> counters)
Load the values for this step from an XML Node |
void |
readRep(Repository rep,
ObjectId id_step,
List<DatabaseMeta> databases,
Map<String,Counter> counters)
Read the steps information from a Kettle repository |
void |
saveRep(Repository rep,
ObjectId id_transformation,
ObjectId id_step)
Save the steps data into a Kettle repository |
void |
setAddToResultFiles(boolean addtoresultfilenamesin)
|
void |
setAppend(boolean append)
|
void |
setAutoSizeColums(boolean autosizecolums)
|
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 |
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 |
setHeaderFontOrientation(int fontorientation)
|
void |
setHeaderFontSize(String fontsize)
|
void |
setHeaderFontUnderline(int 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 |
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 java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final int FONT_NAME_ARIAL
public static final int FONT_NAME_COURIER
public static final int FONT_NAME_TAHOMA
public static final int FONT_NAME_TIMES
public static final String[] font_name_code
public static final String[] font_name_desc
public static final int FONT_UNDERLINE_NO
public static final int FONT_UNDERLINE_SINGLE
public static final int FONT_UNDERLINE_SINGLE_ACCOUNTING
public static final int FONT_UNDERLINE_DOUBLE
public static final int FONT_UNDERLINE_DOUBLE_ACCOUNTING
public static final String[] font_underline_code
public static final String[] font_underline_desc
public static final int FONT_ORIENTATION_HORIZONTAL
public static final int FONT_ORIENTATION_MINUS_45
public static final int FONT_ORIENTATION_MINUS_90
public static final int FONT_ORIENTATION_PLUS_45
public static final int FONT_ORIENTATION_PLUS_90
public static final int FONT_ORIENTATION_STACKED
public static final int FONT_ORIENTATION_VERTICAL
public static final String[] font_orientation_code
public static final String[] font_orientation_desc
public static final int FONT_COLOR_NONE
public static final int FONT_COLOR_BLACK
public static final int FONT_COLOR_WHITE
public static final int FONT_COLOR_RED
public static final int FONT_COLOR_BRIGHT_GREEN
public static final int FONT_COLOR_BLUE
public static final int FONT_COLOR_YELLOW
public static final int FONT_COLOR_PINK
public static final int FONT_COLOR_TURQUOISE
public static final int FONT_COLOR_DARK_RED
public static final int FONT_COLOR_GREEN
public static final int FONT_COLOR_DARK_BLUE
public static final int FONT_COLOR_DARK_YELLOW
public static final int FONT_COLOR_VIOLET
public static final int FONT_COLOR_TEAL
public static final int FONT_COLOR_GREY_25pct
public static final int FONT_COLOR_GREY_50pct
public static final int FONT_COLOR_PERIWINKLEpct
public static final int FONT_COLOR_PLUM
public static final int FONT_COLOR_IVORY
public static final int FONT_COLOR_LIGHT_TURQUOISE
public static final int FONT_COLOR_DARK_PURPLE
public static final int FONT_COLOR_CORAL
public static final int FONT_COLOR_OCEAN_BLUE
public static final int FONT_COLOR_ICE_BLUE
public static final int FONT_COLOR_TURQOISE
public static final int FONT_COLOR_SKY_BLUE
public static final int FONT_COLOR_LIGHT_GREEN
public static final int FONT_COLOR_VERY_LIGHT_YELLOW
public static final int FONT_COLOR_PALE_BLUE
public static final int FONT_COLOR_ROSE
public static final int FONT_COLOR_LAVENDER
public static final int FONT_COLOR_TAN
public static final int FONT_COLOR_LIGHT_BLUE
public static final int FONT_COLOR_AQUA
public static final int FONT_COLOR_LIME
public static final int FONT_COLOR_GOLD
public static final int FONT_COLOR_LIGHT_ORANGE
public static final int FONT_COLOR_ORANGE
public static final int FONT_COLOR_BLUE_GREY
public static final int FONT_COLOR_GREY_40pct
public static final int FONT_COLOR_DARK_TEAL
public static final int FONT_COLOR_SEA_GREEN
public static final int FONT_COLOR_DARK_GREEN
public static final int FONT_COLOR_OLIVE_GREEN
public static final int FONT_COLOR_BROWN
public static final int FONT_COLOR_GREY_80pct
public static final String[] font_color_code
public static final String[] font_color_desc
public static final int FONT_ALIGNMENT_LEFT
public static final int FONT_ALIGNMENT_RIGHT
public static final int FONT_ALIGNMENT_CENTER
public static final int FONT_ALIGNMENT_FILL
public static final int FONT_ALIGNMENT_GENERAL
public static final int FONT_ALIGNMENT_JUSTIFY
public static final String[] font_alignment_code
public static final String[] font_alignment_desc
public static final int DEFAULT_FONT_SIZE
public static final int DEFAULT_ROW_HEIGHT
public static final int DEFAULT_ROW_WIDTH
Constructor Detail |
---|
public ExcelOutputMeta()
Method Detail |
---|
public boolean isCreateParentFolder()
public void setCreateParentFolder(boolean createparentfolder)
createparentfolder
- The createparentfolder to set.public boolean isDateInFilename()
public void setDateInFilename(boolean dateInFilename)
dateInFilename
- The dateInFilename to set.public String getExtension()
public void setExtension(String extension)
extension
- The extension to set.public String getFileName()
public String getPassword()
public String getSheetname()
public void setSheetname(String sheetname)
sheetname
- The sheet name.public void setFileName(String fileName)
fileName
- The fileName to set.public void setPassword(String password)
password
- teh passwoed to set.public boolean isFooterEnabled()
public void setFooterEnabled(boolean footer)
footer
- The footer to set.public boolean isAutoSizeColums()
public void setAutoSizeColums(boolean autosizecolums)
autosizecolums
- The autosizecolums to set.public void setTempDirectory(String directory)
public String getTempDirectory()
public boolean isNullBlank()
public void setNullIsBlank(boolean nullIsBlank)
setNullIsBlank
- The boolean indicating whether or not to write null values as blank cellspublic boolean isHeaderEnabled()
public void setHeaderEnabled(boolean header)
header
- The header to set.public boolean isSpecifyFormat()
public void setSpecifyFormat(boolean SpecifyFormat)
public String getDateTimeFormat()
public void setDateTimeFormat(String date_time_format)
public String getNewline()
public void setNewline(String newline)
newline
- The newline to set.public int getSplitEvery()
public boolean isAddToResultFiles()
public void setAddToResultFiles(boolean addtoresultfilenamesin)
addtoresultfilenamesin
- The addtoresultfilenames to set.public void setSplitEvery(int splitEvery)
splitEvery
- The splitEvery to set.public boolean isStepNrInFilename()
public void setStepNrInFilename(boolean stepNrInFilename)
stepNrInFilename
- The stepNrInFilename to set.public boolean isTimeInFilename()
public boolean isSheetProtected()
public void setTimeInFilename(boolean timeInFilename)
timeInFilename
- The timeInFilename to set.public void setProtectSheet(boolean protectsheet)
protectsheet
- the value to set.public boolean isUseTempFiles()
public void setUseTempFiles(boolean usetempfiles)
usetempfiles
- The usetempfiles to set.public ExcelField[] getOutputFields()
public void setOutputFields(ExcelField[] outputFields)
outputFields
- The outputFields to set.public String getEncoding()
public void setEncoding(String encoding)
encoding
- The desired encoding of output file, null or empty if the default system encoding needs to be used.public boolean isTemplateEnabled()
public void setTemplateEnabled(boolean template)
template
- The template to set.public boolean isTemplateAppend()
public void setTemplateAppend(boolean templateAppend)
templateAppend
- The templateAppend to set.public String getTemplateFileName()
public void setTemplateFileName(String templateFileName)
templateFileName
- The templateFileName to set.public boolean isDoNotOpenNewFileInit()
public void setDoNotOpenNewFileInit(boolean doNotOpenNewFileInit)
doNotOpenNewFileInit
- The "do not open new file at init" flag to set.public boolean isAppend()
public void setAppend(boolean append)
append
- The append to set.public void loadXML(Node stepnode, List<DatabaseMeta> databases, Map<String,Counter> counters) throws KettleXMLException
StepMetaInterface
loadXML
in interface StepMetaInterface
stepnode
- the Node to get the info fromdatabases
- The available list of databases to reference tocounters
- Counters to reference.
KettleXMLException
- When an unexpected XML error occurred. (malformed etc.)public void allocate(int nrfields)
public Object clone()
StepMetaInterface
clone
in interface StepMetaInterface
clone
in class BaseStepMeta
public String getNewLine(String fformat)
public void setDefault()
StepMetaInterface
setDefault
in interface StepMetaInterface
public String[] getFiles(VariableSpace space)
public String buildFilename(VariableSpace space, int stepnr, int splitnr)
public void getFields(RowMetaInterface r, String name, RowMetaInterface[] info, StepMeta nextStep, VariableSpace space)
StepMetaInterface
getFields
in interface StepMetaInterface
getFields
in class BaseStepMeta
r
- The fields that are entering the step. These are changed to reflect the output metadata.name
- The name of the step to be used as origininfo
- The input rows metadata that enters the step through the specified channels in the same order as in method getInfoSteps(). The step metadata can then choose what to do with it: ignore it or not.
Interesting is also that in case of database lookups, the layout of the target database table is put in info[0]nextStep
- if this is a non-null value, it's the next step in the transformation. The one who's asking, the step where the data is targetted towards.space
- TODOpublic String getXML()
BaseStepMeta
getXML
in interface StepMetaInterface
getXML
in class BaseStepMeta
public void readRep(Repository rep, ObjectId id_step, List<DatabaseMeta> databases, Map<String,Counter> counters) throws KettleException
StepMetaInterface
readRep
in interface StepMetaInterface
rep
- The repository to read fromid_step
- The step IDdatabases
- The databases to referencecounters
- The counters to reference
KettleException
- When an unexpected error occurred (database, network, etc)public void saveRep(Repository rep, ObjectId id_transformation, ObjectId id_step) throws KettleException
StepMetaInterface
saveRep
in interface StepMetaInterface
rep
- The Kettle repository to save toid_transformation
- The transformation IDid_step
- The step ID
KettleException
- When an unexpected error occurred (database, network, etc)public void check(List<CheckResultInterface> remarks, TransMeta transMeta, StepMeta stepMeta, RowMetaInterface prev, String[] input, String[] output, RowMetaInterface info)
StepMetaInterface
check
in interface StepMetaInterface
remarks
- The list to put the remarks in @see org.pentaho.di.core.CheckResultstepMeta
- The stepMeta to help checkingprev
- The fields coming from the previous stepinput
- The input step namesoutput
- The output step namesinfo
- The fields that are used as information by the steppublic String exportResources(VariableSpace space, Map<String,ResourceDefinition> definitions, ResourceNamingInterface resourceNamingInterface, Repository repository) throws KettleException
exportResources
in interface StepMetaInterface
exportResources
in class BaseStepMeta
space
- the variable space to userepository
- The repository to optionally load other resources from (to be converted to XML)
KettleException
public StepInterface getStep(StepMeta stepMeta, StepDataInterface stepDataInterface, int cnr, TransMeta transMeta, Trans trans)
StepMetaInterface
getStep
in interface StepMetaInterface
stepMeta
- The step infostepDataInterface
- the step data interface linked to this step. Here the step can store temporary data, database connections, etc.cnr
- The copy nr to gettransMeta
- The transformation infotrans
- The launching transformationpublic StepDataInterface getStepData()
StepMetaInterface
getStepData
in interface StepMetaInterface
public String[] getUsedLibraries()
getUsedLibraries
in interface StepMetaInterface
getUsedLibraries
in class BaseStepMeta
public static String getFontNameDesc(int i)
public static String getFontUnderlineDesc(int i)
public static String getFontOrientationDesc(int i)
public static String getFontColorDesc(int i)
public static String getFontAlignmentDesc(int i)
public int getHeaderFontName()
public int getRowFontName()
public int getHeaderFontUnderline()
public int getHeaderFontOrientation()
public int getHeaderAlignment()
public int getHeaderFontColor()
public int getRowFontColor()
public int getHeaderBackGroundColor()
public int getRowBackGroundColor()
public static int getFontNameByDesc(String tt)
public static int getFontUnderlineByDesc(String tt)
public static int getFontOrientationByDesc(String tt)
public static int getFontColorByDesc(String tt)
public static int getFontAlignmentByDesc(String tt)
public void setHeaderFontName(int fontname)
public void setRowFontName(int fontname)
public void setHeaderFontUnderline(int fontunderline)
public void setHeaderFontOrientation(int fontorientation)
public void setHeaderFontColor(int fontcolor)
public void setRowFontColor(int fontcolor)
public void setHeaderBackGroundColor(int fontcolor)
public void setRowBackGroundColor(int fontcolor)
public void setHeaderAlignment(int alignment)
public void setHeaderFontSize(String fontsize)
public void setRowFontSize(String fontsize)
public String getHeaderFontSize()
public String getRowFontSize()
public void setHeaderImage(String image)
public String getHeaderImage()
public void setHeaderRowHeight(String height)
public String getHeaderRowHeight()
public boolean isHeaderFontBold()
public void setHeaderFontItalic(boolean fontitalic)
public boolean isHeaderFontItalic()
public void setHeaderFontBold(boolean font_bold)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |