ExcelDataset Class

Definition

Excel dataset.

[Microsoft.Rest.Serialization.JsonTransformation]
[Newtonsoft.Json.JsonObject("Excel")]
public class ExcelDataset : Microsoft.Azure.Management.DataFactory.Models.Dataset
[<Microsoft.Rest.Serialization.JsonTransformation>]
[<Newtonsoft.Json.JsonObject("Excel")>]
type ExcelDataset = class
    inherit Dataset
Public Class ExcelDataset
Inherits Dataset
Inheritance
ExcelDataset
Attributes
JsonTransformationAttribute Newtonsoft.Json.JsonObjectAttribute

Constructors

ExcelDataset()

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

Properties

AdditionalProperties

Gets or sets unmatched properties from the message are deserialized this collection

(Inherited from Dataset)
Annotations

Gets or sets list of tags that can be used for describing the Dataset.

(Inherited from Dataset)
Compression

Gets or sets the data compression method used for the json dataset.

Description

Gets or sets dataset description.

(Inherited from Dataset)
FirstRowAsHeader

Gets or sets 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).

Folder

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

(Inherited from Dataset)
LinkedServiceName

Gets or sets linked service reference.

(Inherited from Dataset)
Location

Gets or sets the location of the excel storage.

NullValue

Gets or sets the null value string. Type: string (or Expression with resultType string).

Parameters

Gets or sets parameters for dataset.

(Inherited from Dataset)
Range

Gets or sets the partial data of one sheet. Type: string (or Expression with resultType string).

Schema

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

(Inherited from Dataset)
SheetIndex

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

SheetName

Gets or sets the sheet name of excel file. Type: string (or Expression with resultType string).

Structure

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

(Inherited from Dataset)

Methods

Validate()

Validate the object.

Applies to