Represents a set of options that define how DataBrew will interpret a Microsoft Excel file when creating a dataset from that file.
Type: objectProperties: 3
Data AnalyticsData PreparationETLMachine-Learning
ExcelOptions is a JSON Structure definition published by Amazon Glue DataBrew, describing 3 properties. It conforms to the https://json-structure.org/meta/core/v0/# meta-schema.
{
"$schema": "https://json-structure.org/meta/core/v0/#",
"$id": "https://raw.githubusercontent.com/api-evangelist/amazon-glue-databrew/refs/heads/main/json-structure/glue-databrew-excel-options-structure.json",
"name": "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."
}
]
}
}
}
Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we
store it to create your key and to recognise you if you sign in with another
provider. See our Privacy Policy and
Terms.