Apache Drill Storage Plugin for reading Excel files
Usage:
{
"type": "excel",
"enabled": true,
"connection": "file:///C:/data/4drill/lol",
"config": null,
"tables": {
"orders": {
"location": "222.xlsx",
"worksheet": "Sheet1",
"cellRange": "M12:V14",
"floatingRangeFooter": true,
"extractHeaders": true
}
}
}Apache Drill Format Plugin for reading Excel files
Usage:
{
"type": "file",
"enabled": true,
"connection": "file:///",
"config": null,
"workspaces": {
"root": {
"location": "/",
"writable": false,
"defaultInputFormat": null
}
},
"formats": {
"excel": {
"type": "excel",
"extensions": [
"xlsx",
"xls"
],
"extractHeaders": true
}
}
}