Class ExcelDatasetTypeProperties
java.lang.Object
com.azure.resourcemanager.datafactory.fluent.models.ExcelDatasetTypeProperties
Excel dataset properties.
-
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.withCompression
(DatasetCompression compression) Set the compression property: The data compression method used for the json dataset.withFirstRowAsHeader
(Object firstRowAsHeader) Set the firstRowAsHeader property: When used as input, treat the first row of data as headers.withLocation
(DatasetLocation location) Set the location property: The location of the excel storage.withNullValue
(Object nullValue) Set the nullValue property: The null value string.Set the range property: The partial data of one sheet.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.
-
Constructor Details
-
ExcelDatasetTypeProperties
public ExcelDatasetTypeProperties()
-
-
Method Details
-
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 ExcelDatasetTypeProperties 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 ExcelDatasetTypeProperties 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 ExcelDatasetTypeProperties 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 ExcelDatasetTypeProperties 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 ExcelDatasetTypeProperties 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 ExcelDatasetTypeProperties 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 ExcelDatasetTypeProperties object itself.
-
validate
public void validate()Validates the instance.- Throws:
IllegalArgumentException
- thrown if the instance is not valid.
-