1.4.4. Limited Excel Export

Limited Excel Export is an action to download up to 10,000 records of data from a component as an Excel document. This action is only applicable to components configured as Business Objects. The Limited Excel Export Action can be used in services such as load, row-click, row-dbclick, row-touch, row-inline-save, row-inline-delete, and more within the ToolbarList component.

How-To

1. Register the Limited Excel Export Action in the Load Service.
2. Configure the Load Event's Action as a Lambda Action. Set Required to selectData, Optional Type to Data, and the Target to the List Component (only applicable for Business Objects).
3. In the Lambda Action settings for the Limited Excel Export Action, no action parameters need to be registered, only set the Platform Type.
4. Optionally, include a Confirm Message Box to prompt the user for confirmation before proceeding with the Limited Excel Export Action. The Message Box's Key can be arbitrary, while the Parameter Keys should be set to content, title, Yes, and No.

[Image 2. Limited Excel Export: row-click Service Action]

• How-To

1. To use the Limited Excel Export Action when clicking on a List Component's list, register the row-click Service.
2. In the Service triggered by clicking on the list, register the Limited Excel Export Action. Only set the Platform Type; no Action parameters are needed.
3. Optionally, add a Confirm Message Box to prompt the user for confirmation before executing the Limited Excel Export Action. You can set an arbitrary Key for the Message Box, and the Parameter Key should be set to predefined values such as content, title, Yes, and No.

[Image 3. Limited Excel Export: double-click Service Action]

• How-To

1. To enable the Limited Excel Export Action when double-clicking on the List in a List Component, register the row-dbclick Service.
2. In the List Double Click Service, register the Limited Excel Export Action. No Action parameters need to be set, only the Platform Type needs to be registered.
3. Optionally, add a Confirm Message Box to prompt the user for confirmation before executing the Limited Excel Export Action. You can set an arbitrary Key for the Message Box, and the Parameter Key should be set to predefined values such as content, title, Yes, and No.

[Image 4. Limited Excel Export: row-touch Service Action]

• How-To

1. To enable the Limited Excel Export Action when touching the List in a List Component (Touch Event is for mobile only), register the row-touch Service.
2. Register the Limited Excel Export Action in the List Double Click Service. No Action parameters need to be set, only the Platform Type needs to be registered.
3. Optionally, add a Confirm Message Box to prompt the user for confirmation before executing the Limited Excel Export Action. You can set an arbitrary Key for the Message Box, and the Parameter Key should be set to predefined values such as content, title, Yes, and No.

[Image 5. Limited Excel Export: row-inline-save Service Action]

• How-To

1. To use the Limited Excel Export Action when deleting data in inline mode from a List, register the row-Inline-delete Service.
2. Register a deletion Lambda for deleting Row Data when clicking on the List. When deleting, set the Required parameter to deleteData and specify the Component containing the data to be deleted. Unlike saving, when deleting rows, you can select the rows to delete by adding the selectData Action parameter to the deletion Lambda. Specify the Component containing the data to be deleted and the SYS_ID of the data to be deleted, with the Parameter Key set to sysIds.
3. After deleting the data, register the Limited Excel Export Action. No Action parameters need to be set, only the Platform Type needs to be registered.
4. Optionally, add a Confirm Message Box to prompt the user for confirmation before executing the Limited Excel Export Action. You can set an arbitrary Key for the Message Box, and the Parameter Key should be set to predefined values such as content, title, Yes, and No.

[Image 6. Limited Excel Export: row-inline-delete Service Action]

• How-To

1. To use the Limited Excel Export Action when deleting data in inline mode from a List, register the row-Inline-delete Service.
2. Register a deletion Lambda for deleting Row Data when clicking on the List. When deleting, set the Required parameter to deleteData and specify the Component containing the data to be deleted. Unlike saving, when deleting rows, you can select the rows to delete by adding the selectData Action parameter to the deletion Lambda. Specify the Component containing the data to be deleted and the SYS_ID of the data to be deleted, with the Parameter Key set to sysIds.
3. After deleting the data, register the Limited Excel Export Action. No Action parameters need to be set, only the Platform Type needs to be registered.
4. Optionally, add a Confirm Message Box to prompt the user for confirmation before executing the Limited Excel Export Action. You can set an arbitrary Key for the Message Box, and the Parameter Key should be set to predefined values such as content, title, Yes, and No.