Spreadsheet File¶

Node: spreadsheetFile · Full type: n8n-nodes-base.spreadsheetFile · Version: 2

Operations¶

Parameter	Type	Default	Details
`binaryPropertyName`	string	"data"	required
`fileFormat`	options	"autodetect"	`autodetect`, `csv`, `html`, `ods`, `rtf`, `xls`, `xlsx`
`options`	collection	{}	keys: `delimiter`, `encoding`, `enableBOM`, `relaxQuotes`, `headerRow`, `includeEmptyCells`, ...

Parameter	Type	Default	Details
`fileFormat`	options	"xls"	`csv`, `html`, `ods`, `rtf`, `xls`, `xlsx`
`binaryPropertyName`	string	"data"	required
`options`	collection	{}	keys: `compression`, `fileName`, `headerRow`, `sheetName`

options children:

Parameter	Type	Default	Details
`delimiter`	string	","
`encoding`	options	"utf-8"	`ascii`, `latin1`, `ucs-2`, `ucs2`, `utf-8`, `utf16le`, `utf8`
`enableBOM`	boolean	false
`relaxQuotes`	boolean	false
`headerRow`	boolean	true
`includeEmptyCells`	boolean	false
`maxRowCount`	number	-1
`range`	string	""
`rawData`	boolean	false
`readAsString`	boolean	false
`sheetName`	string	"Sheet"
`fromLine`	number	0
`skipRecordsWithErrors`	fixedCollection	{...}	groups: `value`

NODE "spreadsheetFile" AS "Spreadsheet File" {
  operation: "fromFile",
  binaryPropertyName: {{ $json.binaryPropertyName }}
}