本文整理汇总了Java中org.pentaho.di.trans.steps.exceloutput.ExcelField类的典型用法代码示例。如果您正苦于以下问题:Java ExcelField类的具体用法?Java ExcelField怎么用?Java ExcelField使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
ExcelField类属于org.pentaho.di.trans.steps.exceloutput包,在下文中一共展示了ExcelField类的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的Java代码示例。
示例1: getData
import org.pentaho.di.trans.steps.exceloutput.ExcelField; //导入依赖的package包/类
/**
* Copy information from the meta-data input to the dialog fields.
*/
public void getData()
{
if (input.getFileName() != null) wFilename.setText(input.getFileName());
wDoNotOpenNewFileInit.setSelection(input.isDoNotOpenNewFileInit());
if (input.getExtension() != null) wExtension.setText(input.getExtension());
if (input.getEncoding() !=null) wEncoding.setText(input.getEncoding());
if (input.getTemplateFileName() != null) wTemplateFilename.setText(input.getTemplateFileName());
wSplitEvery.setText(""+input.getSplitEvery());
wAppend.setSelection(input.isAppend());
wHeader.setSelection(input.isHeaderEnabled());
wFooter.setSelection(input.isFooterEnabled());
wAddDate.setSelection(input.isDateInFilename());
wAddTime.setSelection(input.isTimeInFilename());
if (input.getDateTimeFormat()!= null) wDateTimeFormat.setText( input.getDateTimeFormat() );
wSpecifyFormat.setSelection(input.isSpecifyFormat());
wAddToResult.setSelection(input.isAddToResultFiles());
wAutoSize.setSelection(input.isAutoSizeColums());
wAddStepnr.setSelection(input.isStepNrInFilename());
wTemplate.setSelection(input.isTemplateEnabled());
wTemplateAppend.setSelection(input.isTemplateAppend());
if (input.getSheetname() != null)
{
wSheetname.setText(input.getSheetname());
}
else
{
wSheetname.setText("Sheet1");
}
wProtectSheet.setSelection(input.isSheetProtected());
EnablePassword();
EnableTemplate();
if (input.getPassword() != null) wPassword.setText(input.getPassword());
log.logDebug(toString(), "getting fields info...");
for (int i=0;i<input.getOutputFields().length;i++)
{
ExcelField field = input.getOutputFields()[i];
TableItem item = wFields.table.getItem(i);
if (field.getName()!=null) item.setText(1, field.getName());
item.setText(2, field.getTypeDesc());
if (field.getFormat()!=null) item.setText(3, field.getFormat());
}
wFields.optWidth(true);
wStepname.selectAll();
}
开发者ID:icholy,项目名称:geokettle-2.0,代码行数:58,代码来源:ExcelOutputDialog.java
示例2: getInfo
import org.pentaho.di.trans.steps.exceloutput.ExcelField; //导入依赖的package包/类
private void getInfo(ExcelOutputMeta tfoi)
{
tfoi.setFileName( wFilename.getText() );
tfoi.setEncoding( wEncoding.getText() );
tfoi.setDoNotOpenNewFileInit(wDoNotOpenNewFileInit.getSelection() );
tfoi.setExtension( wExtension.getText() );
tfoi.setTemplateFileName( wTemplateFilename.getText() );
tfoi.setSplitEvery( Const.toInt(wSplitEvery.getText(), 0) );
tfoi.setAppend( wAppend.getSelection() );
tfoi.setHeaderEnabled( wHeader.getSelection() );
tfoi.setFooterEnabled( wFooter.getSelection() );
tfoi.setStepNrInFilename( wAddStepnr.getSelection() );
tfoi.setDateInFilename( wAddDate.getSelection() );
tfoi.setTimeInFilename( wAddTime.getSelection() );
tfoi.setDateTimeFormat(wDateTimeFormat.getText());
tfoi.setSpecifyFormat(wSpecifyFormat.getSelection());
tfoi.setAutoSizeColums(wAutoSize.getSelection());
tfoi.setAddToResultFiles( wAddToResult.getSelection() );
tfoi.setProtectSheet( wProtectSheet.getSelection() );
tfoi.setPassword( wPassword.getText() );
tfoi.setTemplateEnabled( wTemplate.getSelection() );
tfoi.setTemplateAppend( wTemplateAppend.getSelection() );
if (wSheetname.getText()!=null)
{
tfoi.setSheetname( wSheetname.getText() );
}
else
{
tfoi.setSheetname( "Sheet 1" );
}
int i;
//Table table = wFields.table;
int nrfields = wFields.nrNonEmpty();
tfoi.allocate(nrfields);
for (i=0;i<nrfields;i++)
{
ExcelField field = new ExcelField();
TableItem item = wFields.getNonEmpty(i);
field.setName( item.getText(1) );
field.setType( item.getText(2) );
field.setFormat( item.getText(3) );
tfoi.getOutputFields()[i] = field;
}
}
开发者ID:icholy,项目名称:geokettle-2.0,代码行数:54,代码来源:ExcelOutputDialog.java
示例3: getData
import org.pentaho.di.trans.steps.exceloutput.ExcelField; //导入依赖的package包/类
/**
* Copy information from the meta-data input to the dialog fields.
*/
public void getData()
{
if (input.getFileName() != null) wFilename.setText(input.getFileName());
wDoNotOpenNewFileInit.setSelection(input.isDoNotOpenNewFileInit());
if (input.getExtension() != null) wExtension.setText(input.getExtension());
if (input.getEncoding() !=null) wEncoding.setText(input.getEncoding());
if (input.getTemplateFileName() != null) wTemplateFilename.setText(input.getTemplateFileName());
wuseTempFiles.setSelection(input.isUseTempFiles());
if (input.getTempDirectory()!= null) wTempDirectory.setText(input.getTempDirectory());
wSplitEvery.setText(""+input.getSplitEvery());
wAppend.setSelection(input.isAppend());
wHeader.setSelection(input.isHeaderEnabled());
wFooter.setSelection(input.isFooterEnabled());
wAddDate.setSelection(input.isDateInFilename());
wAddTime.setSelection(input.isTimeInFilename());
if (input.getDateTimeFormat()!= null) wDateTimeFormat.setText( input.getDateTimeFormat() );
wSpecifyFormat.setSelection(input.isSpecifyFormat());
wCreateParentFolder.setSelection(input.isCreateParentFolder());
wAddToResult.setSelection(input.isAddToResultFiles());
wAutoSize.setSelection(input.isAutoSizeColums());
wNullIsBlank.setSelection(input.isNullBlank());
wAddStepnr.setSelection(input.isStepNrInFilename());
wTemplate.setSelection(input.isTemplateEnabled());
wTemplateAppend.setSelection(input.isTemplateAppend());
if (input.getSheetname() != null)
{
wSheetname.setText(input.getSheetname());
}
else
{
wSheetname.setText("Sheet1");
}
wProtectSheet.setSelection(input.isSheetProtected());
EnablePassword();
EnableTemplate();
if (input.getPassword() != null) wPassword.setText(input.getPassword());
if(isDebug()) logDebug("getting fields info...");
for (int i=0;i<input.getOutputFields().length;i++)
{
ExcelField field = input.getOutputFields()[i];
TableItem item = wFields.table.getItem(i);
if (field.getName()!=null) item.setText(1, field.getName());
item.setText(2, field.getTypeDesc());
if (field.getFormat()!=null) item.setText(3, field.getFormat());
}
wFields.optWidth(true);
// Header Font settings
wHeaderFontName.setText(ExcelOutputMeta.getFontNameDesc(input.getHeaderFontName()));
wHeaderFontSize.setText(input.getHeaderFontSize());
wHeaderFontBold.setSelection(input.isHeaderFontBold());
wHeaderFontItalic.setSelection(input.isHeaderFontItalic());
wHeaderFontUnderline.setText(ExcelOutputMeta.getFontUnderlineDesc(input.getHeaderFontUnderline()));
wHeaderFontOrientation.setText(ExcelOutputMeta.getFontOrientationDesc(input.getHeaderFontOrientation()));
wHeaderFontColor.setText(ExcelOutputMeta.getFontColorDesc(input.getHeaderFontColor()));
wHeaderBackGroundColor.setText(ExcelOutputMeta.getFontColorDesc(input.getHeaderBackGroundColor()));
wHeaderRowHeight.setText(Const.NVL(input.getHeaderRowHeight(),""+ExcelOutputMeta.DEFAULT_ROW_HEIGHT));
wHeaderAlignment.setText(ExcelOutputMeta.getFontAlignmentDesc(input.getHeaderAlignment()));
if(input.getHeaderImage()!=null) wImage.setText(input.getHeaderImage());
// Row font settings
wRowFontName.setText(ExcelOutputMeta.getFontNameDesc(input.getRowFontName()));
wRowFontSize.setText(input.getRowFontSize());
wRowFontColor.setText(ExcelOutputMeta.getFontColorDesc(input.getRowFontColor()));
wRowBackGroundColor.setText(ExcelOutputMeta.getFontColorDesc(input.getRowBackGroundColor()));
wStepname.selectAll();
}
开发者ID:yintaoxue,项目名称:read-open-source-code,代码行数:81,代码来源:ExcelOutputDialog.java
示例4: getInfo
import org.pentaho.di.trans.steps.exceloutput.ExcelField; //导入依赖的package包/类
private void getInfo(ExcelOutputMeta tfoi)
{
tfoi.setFileName( wFilename.getText() );
tfoi.setEncoding( wEncoding.getText() );
tfoi.setDoNotOpenNewFileInit(wDoNotOpenNewFileInit.getSelection() );
tfoi.setExtension( wExtension.getText() );
tfoi.setTemplateFileName( wTemplateFilename.getText() );
tfoi.setSplitEvery( Const.toInt(wSplitEvery.getText(), 0) );
tfoi.setAppend( wAppend.getSelection() );
tfoi.setHeaderEnabled( wHeader.getSelection() );
tfoi.setFooterEnabled( wFooter.getSelection() );
tfoi.setStepNrInFilename( wAddStepnr.getSelection() );
tfoi.setDateInFilename( wAddDate.getSelection() );
tfoi.setTimeInFilename( wAddTime.getSelection() );
tfoi.setUseTempFiles(wuseTempFiles.getSelection());
tfoi.setTempDirectory(wTempDirectory.getText());
tfoi.setDateTimeFormat(wDateTimeFormat.getText());
tfoi.setSpecifyFormat(wSpecifyFormat.getSelection());
tfoi.setAutoSizeColums(wAutoSize.getSelection());
tfoi.setNullIsBlank(wNullIsBlank.getSelection());
tfoi.setAddToResultFiles( wAddToResult.getSelection() );
tfoi.setCreateParentFolder(wCreateParentFolder.getSelection());
tfoi.setProtectSheet( wProtectSheet.getSelection() );
tfoi.setPassword( wPassword.getText() );
tfoi.setTemplateEnabled( wTemplate.getSelection() );
tfoi.setTemplateAppend( wTemplateAppend.getSelection() );
if (wSheetname.getText()!=null)
{
tfoi.setSheetname( wSheetname.getText() );
}
else
{
tfoi.setSheetname( "Sheet 1" );
}
int i;
//Table table = wFields.table;
int nrfields = wFields.nrNonEmpty();
tfoi.allocate(nrfields);
for (i=0;i<nrfields;i++)
{
ExcelField field = new ExcelField();
TableItem item = wFields.getNonEmpty(i);
field.setName( item.getText(1) );
field.setType( item.getText(2) );
field.setFormat( item.getText(3) );
tfoi.getOutputFields()[i] = field;
}
// Header font
tfoi.setHeaderFontName(ExcelOutputMeta.getFontNameByDesc(wHeaderFontName.getText()));
tfoi.setHeaderFontSize(wHeaderFontSize.getText());
tfoi.setHeaderFontBold(wHeaderFontBold.getSelection() );
tfoi.setHeaderFontItalic(wHeaderFontItalic.getSelection() );
tfoi.setHeaderFontUnderline(ExcelOutputMeta.getFontUnderlineByDesc(wHeaderFontUnderline.getText()));
tfoi.setHeaderFontOrientation(ExcelOutputMeta.getFontOrientationByDesc(wHeaderFontOrientation.getText()));
tfoi.setHeaderFontColor(ExcelOutputMeta.getFontColorByDesc(wHeaderFontColor.getText()));
tfoi.setHeaderBackGroundColor(ExcelOutputMeta.getFontColorByDesc(wHeaderBackGroundColor.getText()));
tfoi.setHeaderRowHeight(wHeaderRowHeight.getText());
tfoi.setHeaderAlignment(ExcelOutputMeta.getFontAlignmentByDesc(wHeaderAlignment.getText()));
tfoi.setHeaderImage(wImage.getText());
// Row font
tfoi.setRowFontName(ExcelOutputMeta.getFontNameByDesc(wRowFontName.getText()));
tfoi.setRowFontSize(wRowFontSize.getText());
tfoi.setRowFontColor(ExcelOutputMeta.getFontColorByDesc(wRowFontColor.getText()));
tfoi.setRowBackGroundColor(ExcelOutputMeta.getFontColorByDesc(wRowBackGroundColor.getText()));
}
开发者ID:yintaoxue,项目名称:read-open-source-code,代码行数:74,代码来源:ExcelOutputDialog.java
示例5: getInfo
import org.pentaho.di.trans.steps.exceloutput.ExcelField; //导入依赖的package包/类
private void getInfo( ExcelOutputMeta tfoi ) {
tfoi.setFileName( wFilename.getText() );
tfoi.setEncoding( wEncoding.getText() );
tfoi.setDoNotOpenNewFileInit( wDoNotOpenNewFileInit.getSelection() );
tfoi.setExtension( wExtension.getText() );
tfoi.setTemplateFileName( wTemplateFilename.getText() );
tfoi.setSplitEvery( Const.toInt( wSplitEvery.getText(), 0 ) );
tfoi.setAppend( wAppend.getSelection() );
tfoi.setHeaderEnabled( wHeader.getSelection() );
tfoi.setFooterEnabled( wFooter.getSelection() );
tfoi.setStepNrInFilename( wAddStepnr.getSelection() );
tfoi.setDateInFilename( wAddDate.getSelection() );
tfoi.setTimeInFilename( wAddTime.getSelection() );
tfoi.setUseTempFiles( wuseTempFiles.getSelection() );
tfoi.setTempDirectory( wTempDirectory.getText() );
tfoi.setDateTimeFormat( wDateTimeFormat.getText() );
tfoi.setSpecifyFormat( wSpecifyFormat.getSelection() );
tfoi.setAutoSizeColums( wAutoSize.getSelection() );
tfoi.setNullIsBlank( wNullIsBlank.getSelection() );
tfoi.setAddToResultFiles( wAddToResult.getSelection() );
tfoi.setCreateParentFolder( wCreateParentFolder.getSelection() );
tfoi.setProtectSheet( wProtectSheet.getSelection() );
tfoi.setPassword( wPassword.getText() );
tfoi.setTemplateEnabled( wTemplate.getSelection() );
tfoi.setTemplateAppend( wTemplateAppend.getSelection() );
if ( wSheetname.getText() != null ) {
tfoi.setSheetname( wSheetname.getText() );
} else {
tfoi.setSheetname( "Sheet 1" );
}
int i;
// Table table = wFields.table;
int nrfields = wFields.nrNonEmpty();
tfoi.allocate( nrfields );
for ( i = 0; i < nrfields; i++ ) {
ExcelField field = new ExcelField();
TableItem item = wFields.getNonEmpty( i );
field.setName( item.getText( 1 ) );
field.setType( item.getText( 2 ) );
field.setFormat( item.getText( 3 ) );
//CHECKSTYLE:Indentation:OFF
tfoi.getOutputFields()[i] = field;
}
// Header font
tfoi.setHeaderFontName( ExcelOutputMeta.getFontNameByDesc( wHeaderFontName.getText() ) );
tfoi.setHeaderFontSize( wHeaderFontSize.getText() );
tfoi.setHeaderFontBold( wHeaderFontBold.getSelection() );
tfoi.setHeaderFontItalic( wHeaderFontItalic.getSelection() );
tfoi.setHeaderFontUnderline( ExcelOutputMeta.getFontUnderlineByDesc( wHeaderFontUnderline.getText() ) );
tfoi.setHeaderFontOrientation( ExcelOutputMeta.getFontOrientationByDesc( wHeaderFontOrientation.getText() ) );
tfoi.setHeaderFontColor( ExcelOutputMeta.getFontColorByDesc( wHeaderFontColor.getText() ) );
tfoi.setHeaderBackGroundColor( ExcelOutputMeta.getFontColorByDesc( wHeaderBackGroundColor.getText() ) );
tfoi.setHeaderRowHeight( wHeaderRowHeight.getText() );
tfoi.setHeaderAlignment( ExcelOutputMeta.getFontAlignmentByDesc( wHeaderAlignment.getText() ) );
tfoi.setHeaderImage( wImage.getText() );
// Row font
tfoi.setRowFontName( ExcelOutputMeta.getFontNameByDesc( wRowFontName.getText() ) );
tfoi.setRowFontSize( wRowFontSize.getText() );
tfoi.setRowFontColor( ExcelOutputMeta.getFontColorByDesc( wRowFontColor.getText() ) );
tfoi.setRowBackGroundColor( ExcelOutputMeta.getFontColorByDesc( wRowBackGroundColor.getText() ) );
}
开发者ID:pentaho,项目名称:pentaho-kettle,代码行数:70,代码来源:ExcelOutputDialog.java
注:本文中的org.pentaho.di.trans.steps.exceloutput.ExcelField类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论