Codeunit 1488 "Edit in Excel Workbook"
System Application · System.Integration.Excel
Across versions
- BC23-30present
Neighbourhood 2 connected objects and pages
System Application · System.Integration.Excel · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Access | Public |
Procedures
Initialize(ServiceName: Text[250]): Initialize the workbook. This will setup all required information for the add-in.SetFilters(EditInExcelFilters: Codeunit "Edit in Excel Filters"): Sets the filters in the Excel Add-in.SetSearchText(SearchText: Text): Set the search text of the Excel Add-in. This works similar to searching on a page for the specified text.AddColumn(Caption: Text; OdataFieldName: Text): Add the specified OdataField with the given caption to the Excel file.InsertColumn(Index: Integer; Caption: Text; OdataFieldName: Text): Add the specified OdataField with the given caption to the Excel file at the specified location.ImposeExcelOnlineRestrictions(): When the Excel file is opened in Excel online, there are certain restrictions such as a column limit. This will trim additional columns and impose any future restrictions.ExportToStream(): InStream: Generate an Excel file and create an InStream with the content.
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 1489 “Edit in Excel Workbook Impl.” (7 calls:
AddColumn → AddColumn,ExportToStream → ExportToStream,ImposeExcelOnlineRestrictions → ImposeExcelOnlineRestrictions, …)
Called by
- Codeunit 1482 “Edit in Excel Impl.” (6 calls:
GetEndPointAndCreateWorkbookWStructuredFilter → ExportToStream,GetEndPointAndCreateWorkbookWStructuredFilter → Initialize,GetEndPointAndCreateWorkbookWStructuredFilter → SetFilters, …)
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 Workbook"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.