File-handling Functions

Ø  chardetect()

Auto-identify the character set used for a string or a text file

Ø  directory()

List the file name(s) satisfying a wildcard path

Ø  E()

Convert a string, two-layer sequence, table sequence or record sequence to a specific type

Ø  E()

Switch between an Excel date/time value and a numeric value

Ø  f.date()

Return the time and date of a file last modified

Ø  f.exists()

Check if a file exists

Ø  f.export()

Write data of a sequence to a file

Ø  f.name()

Return a file’s path relative to the main directory

Ø  f.import()

Read the contents of a file and return them as a table sequence

Ø  f.property()

Read the property value from the property file

Ø  f.read()

Read contents of a file and return them as strings

Ø  f.size()

Return the length of a file

Ø  f.write()

Write a string or a string sequence into a file

Ø  f.xlsexport()

Write a table sequence/cursor to an Excel file

Ø  f.xlsimport()

Retrieve contents of an Excel file and return them as a table sequence

Ø  f.xlsopen()

Read an Excel file and return an Excel file object

Ø  f.xlswrite()

Save an Excel file object into an Excel file

Ø  file()

Open a file with the specified name

Ø  filename()

Split up a full path to get the file name and extension

Ø  movefile()

Copy, move, delete or rename a file across partitions

Ø  T()

Read in file content according to the file extension and return it as a table sequence

Ø  xo.xlscell()

Enter values to an Excel file object or read values from it

Ø  xo.xlsclose()

Close an Excel file object

Ø  xo.xlsexport()

Write a sequence into an Excel file object

Ø  xo.xlsimport()

Retrieve a table sequence from an Excel file object

Ø  xo.xlsmove()

Move a worksheet in an Excel object