ExcelDataset Constructors

Definition

Overloads

ExcelDataset()

Initializes a new instance of the ExcelDataset class.

ExcelDataset(LinkedServiceReference, DatasetLocation, Object, IDictionary<String,Object>, String, Object, Object, IDictionary<String, ParameterSpecification>, IList<Object>, DatasetFolder, Object, Object, DatasetCompression, Object)

Initializes a new instance of the ExcelDataset class.

ExcelDataset(LinkedServiceReference, DatasetLocation, IDictionary<String, Object>, String, Object, Object, IDictionary<String,ParameterSpecification>, IList<Object>, DatasetFolder, Object, Object, Object, Object, DatasetCompression, Object)

Initializes a new instance of the ExcelDataset class.

ExcelDataset()

Initializes a new instance of the ExcelDataset class.

public ExcelDataset ();
Public Sub New ()

Applies to

ExcelDataset(LinkedServiceReference, DatasetLocation, Object, IDictionary<String,Object>, String, Object, Object, IDictionary<String, ParameterSpecification>, IList<Object>, DatasetFolder, Object, Object, DatasetCompression, Object)

Initializes a new instance of the ExcelDataset class.

public ExcelDataset (Microsoft.Azure.Management.DataFactory.Models.LinkedServiceReference linkedServiceName, Microsoft.Azure.Management.DataFactory.Models.DatasetLocation location, object sheetName, System.Collections.Generic.IDictionary<string,object> additionalProperties = default, string description = default, object structure = default, object schema = default, System.Collections.Generic.IDictionary<string,Microsoft.Azure.Management.DataFactory.Models.ParameterSpecification> parameters = default, System.Collections.Generic.IList<object> annotations = default, Microsoft.Azure.Management.DataFactory.Models.DatasetFolder folder = default, object range = default, object firstRowAsHeader = default, Microsoft.Azure.Management.DataFactory.Models.DatasetCompression compression = default, object nullValue = default);
new Microsoft.Azure.Management.DataFactory.Models.ExcelDataset : Microsoft.Azure.Management.DataFactory.Models.LinkedServiceReference * Microsoft.Azure.Management.DataFactory.Models.DatasetLocation * obj * System.Collections.Generic.IDictionary<string, obj> * string * obj * obj * System.Collections.Generic.IDictionary<string, Microsoft.Azure.Management.DataFactory.Models.ParameterSpecification> * System.Collections.Generic.IList<obj> * Microsoft.Azure.Management.DataFactory.Models.DatasetFolder * obj * obj * Microsoft.Azure.Management.DataFactory.Models.DatasetCompression * obj -> Microsoft.Azure.Management.DataFactory.Models.ExcelDataset
Public Sub New (linkedServiceName As LinkedServiceReference, location As DatasetLocation, sheetName As Object, Optional additionalProperties As IDictionary(Of String, Object) = Nothing, Optional description As String = Nothing, Optional structure As Object = Nothing, Optional schema As Object = Nothing, Optional parameters As IDictionary(Of String, ParameterSpecification) = Nothing, Optional annotations As IList(Of Object) = Nothing, Optional folder As DatasetFolder = Nothing, Optional range As Object = Nothing, Optional firstRowAsHeader As Object = Nothing, Optional compression As DatasetCompression = Nothing, Optional nullValue As Object = Nothing)

Parameters

linkedServiceName
LinkedServiceReference

Linked service reference.

location
DatasetLocation

The location of the excel storage.

sheetName
Object

The sheet of excel file. Type: string (or Expression with resultType string).

additionalProperties
IDictionary<String,Object>

Unmatched properties from the message are deserialized this collection

description
String

Dataset description.

structure
Object

Columns that define the structure of the dataset. Type: array (or Expression with resultType array), itemType: DatasetDataElement.

schema
Object

Columns that define the physical type schema of the dataset. Type: array (or Expression with resultType array), itemType: DatasetSchemaDataElement.

parameters
IDictionary<String,ParameterSpecification>

Parameters for dataset.

annotations
IList<Object>

List of tags that can be used for describing the Dataset.

folder
DatasetFolder

The folder that this Dataset is in. If not specified, Dataset will appear at the root level.

range
Object

The partial data of one sheet. Type: string (or Expression with resultType string).

firstRowAsHeader
Object

When used as input, treat the first row of data as headers. When used as output,write the headers into the output as the first row of data. The default value is false. Type: boolean (or Expression with resultType boolean).

compression
DatasetCompression

The data compression method used for the json dataset.

nullValue
Object

The null value string. Type: string (or Expression with resultType string).

Applies to

ExcelDataset(LinkedServiceReference, DatasetLocation, IDictionary<String, Object>, String, Object, Object, IDictionary<String,ParameterSpecification>, IList<Object>, DatasetFolder, Object, Object, Object, Object, DatasetCompression, Object)

Initializes a new instance of the ExcelDataset class.

public ExcelDataset (Microsoft.Azure.Management.DataFactory.Models.LinkedServiceReference linkedServiceName, Microsoft.Azure.Management.DataFactory.Models.DatasetLocation location, System.Collections.Generic.IDictionary<string,object> additionalProperties = default, string description = default, object structure = default, object schema = default, System.Collections.Generic.IDictionary<string,Microsoft.Azure.Management.DataFactory.Models.ParameterSpecification> parameters = default, System.Collections.Generic.IList<object> annotations = default, Microsoft.Azure.Management.DataFactory.Models.DatasetFolder folder = default, object sheetName = default, object sheetIndex = default, object range = default, object firstRowAsHeader = default, Microsoft.Azure.Management.DataFactory.Models.DatasetCompression compression = default, object nullValue = default);
new Microsoft.Azure.Management.DataFactory.Models.ExcelDataset : Microsoft.Azure.Management.DataFactory.Models.LinkedServiceReference * Microsoft.Azure.Management.DataFactory.Models.DatasetLocation * System.Collections.Generic.IDictionary<string, obj> * string * obj * obj * System.Collections.Generic.IDictionary<string, Microsoft.Azure.Management.DataFactory.Models.ParameterSpecification> * System.Collections.Generic.IList<obj> * Microsoft.Azure.Management.DataFactory.Models.DatasetFolder * obj * obj * obj * obj * Microsoft.Azure.Management.DataFactory.Models.DatasetCompression * obj -> Microsoft.Azure.Management.DataFactory.Models.ExcelDataset
Public Sub New (linkedServiceName As LinkedServiceReference, location As DatasetLocation, Optional additionalProperties As IDictionary(Of String, Object) = Nothing, Optional description As String = Nothing, Optional structure As Object = Nothing, Optional schema As Object = Nothing, Optional parameters As IDictionary(Of String, ParameterSpecification) = Nothing, Optional annotations As IList(Of Object) = Nothing, Optional folder As DatasetFolder = Nothing, Optional sheetName As Object = Nothing, Optional sheetIndex As Object = Nothing, Optional range As Object = Nothing, Optional firstRowAsHeader As Object = Nothing, Optional compression As DatasetCompression = Nothing, Optional nullValue As Object = Nothing)

Parameters

linkedServiceName
LinkedServiceReference

Linked service reference.

location
DatasetLocation

The location of the excel storage.

additionalProperties
IDictionary<String,Object>

Unmatched properties from the message are deserialized this collection

description
String

Dataset description.

structure
Object

Columns that define the structure of the dataset. Type: array (or Expression with resultType array), itemType: DatasetDataElement.

schema
Object

Columns that define the physical type schema of the dataset. Type: array (or Expression with resultType array), itemType: DatasetSchemaDataElement.

parameters
IDictionary<String,ParameterSpecification>

Parameters for dataset.

annotations
IList<Object>

List of tags that can be used for describing the Dataset.

folder
DatasetFolder

The folder that this Dataset is in. If not specified, Dataset will appear at the root level.

sheetName
Object

The sheet name of excel file. Type: string (or Expression with resultType string).

sheetIndex
Object

The sheet index of excel file and default value is 0. Type: integer (or Expression with resultType integer)

range
Object

The partial data of one sheet. Type: string (or Expression with resultType string).

firstRowAsHeader
Object

When used as input, treat the first row of data as headers. When used as output,write the headers into the output as the first row of data. The default value is false. Type: boolean (or Expression with resultType boolean).

compression
DatasetCompression

The data compression method used for the json dataset.

nullValue
Object

The null value string. Type: string (or Expression with resultType string).

Applies to