Export List Item Data to an Excel Sheet

AVEVA Work Tasks provides an option to export list item data as an Excel Sheet.

Before we start with this scenario, create an Employee Details list with three list items, Employee ID, Employee Name and Employee Address using TextInput controls.

Populate the Employee Details list with some valid data.

Our objective is to export the data entered to an MS Excel (.xls) format.

To export list item data to an excel sheet

1. In the Enterprise Console, click the Menu button, click Tools, and then click Manage List. The Manage List page appears

2. Click Employee Details. The Employee Details list items are displayed.

3. Click the Export button on the right bottom corner of the Status bar.

4. Select Excel option and click Export now. The File Download window is displayed.

5. Click Save. The Save As window is displayed.

6. Select the appropriate location, type the file name and click Save.