Activities
NOTE: In order to use the Excel activities, the Open XML SDK 2.5 package should be installed on the machines where the workflow(s) will be executed from:
- if the workflow will be executed locally, with the Designer, the package should be installed on the machine where the Designer.exe is installed (Note: Designer.exe on the machines where Administrator is also installed)
- if the workflow will be executed via Execution Agents, the package should be installed on the machines where Flowster Execution Agent is deployed.
The SDK installation package can be downloaded from the following location: https://www.microsoft.com/en-us/download/details.aspx?id=30425 .
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.
In order to extract the values from the Output Collection parameter, two For Each and Log Track Data activities should be used:
Execution:
Write Excel File
This activity creates and writes to an excel file (.xslx).
.
Activity Parameters
The WriteExcelFile 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. 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"
- Input Collection (text box editor type) (type: string): Enter the input collection which should be bound to a variable/IN argument of type collection<collection<string>>. In order to create a collection of collections, see example below where three values are added to each row using SessionDetails collection. At the end SessionDetails collection is added to the final ExcelValues collection of collections:
NOTE: collections must be initialized when declaring the variables:
- Overwrite (combobox editor type)(type: string): indicates that the file will be overridden if exists.
- Worksheet Name (text box editor type) (type: string): enter the name of the worksheet to be created.
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.
Execution:
