---
title: "Table 370 Excel Buffer, extension points 29"
author: "JOP-AL"
url: https://jonas-paprotka.de/ref/table/370-excel-buffer/points/
object: https://jonas-paprotka.de/ref/table/370-excel-buffer/
app: "Base Application"
major: 29
source: https://jonas-paprotka.de/ref/table/370-excel-buffer/source/
checked: 2026-11-20
changed: 2026-10-05
subject: "Microsoft Dynamics 365 Business Central"
license: "Metadata from Microsoft's symbol packages. AL source MIT, Copyright (c) Microsoft Corporation. Selection and wording © 2026 JOP-AL. https://jonas-paprotka.de/licenses/"
---

# Table 370 Excel Buffer, extension points 29

JOP-AL, https://jonas-paprotka.de/ref/table/370-excel-buffer/points/

48 procedures and triggers with a step in src/Layers/W1/BaseApp/System/DataExchange/ExcelBuffer.Table.al, in source order, read from the text, not from a run.

## EnterCellByCellName

[Line 239](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L239).

- [247](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L247) calls `CloseBook`
- [256](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L256) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) Modify
- [259](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L259) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Row No.`
- [260](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L260) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Column No.`
- [262](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L262) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) Insert

## SetActiveWriterSheet

[Line 267](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L267).

- [275](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L275) calls `CloseBook`

## GetWriterSheetNameByNumber

[Line 281](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L281).

- [286](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L286) calls `CloseBook`

## CreateNewBook

[Line 291](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L291).

- [293](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L293) calls `CreateBook`

## CreateBook

[Line 297](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L297).

- [303](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L303) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `ServerTempFileName`
- [310](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L310) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `IsAllowedPath`
- [319](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L319) calls [Codeunit 6223 OpenXML Management](https://jonas-paprotka.de/ref/codeunit/6223-openxml-management/) `SetupWorksheetHelper`

## OpenBook

[Line 354](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L354).

- [365](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L365) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `IsAllowedPath`
- [370](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L370) calls `CloseBook`

## OpenBookStream

[Line 375](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L375).

- [387](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L387) calls `CloseBook`

## OpenBookForUpdate

[Line 394](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L394).

- [397](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L397) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `IsAllowedPath`

## UpdateBook

[Line 402](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L402).

- [404](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L404) calls `UpdateBookExcel`

## UpdateBookExcel

[Line 408](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L408).

- [417](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L417) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `IsAllowedPath`
- [419](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L419) raises `OnUpdateBookExcelOnAfterXlWrkBkWriterOpen`
- [427](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L427) calls [Codeunit 6223 OpenXML Management](https://jonas-paprotka.de/ref/codeunit/6223-openxml-management/) `SetupWorksheetHelper`
- [429](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L429) calls `CloseBook`

## UpdateBookStream

[Line 434](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L434).

- [436](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L436) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `InstreamExportToServerFile`
- [438](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L438) calls `UpdateBookExcel`

## SetActiveReaderSheet

[Line 469](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L469).

- [477](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L477) calls `CloseBook`

## WriteSheet

[Line 482](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L482).

- [496](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L496) calls `GetExcelReference`
- [496](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L496) calls [Codeunit 10 Type Helper](https://jonas-paprotka.de/ref/codeunit/10-type-helper/) `LFSeparator`
- [500](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L500) calls `GetExcelReference`
- [500](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L500) calls `GetExcelReference`
- [500](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L500) calls [Codeunit 10 Type Helper](https://jonas-paprotka.de/ref/codeunit/10-type-helper/) `LFSeparator`
- [503](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L503) raises `OnWriteSheetOnBeforeAddAndInitializeCommentsPart`, IsHandled
- [505](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L505) calls [Codeunit 6223 OpenXML Management](https://jonas-paprotka.de/ref/codeunit/6223-openxml-management/) `AddAndInitializeCommentsPart`
- [510](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L510) calls `WriteAllToCurrentSheet`
- [515](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L515) raises `OnWriteSheetOnBeforeUseXmlTextWriter`, IsHandled
- [525](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L525) calls `SelectOrAddSheet`
- [526](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L526) calls `WriteAllToCurrentSheet`

## WriteAllToCurrentSheet

[Line 530](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L530).

- [539](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L539) calls [Codeunit 5370 Excel Buffer Dialog Management](https://jonas-paprotka.de/ref/codeunit/5370-excel-buffer-dialog-management/) `Open`
- [545](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L545) calls `UpdateProgressDialog`
- [546](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L546) calls `CloseBook`
- [550](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L550) calls `WriteCellValueInternal`
- [552](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L552) calls `WriteCellFormula`
- [554](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L554) calls [Codeunit 5370 Excel Buffer Dialog Management](https://jonas-paprotka.de/ref/codeunit/5370-excel-buffer-dialog-management/) `Close`

## WriteCellValue

[Line 557](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L557).

- [559](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L559) calls `WriteCellValueInternal`

## WriteCellValueInternal

[Line 562](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L562), local.

- [568](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L568) calls `GetCellDecorator`
- [578](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L578) raises `OnWriteCellValueOnBeforeSetCellValue`
- [593](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L593) calls [Codeunit 6223 OpenXML Management](https://jonas-paprotka.de/ref/codeunit/6223-openxml-management/) `SetCellComment`
- [594](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L594) calls [Codeunit 6223 OpenXML Management](https://jonas-paprotka.de/ref/codeunit/6223-openxml-management/) `CreateCommentVmlShapeXml`

## WriteCellFormula

[Line 598](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L598).

- [604](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L604) raises `OnBeforeWriteCellFormula`, IsHandled
- [608](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L608) calls `GetCellDecorator`
- [610](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L610) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `GetFormula`

## CreateRangeName

[Line 679](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L679).

- [687](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L687) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Row No.`
- [688](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L688) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Column No.`
- [692](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L692) calls `GetExcelReference`
- [692](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L692) calls `GetExcelReference`
- [694](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L694) calls `GetExcelReference`
- [694](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L694) calls `GetExcelReference`

## ReadSheet

[Line 697](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L697).

- [699](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L699) calls `ReadSheetContinous`

## ReadSheetContinous

[Line 710](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L710).

- [721](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L721) calls `SetActiveReaderSheet`
- [723](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L723) calls [Codeunit 5370 Excel Buffer Dialog Management](https://jonas-paprotka.de/ref/codeunit/5370-excel-buffer-dialog-management/) `Open`
- [724](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L724) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) DeleteAll
- [731](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L731) calls `ShouldReadCellData`
- [732](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L732) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Row No.`
- [733](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L733) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Column No.`
- [734](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L734) calls `ParseCellValue`
- [735](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L735) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) Insert
- [736](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L736) calls `UpdateProgressDialog`
- [737](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L737) calls `CloseBook`
- [747](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L747) calls `CloseBook`
- [748](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L748) calls [Codeunit 5370 Excel Buffer Dialog Management](https://jonas-paprotka.de/ref/codeunit/5370-excel-buffer-dialog-management/) `Close`

## ParseCellValue

[Line 751](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L751), protected.

- [766](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L766) raises `OnBeforeParseCellValue`, IsHandled
- [790](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L790) calls `ConvertDateTimeDecimalToDateTime`
- [800](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L800) calls `ConvertDateTimeDecimalToDateTime`
- [806](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L806) raises `OnParseCellValueOnBeforeRoundDecimal`

## SelectSheetsName

[Line 811](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L811).

- [819](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L819) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `IsAllowedPath`
- [820](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L820) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `BLOBImportFromServerFile`
- [821](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L821) calls [Codeunit 4100 Temp Blob](https://jonas-paprotka.de/ref/codeunit/4100-temp-blob/) `CreateInStream`
- [822](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L822) calls `SelectSheetsNameStream`

## SelectSheetsNameStream

[Line 825](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L825).

- [830](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L830) calls `GetSheetsNameListFromStream`
- [835](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L835) runs [Page 823 Name/Value Lookup](https://jonas-paprotka.de/ref/page/823-name-value-lookup/)

## ExportBudgetFilterToFormula

[Line 882](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L882).

- [896](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L896) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) Insert
- [913](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L913) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `ClearFormula`
- [925](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L925) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `AddToFormula`
- [928](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L928) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `AddToFormula`
- [931](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L931) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `SetFormula`
- [931](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L931) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `GetExcelReference`
- [937](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L937) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `AddToFormula`
- [940](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L940) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `AddToFormula`
- [943](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L943) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `SetFormula`
- [943](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L943) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `GetExcelReference`
- [948](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L948) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `SetFormula`
- [948](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L948) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `GetFormula`
- [949](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L949) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) Modify

## AddToFormula

[Line 956](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L956).

- [961](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L961) calls `GetFormula`
- [972](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L972) calls `SetFormula`

## SetFormula

[Line 981](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L981).

- [983](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L983) calls `ClearFormula`

## NewRow

[Line 1004](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1004).

- [1006](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1006) calls `SetCurrent`

## AddColumn

[Line 1009](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1009).

- [1011](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1011) calls `AddColumnToBuffer`

## AddInfoColumn

[Line 1014](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1014).

- [1016](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1016) calls `AddColumnToBuffer`

## AddColumnToBuffer

[Line 1019](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1019), local.

- [1022](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1022) calls `NewRow`
- [1026](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1026) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Row No.`
- [1027](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1027) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Column No.`
- [1029](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1029) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `SetFormula`
- [1038](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1038) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) Insert
- [1039](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1039) raises `OnAfterAddColumnToBuffer`

## EnterCell

[Line 1042](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1042).

- [1045](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1045) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Row No.`
- [1046](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1046) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Column No.`
- [1050](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1050) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Cell Type`
- [1052](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1052) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Cell Type`
- [1054](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1054) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Cell Type`
- [1061](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1061) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) Insert(true)

## StartRange

[Line 1064](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1064).

- [1068](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1068) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Row No.`
- [1069](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1069) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Column No.`

## EndRange

[Line 1075](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1075).

- [1079](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1079) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Row No.`
- [1080](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1080) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Column No.`

## CreateRange

[Line 1086](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1086).

- [1090](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1090) calls `GetExcelReference`
- [1090](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1090) calls `GetExcelReference`
- [1092](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1092) calls `GetExcelReference`
- [1092](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1092) calls `GetExcelReference`

## ClearNewRow

[Line 1095](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1095).

- [1097](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1097) calls `SetCurrent`

## UTgetGlobalValue

[Line 1105](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1105).

- [1110](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1110) raises `OnBeforeUTgetGlobalValue`, IsHandled

## CreateValidationRule

[Line 1142](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1142).

- [1146](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1146) calls `GetExcelReference`
- [1146](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1146) calls `GetExcelReference`
- [1148](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1148) calls `GetExcelReference`
- [1148](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1148) calls `GetExcelReference`

## CreateValidationRule

[Line 1151](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1151).

- [1155](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1155) calls `GetExcelReference`
- [1156](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1156) calls `GetExcelReference`
- [1156](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1156) calls `GetExcelReference`
- [1158](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1158) calls `GetExcelReference`
- [1158](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1158) calls `GetExcelReference`

## QuitExcel

[Line 1161](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1161).

- [1163](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1163) calls `CloseBook`

## OpenExcel

[Line 1166](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1166).

- [1168](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1168) calls `OpenUsingDocumentService`
- [1171](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1171) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `DownloadHandler`
- [1171](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1171) calls `GetFriendlyFilename`

## DownloadAndOpenExcel

[Line 1175](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1175).

- [1177](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1177) calls `OpenExcelWithName`
- [1177](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1177) calls `GetFriendlyFilename`

## OpenExcelWithName

[Line 1181](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1181).

- [1186](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1186) calls `OpenUsingDocumentService`
- [1189](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1189) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `DownloadHandler`

## OpenUsingDocumentService

[Line 1192](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1192), local.

- [1202](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1202) raises `OnBeforeOpenUsingDocumentService`, IsHandled
- [1210](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1210) calls [Codeunit 9510 Document Service Management](https://jonas-paprotka.de/ref/codeunit/9510-document-service-management/) `IsConfigured`
- [1215](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1215) calls [Codeunit 9510 Document Service Management](https://jonas-paprotka.de/ref/codeunit/9510-document-service-management/) `IsServiceUri`
- [1218](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1218) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `GetFileName`
- [1222](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1222) calls [Codeunit 9510 Document Service Management](https://jonas-paprotka.de/ref/codeunit/9510-document-service-management/) `SaveFile`
- [1223](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1223) calls [Codeunit 9510 Document Service Management](https://jonas-paprotka.de/ref/codeunit/9510-document-service-management/) `OpenDocument`

## CreateBookAndOpenExcel

[Line 1232](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1232).

- [1234](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1234) calls `CreateBook`
- [1235](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1235) calls `WriteSheet`
- [1236](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1236) calls `CloseBook`
- [1237](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1237) calls `OpenExcel`

## UpdateProgressDialog

[Line 1240](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1240), local.

- [1246](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1246) raises `OnBeforeUpdateProgressDialog`, IsHandled
- [1255](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1255) calls [Codeunit 5370 Excel Buffer Dialog Management](https://jonas-paprotka.de/ref/codeunit/5370-excel-buffer-dialog-management/) `SetProgress`

## GetFriendlyFilename

[Line 1262](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1262), local.

- [1267](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1267) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `StripNotsupportChrInFileName`

## SaveToStream

[Line 1289](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1289).

- [1294](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1294) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `BLOBImportFromServerFile`
- [1295](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1295) calls [Codeunit 4100 Temp Blob](https://jonas-paprotka.de/ref/codeunit/4100-temp-blob/) `CreateInStream`

## GetSheetsNameListFromStream

[Line 1301](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1301).

- [1309](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1309) writes [Table 823 Name/Value Buffer](https://jonas-paprotka.de/ref/table/823-name-value-buffer/) DeleteAll
- [1327](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1327) writes [Table 823 Name/Value Buffer](https://jonas-paprotka.de/ref/table/823-name-value-buffer/) Insert
- [1331](https://jonas-paprotka.de/ref/table/370-excel-buffer/source/#L1331) calls `CloseBook`

## Source

AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at 4303e5e584d3aa5d9e98cbc615525a5396ad6ed7.

JOP-AL, 2026-11-20.
