FILE.WRITE

Write a given range as comma separated values to a file. You can use the Function Wizard for this function. The mounted root path is set in the .YML file. E.g.: C:rootfolder:/filefeeder. Add /filefeeder to the "Root Directory" field in the Connector to connect it to the root folder.

Syntax

=FILE.WRITE(Producer, Range, Filename, [Directory], [Mode], [Separator])

Arguments

Name	Description
Producer	File Producer to use for writing the file.
Range	The range to write to a file. Can also be a single value.
Filename	Name of the file that is written.
Directory (optional)	The directory of the file that is written. Defaults to the root directory of the File Producer.
Mode (optional)	Has to be "create" or "append". Defaults to "append". "create" replaces an existing file with the same name, "append" appends instead.
Separator (optional)	Separator to use when writing range to file. Defaults to ",".

Return

TRUE, if no error.

Examples

Formula	Result	Comment
=FILE.WRITE(|File Producer,"Message","file.csv","directory")	TRUE	Write the text “Message” to the file located at “{rootDirectory}/directory/file.csv” using the “File Producer”
=FILE.WRITE(|File Producer, A2:C3,"file.csv",,"create",";")	TRUE	Writes the content of the range A2:C3 to the field located at “{rootDirectory}/file.csv” using “;” as separator and replacing an already existing file with the same name. The resulting content of the file is: Example1;Example2;Example3 Example4;Example5;Example6