Codeunit 1481 "Edit in Excel"

System Application · System.Integration.Excel · BC23-30 · source at ea08af5e · facts from BC29

Properties

Events published

• OnEditInExcelWithStructuredFilter(ServiceName: Text[240]; Filter: JsonObject; Payload: JsonObject; SearchFilter: Text; var Handled: Boolean) (integration): This event is called when Edit in Excel is invoked, handling JSON structured filters. It also allows overriding the Edit in Excel functionality. It is however recommended to use OnEditInExcelWithFilters below if possible to avoid taking dependency on a given structure.
• OnEditInExcelWithFilters(ServiceName: Text[240]; var EditinExcelFilters: Codeunit "Edit in Excel Filters"; SearchFilter: Text; var Handled: Boolean) (integration): This event is called when the Edit in Excel system action is invoked or EditInExcel is called in this codeunit. It allows modifying filters or overriding the Edit in Excel functionality completely.
• OnBeforePageControlFieldFindSet(var PageControlField: Record "Page Control Field"; PageId: Integer) + BC29 (integration): This event is raised before iterating the Page Control Field record set used to build the Edit in Excel workbook column bindings. Subscribers can add further filters or change the sort order to control which page fields are exported to Excel (for example, to honor user personalization).

Procedures

• EditPageInExcel(PageCaption: Text[240]; PageId: Integer) − BC26 − BC26: Creates web service for the specified page, and uses the web service to prepare and download an Excel file for the Edit in Excel functionality.
• EditPageInExcel(PageCaption: Text[240]; PageId: Integer; EditinExcelFilters: Codeunit "Edit in Excel Filters") − BC26 − BC26: Creates web service for the specified page, and uses the web service to prepare and download an Excel file for the Edit in Excel functionality.
• EditPageInExcel(PageCaption: Text[240]; PageId: Integer; EditinExcelFilters: Codeunit "Edit in Excel Filters"; FileName: Text) − BC26 − BC26: Creates web service for the specified page, and uses the web service to prepare and download an Excel file for the Edit in Excel functionality.
• GenerateExcelWorkBook(TenantWebService: Record "Tenant Web Service"; SearchFilter: Text): Prepares an Excel file for the Edit in Excel functionality by using the specified web service, and downloads the file.
• GenerateExcelWorkBook(TenantWebService: Record "Tenant Web Service"; EditinExcelFilters: Codeunit "Edit in Excel Filters"): Prepares an Excel file for the Edit in Excel functionality by using the specified web service, and downloads the file.
• ExternalizeODataObjectName(Name: Text): Text + BC29: Converts a name (e.g. a field name or service name) to its OData externalized form. Mimics the conversion the Edit in Excel runtime applies to field and service names when generating the workbook payload, so that other apps can derive the same external names without duplicating the conversion logic.

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

• Codeunit 1482 “Edit in Excel Impl.” (3 calls: EditPageInExcel → EditPageInExcel, ExternalizeODataObjectName → ExternalizeODataObjectName, GenerateExcelWorkBook → GetEndPointAndCreateWorkbookWStructuredFilter)

Called by

• Codeunit 1482 “Edit in Excel Impl.” (4 calls: EditPageInExcel → OnEditInExcelWithFilters, OnEditInExcelWithStructuredFilterEvent → OnEditInExcelWithFilters, OnEditInExcelWithStructuredFilterEvent → OnEditInExcelWithStructuredFilter, …)
• Codeunit 6710 “ODataUtility” (1 call: EditJournalWorksheetInExcel → EditPageInExcel)
• Page 6713 “OData Fields Export” (1 call: OnQueryClosePage → GenerateExcelWorkBook)

Recent changes

• 2026-07-09 #8051 [Edit in Excel] Expose ExternalizeODataObjectName and add Page Control Field publisher (main, BC30, feature)

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "codeunit", object_name: "Edit in Excel"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.