Exporting Widgets to Excel

Export data from Table widgets to Excel. Hover over widget, click Export, choose format, and save on your PC.

1: Exporting a Table Widget

The table widget can be exported to Excel in .xls or .csv format.

To export data from the table widget, follow these steps:

1. Hover over the table widget you wish to export to excel.

2. Click the Export icon to the top-right. This will prompt the export dialog box to appear:



3. Choose your preferred file format: either .xls or .csv.

4. Confirm your decision by clicking the Export button.

5. A dialog box for saving files will appear, enabling you to store the file on your computer.

2: Exporting a Data Grid Widget

Note: A feature called Smart Exports means that only the relevant export options (that will succeed) are available. Others will be greyed out. What is available is based on the type of data grid in question.

1. Hover over the data grid widget you wish to export to excel.

2. Click the Export icon to the top-right. This will prompt the export dialog box to appear:

   

3. Choose your preferred file format.

4. Confirm your decision by clicking the Export button.

Option	Best used for	Limitations
.xlsx (Available Rows)	Exporting the full contents of the widget to Excel, for a limited number of rows (see limitations	Large datagrids (over 250 000 cells) will fail to export Datagrids displayed with pagination enabled
.csv	Exporting the full contents of the widget to Excel, for a large number of rows.	.csv is only an option for tables assumed with a large list of rows (hierarchies, list variables used as rows)No formatting is retained in csv format
.xlsx (Current View)	Exporting the current screen view of the widget to Excel i.e. reflecting the expanded or collapsed node states, results filtered by search criteria, results shown in current pagination view	If more data is required than available on the current view, select one of the other export modes available