Class ExcelDestination<TInput>

A Excel destination creates an excel files with formatted data. The output will look similar to a csv file.

Inheritance
System.Object
ExcelDestination<TInput>
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: ETLBox.DataFlow.Connectors
Assembly: ETLBox.Excel.dll
Syntax
    public class ExcelDestination<TInput> : DataFlowStreamDestination<TInput>, ILoggableTask, IDataFlowLogging, IDataFlowStreamDestination<TInput>, IDataFlowDestination<TInput>, IDataFlowDestination, IDataFlowComponent, IDataFlowStreamDestination
Type Parameters
NameDescription
TInput

Type of ingoing data

Constructors

ExcelDestination()

Declaration
    public ExcelDestination()

ExcelDestination(String)

Declaration
    public ExcelDestination(string uri)
Parameters
TypeNameDescription
System.Stringuri

The destination csv file name or uri

Properties

ExcelColumns

List of ExcelColumn attributes to map the properties with the right excel column. If you are providing a mapping, all properties that you want to include in the output file need to be specified, and all specified columns require a ColumnIndex. If left empty, the order of the output columns is equal to the order of the properties in the object definition.

Declaration
    public ICollection<ExcelColumn> ExcelColumns { get; set; }
Property Value
TypeDescription
System.Collections.Generic.ICollection<ExcelColumn>

HttpContentType

The content type used when sending the http request content.

Declaration
    public override string HttpContentType { get; set; }
Property Value
TypeDescription
System.String
Overrides
ETLBox.DataFlow.DataFlowStreamDestination<TInput>.HttpContentType

SheetName

The sheet name that contains the data

Declaration
    public string SheetName { get; set; }
Property Value
TypeDescription
System.String

SuppressHeader

If set to true, no header row is written into the output

Declaration
    public bool SuppressHeader { get; set; }
Property Value
TypeDescription
System.Boolean

TaskName

A name to identify the task or component. Every component or task comes with a default name that can be overwritten.

Declaration
    public override string TaskName { get; set; }
Property Value
TypeDescription
System.String
Overrides

Methods

CheckParameter()

Declaration
    protected override void CheckParameter()
Overrides
ETLBox.DataFlow.DataFlowStreamDestination<TInput>.CheckParameter()

CloseStream()

Declaration
    protected override void CloseStream()
Overrides
ETLBox.DataFlow.DataFlowStreamDestination<TInput>.CloseStream()

InitStream()

Declaration
    protected override void InitStream()
Overrides
ETLBox.DataFlow.DataFlowStreamDestination<TInput>.InitStream()

PrepareParameter()

Declaration
    protected override void PrepareParameter()
Overrides
ETLBox.DataFlow.DataFlowStreamDestination<TInput>.PrepareParameter()

WriteIntoStream(TInput)

Declaration
    protected override void WriteIntoStream(TInput data)
Parameters
TypeNameDescription
TInputdata
Overrides
ETLBox.DataFlow.DataFlowStreamDestination<TInput>.WriteIntoStream(TInput)

Implements