interface ExcelOptionsProperty

Language	Type name
.NET	`Amazon.CDK.Mixins.Preview.AWS.DataBrew.Mixins.CfnDatasetPropsMixin.ExcelOptionsProperty`
Go	`github.com/aws/aws-cdk-go/awscdkmixinspreview/v2/awsdatabrew/mixins#CfnDatasetPropsMixin_ExcelOptionsProperty`
Java	`software.amazon.awscdk.mixins.preview.services.databrew.mixins.CfnDatasetPropsMixin.ExcelOptionsProperty`
Python	`aws_cdk.mixins_preview.aws_databrew.mixins.CfnDatasetPropsMixin.ExcelOptionsProperty`
TypeScript	`@aws-cdk/mixins-preview` » `aws_databrew` » `mixins` » `CfnDatasetPropsMixin` » `ExcelOptionsProperty`

Represents a set of options that define how DataBrew will interpret a Microsoft Excel file when creating a dataset from that file.

Example

// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import { mixins as databrew_mixins } from '@aws-cdk/mixins-preview/aws-databrew';
const excelOptionsProperty: databrew_mixins.CfnDatasetPropsMixin.ExcelOptionsProperty = {
  headerRow: false,
  sheetIndexes: [123],
  sheetNames: ['sheetNames'],
};

Properties

Name	Type	Description
headerRow?	`boolean \|` `IResolvable`	A variable that specifies whether the first row in the file is parsed as the header.
sheetIndexes?	`number[] \|` `IResolvable`	One or more sheet numbers in the Excel file that will be included in the dataset.
sheetNames?	`string[]`	One or more named sheets in the Excel file that will be included in the dataset.

headerRow?

Type: boolean | IResolvable (optional)

A variable that specifies whether the first row in the file is parsed as the header.

If this value is false, column names are auto-generated.

sheetIndexes?

Type: number[] | IResolvable (optional)

One or more sheet numbers in the Excel file that will be included in the dataset.

sheetNames?

Type: string[] (optional)

One or more named sheets in the Excel file that will be included in the dataset.

AWS CDK