Class ExcelDataset
java.lang.Object
com.azure.resourcemanager.datafactory.models.Dataset
com.azure.resourcemanager.datafactory.models.ExcelDataset
Excel dataset.
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionGet the compression property: The data compression method used for the json dataset.Get the firstRowAsHeader property: When used as input, treat the first row of data as headers.location()
Get the location property: The location of the excel storage.Get the nullValue property: The null value string.range()
Get the range property: The partial data of one sheet.Get the sheetIndex property: The sheet index of excel file and default value is 0.Get the sheetName property: The sheet name of excel file.void
validate()
Validates the instance.withAnnotations
(List<Object> annotations) Set the annotations property: List of tags that can be used for describing the Dataset.withCompression
(DatasetCompression compression) Set the compression property: The data compression method used for the json dataset.withDescription
(String description) Set the description property: Dataset description.withFirstRowAsHeader
(Object firstRowAsHeader) Set the firstRowAsHeader property: When used as input, treat the first row of data as headers.withFolder
(DatasetFolder folder) Set the folder property: The folder that this Dataset is in.withLinkedServiceName
(LinkedServiceReference linkedServiceName) Set the linkedServiceName property: Linked service reference.withLocation
(DatasetLocation location) Set the location property: The location of the excel storage.withNullValue
(Object nullValue) Set the nullValue property: The null value string.withParameters
(Map<String, ParameterSpecification> parameters) Set the parameters property: Parameters for dataset.Set the range property: The partial data of one sheet.withSchema
(Object schema) Set the schema property: Columns that define the physical type schema of the dataset.withSheetIndex
(Object sheetIndex) Set the sheetIndex property: The sheet index of excel file and default value is 0.withSheetName
(Object sheetName) Set the sheetName property: The sheet name of excel file.withStructure
(Object structure) Set the structure property: Columns that define the structure of the dataset.Methods inherited from class com.azure.resourcemanager.datafactory.models.Dataset
additionalProperties, annotations, description, folder, linkedServiceName, parameters, schema, structure, withAdditionalProperties
-
Constructor Details
-
ExcelDataset
public ExcelDataset()Creates an instance of ExcelDataset class.
-
-
Method Details
-
withDescription
Set the description property: Dataset description.- Overrides:
withDescription
in classDataset
- Parameters:
description
- the description value to set.- Returns:
- the Dataset object itself.
-
withStructure
Set the structure property: Columns that define the structure of the dataset. Type: array (or Expression with resultType array), itemType: DatasetDataElement.- Overrides:
withStructure
in classDataset
- Parameters:
structure
- the structure value to set.- Returns:
- the Dataset object itself.
-
withSchema
Set the schema property: Columns that define the physical type schema of the dataset. Type: array (or Expression with resultType array), itemType: DatasetSchemaDataElement.- Overrides:
withSchema
in classDataset
- Parameters:
schema
- the schema value to set.- Returns:
- the Dataset object itself.
-
withLinkedServiceName
Set the linkedServiceName property: Linked service reference.- Overrides:
withLinkedServiceName
in classDataset
- Parameters:
linkedServiceName
- the linkedServiceName value to set.- Returns:
- the Dataset object itself.
-
withParameters
Set the parameters property: Parameters for dataset.- Overrides:
withParameters
in classDataset
- Parameters:
parameters
- the parameters value to set.- Returns:
- the Dataset object itself.
-
withAnnotations
Set the annotations property: List of tags that can be used for describing the Dataset.- Overrides:
withAnnotations
in classDataset
- Parameters:
annotations
- the annotations value to set.- Returns:
- the Dataset object itself.
-
withFolder
Set the folder property: The folder that this Dataset is in. If not specified, Dataset will appear at the root level.- Overrides:
withFolder
in classDataset
- Parameters:
folder
- the folder value to set.- Returns:
- the Dataset object itself.
-
location
Get the location property: The location of the excel storage.- Returns:
- the location value.
-
withLocation
Set the location property: The location of the excel storage.- Parameters:
location
- the location value to set.- Returns:
- the ExcelDataset object itself.
-
sheetName
Get the sheetName property: The sheet name of excel file. Type: string (or Expression with resultType string).- Returns:
- the sheetName value.
-
withSheetName
Set the sheetName property: The sheet name of excel file. Type: string (or Expression with resultType string).- Parameters:
sheetName
- the sheetName value to set.- Returns:
- the ExcelDataset object itself.
-
sheetIndex
Get the sheetIndex property: The sheet index of excel file and default value is 0. Type: integer (or Expression with resultType integer).- Returns:
- the sheetIndex value.
-
withSheetIndex
Set the sheetIndex property: The sheet index of excel file and default value is 0. Type: integer (or Expression with resultType integer).- Parameters:
sheetIndex
- the sheetIndex value to set.- Returns:
- the ExcelDataset object itself.
-
range
Get the range property: The partial data of one sheet. Type: string (or Expression with resultType string).- Returns:
- the range value.
-
withRange
Set the range property: The partial data of one sheet. Type: string (or Expression with resultType string).- Parameters:
range
- the range value to set.- Returns:
- the ExcelDataset object itself.
-
firstRowAsHeader
Get the firstRowAsHeader property: 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).- Returns:
- the firstRowAsHeader value.
-
withFirstRowAsHeader
Set the firstRowAsHeader property: 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).- Parameters:
firstRowAsHeader
- the firstRowAsHeader value to set.- Returns:
- the ExcelDataset object itself.
-
compression
Get the compression property: The data compression method used for the json dataset.- Returns:
- the compression value.
-
withCompression
Set the compression property: The data compression method used for the json dataset.- Parameters:
compression
- the compression value to set.- Returns:
- the ExcelDataset object itself.
-
nullValue
Get the nullValue property: The null value string. Type: string (or Expression with resultType string).- Returns:
- the nullValue value.
-
withNullValue
Set the nullValue property: The null value string. Type: string (or Expression with resultType string).- Parameters:
nullValue
- the nullValue value to set.- Returns:
- the ExcelDataset object itself.
-
validate
public void validate()Validates the instance.- Overrides:
validate
in classDataset
- Throws:
IllegalArgumentException
- thrown if the instance is not valid.
-