ExcelOptions

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

Data AnalyticsData PreparationETLMachine Learning

Properties

Name Type Description
SheetNames object
SheetIndexes object
HeaderRow object
View JSON Schema on GitHub

JSON Schema

glue-databrew-excel-options-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://raw.githubusercontent.com/api-evangelist/amazon-glue-databrew/refs/heads/main/json-schema/glue-databrew-excel-options-schema.json",
  "title": "ExcelOptions",
  "description": "Represents a set of options that define how DataBrew will interpret a Microsoft Excel file when creating a dataset from that file.",
  "type": "object",
  "properties": {
    "SheetNames": {
      "allOf": [
        {
          "$ref": "#/components/schemas/SheetNameList"
        },
        {
          "description": "One or more named sheets in the Excel file that will be included in the dataset."
        }
      ]
    },
    "SheetIndexes": {
      "allOf": [
        {
          "$ref": "#/components/schemas/SheetIndexList"
        },
        {
          "description": "One or more sheet numbers in the Excel file that will be included in the dataset."
        }
      ]
    },
    "HeaderRow": {
      "allOf": [
        {
          "$ref": "#/components/schemas/HeaderRow"
        },
        {
          "description": "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."
        }
      ]
    }
  }
}