Enum "Excel Sheet Configuration"
Defines Excel sheet configuration options for report layout generation and data organization. Controls how report data is structured and distributed across Excel worksheets.
Remarks
Used in report layout definitions to control Excel export formatting and sheet organization. Supports fallback to default AL report metadata when undefined values are specified. Essential for flexible Excel report generation and data presentation control.
Properties
| Name | Value |
|---|---|
| Extensible | True |
| Caption | Excel Sheet Configuration |
| Scope | Cloud |
Values
| Name | Description |
|---|---|
| Default |
Uses default sheet configuration as defined in AL report metadata. |
| "Single Data sheet" |
Generates a single Excel worksheet containing data from all report data items. |
| "Multiple data sheets" |
Generates separate Excel worksheets for each report data item. |