Table 370 Excel Buffer

Base Application, System.IO

Source AL, 1,404 lines

src/Layers/W1/BaseApp/System/DataExchange/ExcelBuffer.Table.allines 16 to 31 of 1,404, Copyright (c) Microsoft Corporation. MIT

table 370 "Excel Buffer"{    Caption = 'Excel Buffer';    ReplicateData = false;    DataClassification = CustomerContent;    fields    {        field(1; "Row No."; Integer)        {            Caption = 'Row No.';            DataClassification = SystemMetadata;            trigger OnValidate()            begin                xlRowID := '';

All 1,404 lines

Fields 17 in 29

1Row No.Integer17-29
2xlRowIDText[10]17-29
3Column No.Integer17-29
4xlColIDText[10]17-29
5Cell Value as TextText[250]17-29
6CommentText[250]17-29
7FormulaText[250]17-29
8BoldBoolean17-29
9ItalicBoolean17-29

All 17 fields

Events 11 in 29

[IntegrationEvent] OnAfterAddColumnToBuffer(var ExcelBuffer: Record "Excel Buffer"; Value: Variant; IsFormula: Boolean; CommentText: Text; IsBold: Boolean; IsItalics: Boolean; IsUnderline: Boolean; NumFormat: Text[30]; CellType: Option)17-29
[IntegrationEvent] OnBeforeParseCellValue(var ExcelBuffer: Record "Excel Buffer"; var Value: Text; var FormatString: Text; var IsHandled: Boolean)17-29
[IntegrationEvent] OnWriteCellValueOnBeforeSetCellValue(var ExcelBuffer: Record "Excel Buffer"; var CellTextValue: Text)17-29
[IntegrationEvent] OnBeforeWriteCellFormula(var Rec: Record "Excel Buffer"; var ExcelBuffer: Record "Excel Buffer"; var IsHandled: Boolean)new in 18
[IntegrationEvent] OnBeforeOpenUsingDocumentService(FileNameServer: Text; FileName: Text; var Result: Boolean; var IsHandled: Boolean)new in 19
[IntegrationEvent] OnParseCellValueOnBeforeRoundDecimal(var ExcelBuffer: Record "Excel Buffer"; DecimalValue: Decimal; var RoundingPrecision: Decimal)new in 20
[IntegrationEvent] OnWriteSheetOnBeforeUseXmlTextWriter(var ExcelBuffer: Record "Excel Buffer"; var IsHandled: Boolean)new in 21

All 11 events

Public procedures 60 in 29

SetReadDateTimeInUtcDate(NewValue: Boolean)17-29
CopySheet(SheetName: Text; ClonedSheetName: Text; ReferenceSheetName: Text; PasteBefore: Boolean)17-29
DeleteWorksheet(SheetName: Text)17-29
GetSheetsCount(): Integer17-29
EnterCellByCellName(CellName: Text; CellValueAsText: Text[250])17-29
SetActiveWriterSheet(SheetName: Text)17-29

All 61 procedures in 17-29

Trigger events 10

OnBeforeInsertEvent(var Rec: Record "Excel Buffer"; RunTrigger: Boolean)
OnAfterInsertEvent(var Rec: Record "Excel Buffer"; RunTrigger: Boolean)
OnBeforeModifyEvent(var Rec: Record "Excel Buffer"; var xRec: Record "Excel Buffer"; RunTrigger: Boolean)
OnAfterModifyEvent(var Rec: Record "Excel Buffer"; var xRec: Record "Excel Buffer"; RunTrigger: Boolean)
OnBeforeDeleteEvent(var Rec: Record "Excel Buffer"; RunTrigger: Boolean)
OnAfterDeleteEvent(var Rec: Record "Excel Buffer"; RunTrigger: Boolean)
OnBeforeRenameEvent(var Rec: Record "Excel Buffer"; var xRec: Record "Excel Buffer"; RunTrigger: Boolean)
OnAfterRenameEvent(var Rec: Record "Excel Buffer"; var xRec: Record "Excel Buffer"; RunTrigger: Boolean)
OnBeforeValidateEvent(var Rec: Record "Excel Buffer"; var xRec: Record "Excel Buffer"; CurrFieldNo: Integer)
per field, ElementName: field name
OnAfterValidateEvent(var Rec: Record "Excel Buffer"; var xRec: Record "Excel Buffer"; CurrFieldNo: Integer)
per field, ElementName: field name

Changes 1 in 24

List17181920212223242526272829
Fields1
Procedures111
Events11123
CreateValidationRule(Range: Code[20]; SheetName: Text[250])new in 24
added

All 12 changes in 17-29