AWS::DataBrew::Dataset ExcelOptions - Amazon CloudFormation
SyntaxProperties
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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 Amazon 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