Spreadsheet

◷ Reading Time: 2 minutes

We can read the spreadsheet files below as a data source. And the spreadsheet can be formatted in any of the types shown below:

1. XLSX
2. XLS
3. CSV

All types of the spreadsheet can be added to your model from the Toolbox on the left-hand side (under the Datasource section). You simply need to select the Spreadsheet icon and then drag and drop it into your model.

The settings below need to be modified depending on the type of spreadsheet:

• Type of spreadsheet: The type of spreadsheet can be changed in the Properties Window (after selecting the Spreadsheet item on the right-hand side, you will see the Properties Window):

• Maps: You need to map your spreadsheet columns to specific Properties and then choose their Type. For example, in the screenshot below we want to map Column A of our Spreadsheet to “CountryName” (in our Excel file) and then choose String for its Type:

You must create a Mapping for all columns (depending on your needs).

• The loaded data from your spreadsheet needs to be assigned to a Return value that you have added as a Parameter. In this example, we assigned the loaded data from an “XLSX” file to “classNames” parameter.