Skip to main content

 

 

 

Template:OutSystems/Documentation_KB/Breadcrumb_New_Layout

 

 

Template:OutSystems/OSLanguageSwitcher

 

 

 

OutSystems

Excel To Record List

Template:OutSystems/Documentation_KB/ContentCollaboration
  • Edit
    Collaborate with us
    Edit this page on GitHub
  • Converts an Excel object to a Record List. Use this logic tool when you need to load data from an Excel file in your app at runtime.

    We've been working on this article. Please let us know how useful this new version is by voting.

    To use Excel To Record List you need an Entity or Structure that matches the Excel file content you want to import. OutSystems matches the attributes of the Entity/Structure specified in the Record Definition property with column headings in the Excel file.

    Check the following example of an Entity named Address and a valid Excel file containing data to import:

    Entity attributes and Excel file with data to import

    Entity attributes without a corresponding column in the Excel file get the default value of their data type (for example, "" for a Text attribute).

    To use the tool, provide the content of the Excel file to import in the File Content property as binary data. To import data from a specific sheet in the Excel file, specify the sheet name in the Sheet Name property. OutSystems imports data from the first sheet, by default.

    To iterate over the successfully imported records, use a For Each and set the Record List property of the For Each to the name of the Excel to Record List element.

    Here's an example flow for handling the data you're importing using Excel to Record List:

    Example flow for importing data from an Excel file

    Excel To Record List doesn't validate if the Excel file data has values for all the mandatory attributes of the Entity. You can use a Server Action (in this example, ValidateAddress) to check if the imported data complies with business rules like mandatory attributes, or handle the exception thrown by the CreateAddress entity action.

    Tip: If you need to import data from an Excel file at design time, when developing your application, check the following topics:

    Availability

    Excel To Record List is only available in Server Actions. In Reactive Web and Mobile apps you must send the uploaded file to the server and then process that file in a Server Action. Check Enable End Users to Upload Files for more information.

    Properties

    Name Description Mandatory Default value Observations
    Name Identifies an element in the scope where it is defined, like a screen, action, or module. Yes
    Description Text that documents the element. Useful for documentation purpose.
    The maximum size of this property is 2000 characters.
    Record Definition Entity or structure that defines the structure of the data that you want to load. Yes
    File Content Holds the Excel file. Yes The expected data type is Binary Data.
    Sheet Name Name of the Excel sheet to import. By default, the first sheet is imported, unless a sheet named 'Sheet1' exists in the file.
    • Was this article helpful?