ExcelDataset interface

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