AWS::DataBrew::Dataset ExcelOptions - AWS CloudFormation
SyntaxProperties
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

This is the new CloudFormation Template Reference Guide. Please update your bookmarks and links. For help getting started with CloudFormation, see the AWS CloudFormation User Guide.

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