Codeunit 6223 "OpenXML Management"

Base Application · System.Xml · BC23-30 · source at ea08af5e · facts from BC29

Events published

• OnBeforeWriteCellValue(var RowsCount: Integer) (integration)

Procedures

• AddAndInitializeCommentsPart(WorksheetWriter: DotNet WorksheetWriter; var VmlDrawingPart: DotNet VmlDrawingPart)
• AddColumnHeader(WorksheetWriter: DotNet WorksheetWriter; var Table: DotNet Table; ColumnID: Integer; ColumnName: Text; var TableColumn: DotNet TableColumn)
• AddColumnHeaderWithXPath(WorksheetWriter: DotNet WorksheetWriter; var Table: DotNet Table; ColumnID: Integer; ColumnName: Text; Type: Text; XPath: Text)
• AddSingleXMLCellProperties(var SingleXMLCell: DotNet SingleXmlCell; CellReference: Text; XPath: Text; Mapid: Integer; ConnectionId: Integer)
• AddTable(WorksheetWriter: DotNet WorksheetWriter; StartFromRow: Integer; ColumnCount: Integer; RowCount: Integer; var Table: DotNet Table)
• AddWorkSheetAuthor(Comments: DotNet Comments; AuthorText: Text)
• AppendAutoFilter(var Table: DotNet Table)
• AppendTableStyleInfo(var Table: DotNet Table)
• CleanMapInfo(MapInfo: DotNet MapInfo)
• CreateBook(var TempBlob: Codeunit "Temp Blob"; var WrkBkWriter: DotNet WorkbookWriter)
• CreateSchemaConnection(var WrkbkWriter: DotNet WorkbookWriter; SetupDataFileName: Text)
• CreateTableStyles(Workbook: DotNet Workbook)
• CloseBook(var WrkBkWriter: DotNet WorkbookWriter)
• CopyDataToExcelTable(WorksheetWriter: DotNet WorksheetWriter; DataTable: DotNet DataTable): A CopyDataToExcelTable function overload with HideDialog parameter set to true.
• CopyDataToExcelTable(WorksheetWriter: DotNet WorksheetWriter; DataTable: DotNet DataTable; HideDialog: Boolean)
• ExtractXMLSchema(WorkBookPart: DotNet WorkbookPart): Text
• FindTableDefinition(WrkShtReader: DotNet WorksheetReader; var Table: DotNet Table): Boolean
• GetElementName(NameIn: Text): Text
• GetXLColumnID(ColumnNo: Integer): Text[10]
• ImportSchema(var WrkbkWriter: DotNet WorkbookWriter; SchemaFileName: Text; MapId: BigInteger; RootElementName: Text)
• OpenBook(var TempBlob: Codeunit "Temp Blob"; var WrkBkReader: DotNet WorkbookReader)
• SetCellComment(WrkShtWriter: DotNet WorksheetWriter; CellReference: Text; CommentValue: Text)
• SetSingleCellValue(var WrkShtWriter: DotNet WorksheetWriter; var SingleXMLCells: DotNet SingleXmlCells; RowNo: Integer; ColumnNo: Text; Value: Text; XPath: Text)
• SetupWorksheetHelper(WorkbookWriter: DotNet WorkbookWriter)
• WriteCellValue(var WrkShtWriter: DotNet WorksheetWriter; DataColumnDataType: Text; var DataRow: DotNet DataRow; RowsCount: Integer; ColumnsCount: Integer) + BC29
• WriteCellValue(var WrkShtWriter: DotNet WorksheetWriter; DataColumnDataType: Text; var DataRow: DotNet DataRow; RowsCount: Integer; ColumnsCount: Integer; var CellDecorator: DotNet CellDecorator) + BC29
• CreateCommentVmlShapeXml(ColId: Integer; RowId: Integer): Text

Plus 4 local procedures.

Triggers

OnRun

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 419 “File Management” (3 calls: CreateSchemaConnection → GetFileName, ExtractXMLSchema → IsAllowedPath, ExtractXMLSchema → ServerTempFileName)
• Codeunit 4100 “Temp Blob” (2 calls: CreateBook → CreateInStream, OpenBook → CreateInStream)

Called by

• Codeunit 8618 “Config. Excel Exchange” (14 calls: AddAndInitializeTableDefinitionPart → AppendAutoFilter, AddAndInitializeTableDefinitionPart → AppendTableStyleInfo, AddAndInitializeTableDefinitionPart → GetXLColumnID, …)
• Codeunit 8610 “Questionnaire Management” (8 calls: AddColumns → AddColumnHeaderWithXPath, ExportQuestionnaireToExcel → AddTable, ExportQuestionnaireToExcel → CleanMapInfo, …)
• Table 370 “Excel Buffer” (5 calls: CreateBook → SetupWorksheetHelper, UpdateBookExcel → SetupWorksheetHelper, WriteCellValueInternal → CreateCommentVmlShapeXml, …)

Recent changes

• 2026-10-07 #12078 [29.x]Reduce allocations in the “Export to Execl” scenario (#11870) (releases/29.x, BC29, performance)
• 2026-09-28 #11870 Reduce allocations in the “Export to Execl” scenario (main, BC30, performance)

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: "OpenXML Management"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.