ExcelDataset Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Excel dataset.
public class ExcelDataset : Azure.ResourceManager.DataFactory.Models.DataFactoryDatasetProperties, System.ClientModel.Primitives.IJsonModel<Azure.ResourceManager.DataFactory.Models.ExcelDataset>, System.ClientModel.Primitives.IPersistableModel<Azure.ResourceManager.DataFactory.Models.ExcelDataset>public class ExcelDataset : Azure.ResourceManager.DataFactory.Models.DataFactoryDatasetPropertiestype ExcelDataset = class
inherit DataFactoryDatasetProperties
interface IJsonModel<ExcelDataset>
interface IPersistableModel<ExcelDataset>type ExcelDataset = class
inherit DataFactoryDatasetPropertiesPublic Class ExcelDataset
Inherits DataFactoryDatasetProperties
Implements IJsonModel(Of ExcelDataset), IPersistableModel(Of ExcelDataset)Public Class ExcelDataset
Inherits DataFactoryDatasetProperties- Inheritance
- Implements
Constructors
| ExcelDataset(DataFactoryLinkedServiceReference) |
Initializes a new instance of ExcelDataset. |
Properties
| AdditionalProperties |
Additional Properties To assign an object to the value of this property use FromObjectAsJson<T>(T, JsonSerializerOptions). To assign an already formatted json string to this property use FromString(String). Examples:
|
| Annotations |
List of tags that can be used for describing the Dataset. To assign an object to the element of this property use FromObjectAsJson<T>(T, JsonSerializerOptions). To assign an already formatted json string to this property use FromString(String). Examples:
|
| Compression |
The data compression method used for the json dataset. |
| DataLocation |
The location of the excel storage. Please note DatasetLocation is the base class. According to the scenario, a derived class of the base class might need to be assigned here, or this property needs to be casted to one of the possible derived classes. The available derived classes include AmazonS3CompatibleLocation, AmazonS3Location, AzureBlobFSLocation, AzureBlobStorageLocation, AzureDataLakeStoreLocation, AzureFileStorageLocation, FileServerLocation, FtpServerLocation, GoogleCloudStorageLocation, HdfsLocation, HttpServerLocation, LakeHouseLocation, OracleCloudStorageLocation and SftpLocation. |
| Description |
Dataset description. (Inherited from DataFactoryDatasetProperties) |
| 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). |
| FolderName |
The name of the folder that this Dataset is in. (Inherited from DataFactoryDatasetProperties) |
| LinkedServiceName |
Linked service reference. (Inherited from DataFactoryDatasetProperties) |
| NullValue |
The null value string. Type: string (or Expression with resultType string). |
| Parameters |
Parameters for dataset. (Inherited from DataFactoryDatasetProperties) |
| Range |
The partial data of one sheet. Type: string (or Expression with resultType string). |
| Schema |
Columns that define the physical type schema of the dataset. Type: array (or Expression with resultType array), itemType: DatasetSchemaDataElement. (Inherited from DataFactoryDatasetProperties) |
| 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). |
| Structure |
Columns that define the structure of the dataset. Type: array (or Expression with resultType array), itemType: DatasetDataElement. (Inherited from DataFactoryDatasetProperties) |
Methods
| JsonModelWriteCore(Utf8JsonWriter, ModelReaderWriterOptions) | |
| JsonModelWriteCore(Utf8JsonWriter, ModelReaderWriterOptions) | (Inherited from DataFactoryDatasetProperties) |
