ExcelDataset Constructors

Definition

Namespace:

Microsoft.Azure.Management.DataFactory.Models

Assembly:

Microsoft.Azure.Management.DataFactory.dll

Package:

Microsoft.Azure.Management.DataFactory v8.0.0

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 ()

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).

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).