It seems that the option “Include Empty Cells” doesnt work for XLSX files and seems to crash n8n, Option works fine for ODS files
Hey @Damian_K!
Were you able to resolve the issue? If not, can you share the workflow you’re trying to execute
Real simple,
Read Binary File → Read Spreadsheet file
The workflow below works for me. Perhaps, cuz the XLSX does not have an empty cell?
{
"nodes": [
{
"parameters": {
"url": "https://file-examples-com.github.io/uploads/2017/02/file_example_XLSX_100.xlsx",
"responseFormat": "file",
"options": {}
},
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 1,
"position": [
600,
290
]
},
{
"parameters": {
"options": {
"includeEmptyCells": true
}
},
"name": "Spreadsheet File",
"type": "n8n-nodes-base.spreadsheetFile",
"typeVersion": 1,
"position": [
850,
290
]
}
],
"connections": {
"HTTP Request": {
"main": [
[
{
"node": "Spreadsheet File",
"type": "main",
"index": 0
}
]
]
}
}
}
Yeah, Sadly enough i cant send the file for testing haha