Class ExcelDestination<TInput>
A Excel destination creates an excel files with formatted data. The output will look similar to a csv file.
Inherited Members
Namespace: ETLBox.Excel
Assembly: ETLBox.Excel.dll
Syntax
{{< /rawhtml >}} ```C# public class ExcelDestinationType Parameters
| Name | Description |
|---|---|
| TInput | Type of ingoing data |
Constructors
ExcelDestination()
Declaration
{{< /rawhtml >}} ```C# public ExcelDestination() ``` {{< rawhtml >}}ExcelDestination(string)
Declaration
{{< /rawhtml >}} ```C# public ExcelDestination(string uri) ``` {{< rawhtml >}}Parameters
| Type | Name | Description |
|---|---|---|
| string | uri | The destination excel file name or uri |
ExcelDestination(string, ResourceType)
Declaration
{{< /rawhtml >}} ```C# public ExcelDestination(string uri, ResourceType resourceType) ``` {{< rawhtml >}}Parameters
| Type | Name | Description |
|---|---|---|
| string | uri | The destination excel file name or uri |
| ResourceType | resourceType | Specifies if data is loaded from a file, a web endpoint or other storage types (e.g. Azure Blob Storage) |
Properties
AppendToFile
By default, a new excel file is created. Set this property to true to append data to an existing file. New data will be appended after the last row on the selected sheet (identified by SheetName).
Declaration
{{< /rawhtml >}} ```C# public bool AppendToFile { get; set; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| bool |
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
{{< /rawhtml >}} ```C# public ICollectionProperty Value
| Type | Description |
|---|---|
| ICollection<ExcelColumn> |
HttpContentType
The content type used when sending the http request content.
Declaration
{{< /rawhtml >}} ```C# public override string HttpContentType { get; set; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| string |
Overrides
SheetName
The sheet name that will hold the data
Declaration
{{< /rawhtml >}} ```C# public string SheetName { get; set; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| string |
SuppressHeader
If set to true, no header row is written into the output
Declaration
{{< /rawhtml >}} ```C# public bool SuppressHeader { get; set; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| bool |
Methods
CheckParameter()
Declaration
{{< /rawhtml >}} ```C# protected override void CheckParameter() ``` {{< rawhtml >}}Overrides
CloseStream()
Declaration
{{< /rawhtml >}} ```C# protected override void CloseStream() ``` {{< rawhtml >}}Overrides
InitStream()
Declaration
{{< /rawhtml >}} ```C# protected override void InitStream() ``` {{< rawhtml >}}Overrides
PrepareParameterForCheck()
Declaration
{{< /rawhtml >}} ```C# protected override void PrepareParameterForCheck() ``` {{< rawhtml >}}Overrides
Reset()
Declaration
{{< /rawhtml >}} ```C# protected override void Reset() ``` {{< rawhtml >}}Overrides
WriteIntoStream(TInput)
Declaration
{{< /rawhtml >}} ```C# protected override void WriteIntoStream(TInput data) ``` {{< rawhtml >}}Parameters
| Type | Name | Description |
|---|---|---|
| TInput | data |