LoadExcelFile

LoadExcelFile

What to use it for

Prerequisites for usage

Essential options to set

Use LoadExcelFile to load an Excel file into memory, to be able to manipulate it using other Activities in the Workflow.

 

 Read more
  • An example follow-up Activity is XlsToCsvTranslation.
  • This Activity uses ExcelPackage, a third party extension to create and manipulate Excel documents.
  • LoadExcelFile creates several variables for later use. Dive into ExcelPackage to learn more (note: They did not document much).
None.
  • Path
  • Excel object

Options

OptionWhat is itHow to use it
Path

 

Path is the path to an Excel file.

Enter an absolute path, using file name and extension. You can use path in two ways:

  • Path to an existing file.
  • Path to where you want to create a new file.
    • Use this option in combination with the next option.

Create new file if file doesn't exist


 

 

A toggle to indicate whether you want a new file to be created in case no file exists on the path that you indicated.
  • Uncheck - No not create a new file.
  • Check - Create a new file.

Excel object


 

Option to save the file contents to a variable, for use later in the Workflow.

Create a variable to save the results to.

 Read more
Why do I need variables

You can use variables to create a more flexible and sustainable Workflow.

Variables are mostly used in advanced Activities such as the Diversity Activities. These Activities often have two parts:

  • One part is to identify where to get data that serves as input for the Activity.
  • One part is to identify where to store data that serves as output for the Activity.

For the Diversity Activities it is common to store the data resulting from the Activity into a variable. Once stored in the variable, you can re-use the stored value elsewhere in the Workflow, by referring to the variable.

To create a variable to store data
  1. Click on the Variables button, below the Workflow. a panel will appear, containing an editable table.
  2. In the table click on 'Create variable' to start creating a new variable.
  3. Provide a name for the variable, preferably a name that describes its contents. Use camel case.
  4. Indicate the type of variable (e.g. boolean, integer, string, etc.). You can find specific types using 'Browse for types...'.
  5. Moving to another row saves this data to a new entry.

You can now use the name of this variable into one of the fields of the current Activity, or in Activities that are next.

Excel Activities