AWS::DataBrew::Dataset ExcelOptions

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

Syntax

To declare this entity in your AWS CloudFormation template, use the following syntax:

JSON

{
  "HeaderRow" : Boolean,
  "SheetIndexes" : [ Integer, ... ],
  "SheetNames" : [ String, ... ]
}

YAML

  HeaderRow: Boolean
  SheetIndexes: 
    - Integer
  SheetNames: 
    - String

Properties

HeaderRow

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.

Required: No

Type: Boolean

Update requires: No interruption

SheetIndexes

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

Required: No

Type: Array of Integer

Minimum: 1

Maximum: 1

Update requires: No interruption

SheetNames

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

Required: No

Type: Array of String

Minimum: 1

Maximum: 1

Update requires: No interruption