Skip to main content
OutSystems

How to export entity data to Excel

Question

How can I export the data that has been entered into an entity?

Answer

Use the action Record List To Excel to generate an Excel worksheet that the user can download.

​For example, add a link or button to a typical page showing data in a list. Set the Method to Submit.

export entity data.png

In the screen action:

  1. Add the Record List To Excel widget to the logic;
  2. Select the data to send, in this case the data from the Table Records widget on the page;
  3. Select which attributes to send to Excel.

export entity data2.png

Finally, add a Download widget:

  • Refer to the binary content coming from the Record List To Excel widget;
  • Give the file a good name. If the user will download the file several times, you may want to concatenate the name with CurrDateTime().

export entity data3.png

  • Was this article helpful?