Activities

• Read Excel File
• Write Excel File

Read Excel File

This activity reads data from an excel file (.xslx) to a collection of collection of strings.

.

Activity Parameters

The ReadExcelFile activity parameters can be provided by manual inserted values or via IN arguments or variables:

Parameters:

• Filename (text box editor type) (type: string): (Optional) Enter the file name without extension from where the values will be read. E.g. "DemoFile"
• FilePath (text box editor type) (type: string): Enter the path of the file without the name of the file. E.g. "C:\Testing"
• Worksheet Name (text box editor type) (type: string): enter the name of the worksheet to be read.

The Read Only Output variable are the possible output values that the activity will provide:

• Output (type: string): Outputs the status of the operation. If you want to display the value of the output parameter use any logging activity that displays string values. E.g. LogTrackData activity.
• Output Collection (type: Collection<Collection<string>>): Outputs a collection of collections of strings containing the found values.