Class CfnDataset.ExcelOptionsProperty
Represents a set of options that define how DataBrew will interpret a Microsoft Excel file when creating a dataset from that file.
Inheritance
Implements
Namespace: Amazon.CDK.AWS.DataBrew
Assembly: Amazon.CDK.Lib.dll
Syntax (csharp)
public class ExcelOptionsProperty : Object, CfnDataset.IExcelOptionsProperty
Syntax (vb)
Public Class ExcelOptionsProperty
Inherits Object
Implements CfnDataset.IExcelOptionsProperty
Remarks
ExampleMetadata: fixture=_generated
Examples
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
using Amazon.CDK.AWS.DataBrew;
var excelOptionsProperty = new ExcelOptionsProperty {
HeaderRow = false,
SheetIndexes = new [] { 123 },
SheetNames = new [] { "sheetNames" }
};
Synopsis
Constructors
ExcelOptionsProperty() |
Properties
HeaderRow | A variable that specifies whether the first row in the file is parsed as the header. |
SheetIndexes | One or more sheet numbers in the Excel file that will be included in the dataset. |
SheetNames | One or more named sheets in the Excel file that will be included in the dataset. |
Constructors
ExcelOptionsProperty()
public ExcelOptionsProperty()
Properties
HeaderRow
A variable that specifies whether the first row in the file is parsed as the header.
public object HeaderRow { get; set; }
Property Value
System.Object
Remarks
If this value is false, column names are auto-generated.
SheetIndexes
One or more sheet numbers in the Excel file that will be included in the dataset.
public object SheetIndexes { get; set; }
Property Value
System.Object
Remarks
SheetNames
One or more named sheets in the Excel file that will be included in the dataset.
public string[] SheetNames { get; set; }
Property Value
System.String[]