Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Class: Aws::GlueDataBrew::Types::ExcelOptions

Inherits:
Struct
  • Object
show all
Defined in:
gems/aws-sdk-gluedatabrew/lib/aws-sdk-gluedatabrew/types.rb

Overview

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

Constant Summary collapse

SENSITIVE =
[]

Instance Attribute Summary collapse

Instance Attribute Details

#header_rowBoolean

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.

Returns:

  • (Boolean)

1946
1947
1948
1949
1950
1951
1952
# File 'gems/aws-sdk-gluedatabrew/lib/aws-sdk-gluedatabrew/types.rb', line 1946

class ExcelOptions < Struct.new(
  :sheet_names,
  :sheet_indexes,
  :header_row)
  SENSITIVE = []
  include Aws::Structure
end

#sheet_indexesArray<Integer>

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

Returns:

  • (Array<Integer>)

1946
1947
1948
1949
1950
1951
1952
# File 'gems/aws-sdk-gluedatabrew/lib/aws-sdk-gluedatabrew/types.rb', line 1946

class ExcelOptions < Struct.new(
  :sheet_names,
  :sheet_indexes,
  :header_row)
  SENSITIVE = []
  include Aws::Structure
end

#sheet_namesArray<String>

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

Returns:

  • (Array<String>)

1946
1947
1948
1949
1950
1951
1952
# File 'gems/aws-sdk-gluedatabrew/lib/aws-sdk-gluedatabrew/types.rb', line 1946

class ExcelOptions < Struct.new(
  :sheet_names,
  :sheet_indexes,
  :header_row)
  SENSITIVE = []
  include Aws::Structure
end