Open Data Table Export Dialog

Feature Description

Save data table records as Excel files

Parameter Settings

Configuration Item	Description
Data Table	The data table to export from
File Name	The saved file name
Export Fields	Set the fields to export
Data Range	Set the range of exported data Options: Current page data, All data

Example

In the data table module, we need an export button. Clicking this button can export data table records as an Excel file. Configure an export button in the toolbar of the employee information module shown in the figure below. After clicking, select the fields you want to export in the pop-up box, and then click the export button in the lower right corner of the pop-up box to export the data of the current page as an Excel table.

To configure the above button, you need to add a button in the toolbar of the data table module. Select Export Excel as the execution action for the configuration item. Select the module where data needs to be exported for the Data Table of the configuration item, which is the current table (Employee Information) in this case. The default file name of the exported file is the name of the current module. In this case, the default file name of the exported file is "Employee Information". You can customize the name of the exported file through the File Name in the configuration item. For example, in this case, if you want the exported file name to include the current date, you can achieve this through the configuration shown in the figure below. The exported fields can be configured through the Export Fields configuration item. For example, according to the configuration method shown in the figure below, when exporting through the export button, only the name, employee ID, gender, entry date, and employment status of the employee information can be exported.

The configuration supports restricting the range of exported data. If you want to export all data in the data table, select All Data in the Data Range of the configuration item, so that all data in the data table can be exported through the button. If you want to export specified data, you can select Current Page Data in the Data Range of the configuration item, so that we can filter the data first before filtering, so that the data we want is displayed on the current page, and then click Export to export only the data displayed on the current page. For example, when the employee information is filtered as shown in the figure, the export results of different data ranges are as follows:

When the data range is current page data:

Name	Employee ID	Gender	Entry Date	Employment Status
Zhang San	202211050004	Male	2022-08-29	Employed
Li Si	202211050005	Female	2022-11-01	Employed

When the data range is all data:

Name	Employee ID	Gender	Entry Date	Employment Status
Zhang San	202211050004	Male	2022-08-29	Employed
Li Si	202211050005	Female	2022-11-01	Employed
Wang Wu	202211050006	Male	2022-12-03	Resigned