JOP-AL

Objects/Tables/Table 370 Excel Buffer

Table 370 Excel Buffer in 21

, Base Application 21.5.53619.63803, checked

App
Base Application

Fields, 17Keys, 1Procedures, 60Events, 8

Versions171819202122232425262728latest

Source29

Fields, 17

IdNameTypeObsolete
1Row No.Integer-
2xlRowIDText[10]-
3Column No.Integer-
4xlColIDText[10]-
5Cell Value as TextText[250]-
6CommentText[250]-
7FormulaText[250]-
8BoldBoolean-
9ItalicBoolean-
10UnderlineBoolean-
11NumberFormatText[30]-
12Formula2Text[250]-
13Formula3Text[250]-
14Formula4Text[250]-
15Cell TypeOption-
16Double UnderlineBoolean-
17Cell Value as BlobBlob-

Keys, 1

NameFieldsObsolete
Key1, clusteredRow No., Column No.-

Procedures, 60

NameParametersReturnsAccessObsolete
SetReadDateTimeInUtcDate(Boolean)public-
CopySheet(Text, Text, Text, Boolean)public-
DeleteWorksheet(Text)public-
GetSheetsCount()Integerpublic-
EnterCellByCellName(Text, Text[250])public-
SetActiveWriterSheet(Text)public-
GetWriterSheetNameByNumber(Integer)Textpublic-
CreateNewBook(Text[250])public-
CreateBook(Text, Text)public-
GetValueByCellName(Text)Textpublic-
GetNextColumnCellName(Text[30])Textpublic-
GetNextRowCellName(Text[30])Textpublic-
OpenBook(Text, Text)public-
OpenBookStream(InStream, Text)Textpublic-
OpenBookForUpdate(Text)public-
UpdateBook(Text, Text)public-
UpdateBookExcel(Text, Text, Boolean)public-
UpdateBookStream(var InStream, Text, Boolean)public-
CloseBook()public-
SelectOrAddSheet(Text)public-
SetActiveReaderSheet(Text)public-
WriteSheet(Text, Text, Text)public-
WriteAllToCurrentSheet(var Record Excel Buffer)public-
WriteCellValue(Record Excel Buffer)public-
WriteCellFormula(Record Excel Buffer)public-
SetColumnWidth(Text[10], Decimal)public-
CreateRangeName(Text[30], Integer, Integer)public-
ReadSheet()public-
ReadSheetContinous(Text, Boolean)public-
SelectSheetsName(Text)Text[250]public-
SelectSheetsNameStream(InStream)Text[250]public-
GetExcelReference(Integer)Text[250]public-
ExportBudgetFilterToFormula(var Record Excel Buffer)Booleanpublic-
AddToFormula(Text[30])Booleanpublic-
GetFormula()Text[1000]public-
SetFormula(Text[1000])public-
ClearFormula()public-
NewRow()public-
AddColumn(Variant, Boolean, Text, Boolean, Boolean, Boolean, Text[30], Option)public-
AddInfoColumn(Variant, Boolean, Boolean, Boolean, Boolean, Text[30], Option)public-
EnterCell(var Record Excel Buffer, Integer, Integer, Variant, Boolean, Boolean, Boolean)public-
StartRange()public-
EndRange()public-
CreateRange(Text[250])public-
ClearNewRow()public-
SetUseInfoSheet()public-
UTgetGlobalValue(Text[30], var Variant)public-
SetCurrent(Integer, Integer)public-
CreateValidationRule(Code[20])public-
QuitExcel()public-
OpenExcel()public-
DownloadAndOpenExcel()public-
OpenExcelWithName(Text)public-
CreateBookAndOpenExcel(Text, Text[250], Text, Text, Text)public-
SetFriendlyFilename(Text)public-
ConvertDateTimeDecimalToDateTime(Decimal)DateTimepublic-
SaveToStream(var OutStream, Boolean)public-
GetSheetsNameListFromStream(InStream, var Record Name/Value Buffer)Booleanpublic-
ParseCellValue(Text, Text)protected-
ReadSheetContinous(Text, Boolean, List, List, Integer)public-

Events, 8

KindNameParametersObsolete
Integration eventOnAfterAddColumnToBuffer(var Record Excel Buffer, Variant, Boolean, Text, Boolean, Boolean, Boolean, Text[30], Option)-
Integration eventOnBeforeParseCellValue(var Record Excel Buffer, var Text, var Text, var Boolean)-
Integration eventOnWriteCellValueOnBeforeSetCellValue(var Record Excel Buffer, var Text)-
Integration eventOnBeforeWriteCellFormula(var Record Excel Buffer, var Record Excel Buffer, var Boolean)-
Integration eventOnBeforeOpenUsingDocumentService(Text, Text, var Boolean, var Boolean)-
Integration eventOnParseCellValueOnBeforeRoundDecimal(var Record Excel Buffer, Decimal, var Decimal)-
Integration eventOnWriteSheetOnBeforeUseXmlTextWriter(var Record Excel Buffer, var Boolean)-
Integration eventOnWriteSheetOnBeforeAddAndInitializeCommentsPart(var Record Excel Buffer, var Boolean)-