interface ExcelOptionsProperty

Language	Type name
.NET	Amazon.CDK.AWS.DataBrew.CfnDataset.ExcelOptionsProperty
Java	software.amazon.awscdk.services.databrew.CfnDataset.ExcelOptionsProperty
Python	aws_cdk.aws_databrew.CfnDataset.ExcelOptionsProperty
TypeScript	@aws-cdk/aws-databrew » CfnDataset » 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 * as databrew from '@aws-cdk/aws-databrew';
const excelOptionsProperty: databrew.CfnDataset.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?	IResolvable | number[]	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: IResolvable | number[] (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.