$MSExcel allows the user to add data from the Excel spreadsheet to output data set. The parameters are:

1. File Name^*. String, the quotation is not required.
2. Spreadsheet Name. String, the quotation is not required.
3. Column Name. String, the quotation is not required.
4. Use sequentially (optional). Integer, default if 0 that means 'random'. '1' or 'yes' means sequentially.

^* - the following macros can be used as a part of the file name: %APPDATA%, %DOCUMENTS%, %USERPROFILE%, %ALLUSERSPROFILE%

Example

$MSExcel(d:\sales.xls,Contracts,AgentName)

Limitation: the function is available on Windows systems only, not in Java and Web edition.