Filesystem

CurrentDirectory

Returns the directory that the currently only spreadsheet is saved.

Useful for creating relative filepaths for spreadsheets that output reports, allowing them to be easily shared with colleagues.

=ArupCompute.FileSystem.CurrentDirectory()

No input arguments

tip

This function will only work when the Excel document has been saved.

ReadFile

Reads the contents of a file on disk.

ArupCompute.FileSystem.ReadFile(...

Argument	Type	Description
path	text	Filepath (including extension) of the file to be read

WriteFile

Writes text content to a file on disk.

ArupCompute.FileSystem.WriteFile(...

Argument	Type	Description
path	text	Filepath (including extension) of the file to be written
contents	text	Data to be written into the file