Table 370 Excel Buffer

Base Application, System.IO

Fields 17 in 29.0, US

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.0, US

[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.0, US

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

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 none in 29.0, US

List17181920212223242526272829
Fields1
Procedures111
Events11123

All 0 changes in 29.0, US