Share via

ExcelDataset interface

  • Reference
Package:
@azure/arm-datafactory

Excel dataset.

Extends
Dataset

Properties

compression

The data compression method used for the json dataset.
firstRowAsHeader

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

The location of the excel storage.
nullValue

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

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

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

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

Polymorphic discriminator, which specifies the different types this object can be

Inherited Properties

annotations

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

Dataset description.
folder

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

Linked service reference.
parameters

Parameters for dataset.
schema

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

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

Property Details

compression

The data compression method used for the json dataset.

compression?: DatasetCompression

Property Value

DatasetCompression

firstRowAsHeader

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

firstRowAsHeader?: any

Property Value

any

location

The location of the excel storage.

location?: DatasetLocationUnion

Property Value

DatasetLocationUnion

nullValue

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

nullValue?: any

Property Value

any

range

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

range?: any

Property Value

any

sheetIndex

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

sheetIndex?: any

Property Value

any

sheetName

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

sheetName?: any

Property Value

any

type

Polymorphic discriminator, which specifies the different types this object can be

type: "Excel"

Property Value

"Excel"

Inherited Property Details

annotations

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

annotations?: any[]

Property Value

any[]

Inherited From Dataset.annotations

description

Dataset description.

description?: string

Property Value

string

Inherited From Dataset.description

folder

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

folder?: DatasetFolder

Property Value

DatasetFolder

Inherited From Dataset.folder

linkedServiceName

Linked service reference.

linkedServiceName: LinkedServiceReference

Property Value

LinkedServiceReference

Inherited From Dataset.linkedServiceName

parameters

Parameters for dataset.

parameters?: {[propertyName: string]: ParameterSpecification}

Property Value

{[propertyName: string]: ParameterSpecification}

Inherited From Dataset.parameters

schema

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

schema?: any

Property Value

any

Inherited From Dataset.schema

structure

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

structure?: any

Property Value

any

Inherited From Dataset.structure