Table 370 Excel Buffer

Base Application, System.IO

61 procedures

ProcedureVersions
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
GetWriterSheetNameByNumber(SheetNo: Integer): Text17-29
CreateNewBook(SheetName: Text[250])17-29
CreateBook(FileName: Text; SheetName: Text)17-29
GetValueByCellName(CellName: Text): Text17-29
GetNextColumnCellName(CellName: Text[30]): Text17-29
GetNextRowCellName(CellName: Text[30]): Text17-29
OpenBook(FileName: Text; SheetName: Text)17-29
OpenBookStream(FileStream: InStream; SheetName: Text): Text17-29
OpenBookForUpdate(FileName: Text)17-29
UpdateBook(FileName: Text; SheetName: Text)17-29
UpdateBookExcel(FileName: Text; SheetName: Text; PreserveDataOnUpdate: Boolean)17-29
UpdateBookStream(var ExcelStream: InStream; SheetName: Text; PreserveDataOnUpdate: Boolean)17-29
CloseBook()17-29
SelectOrAddSheet(NewSheetName: Text)17-29
SetActiveReaderSheet(NewSheetName: Text)17-29
WriteSheet(ReportHeader: Text; CompanyName2: Text; UserID2: Text)17-29
WriteAllToCurrentSheet(var ExcelBuffer: Record "Excel Buffer")17-29
WriteCellValue(ExcelBuffer: Record "Excel Buffer")17-29
WriteCellFormula(ExcelBuffer: Record "Excel Buffer")17-29
SetColumnWidth(ColName: Text[10]; NewColWidth: Decimal)17-29
CreateRangeName(RangeName: Text[30]; FromColumnNo: Integer; FromRowNo: Integer)17-29
ReadSheet()17-29
ReadSheetContinous(SheetName: Text; CloseBookOnCompletion: Boolean)17-29
SelectSheetsName(FileName: Text): Text[250]17-29
SelectSheetsNameStream(FileStream: InStream): Text[250]17-29
GetExcelReference(Which: Integer): Text[250]17-29
ExportBudgetFilterToFormula(var ExcelBuf: Record "Excel Buffer"): Boolean17-29
AddToFormula(Text: Text[30]): Boolean17-29
GetFormula(): Text[1000]17-29
SetFormula(LongFormula: Text[1000])17-29
ClearFormula()17-29
NewRow()17-29
AddColumn(Value: Variant; IsFormula: Boolean; CommentText: Text; IsBold: Boolean; IsItalics: Boolean; IsUnderline: Boolean; NumFormat: Text[30]; CellType: Option)17-29
AddInfoColumn(Value: Variant; IsFormula: Boolean; IsBold: Boolean; IsItalics: Boolean; IsUnderline: Boolean; NumFormat: Text[30]; CellType: Option)17-29
EnterCell(var ExcelBuffer: Record "Excel Buffer"; RowNo: Integer; ColumnNo: Integer; Value: Variant; IsBold: Boolean; IsItalics: Boolean; IsUnderline: Boolean)17-29
StartRange()17-29
EndRange()17-29
CreateRange(RangeName: Text[250])17-29
ClearNewRow()17-29
SetUseInfoSheet()17-29
UTgetGlobalValue(globalVariable: Text[30]; var value: Variant)17-29
SetCurrent(NewCurrentRow: Integer; NewCurrentCol: Integer)17-29
CreateValidationRule(Range: Code[20])17-29
QuitExcel()17-29
OpenExcel()17-29
DownloadAndOpenExcel()17-29
OpenExcelWithName(FileName: Text)17-29
CreateBookAndOpenExcel(FileName: Text; SheetName: Text[250]; ReportHeader: Text; CompanyName2: Text; UserID2: Text)17-29
SetFriendlyFilename(Name: Text)17-29
ConvertDateTimeDecimalToDateTime(DateTimeAsOADate: Decimal): DateTime17-29
SaveToStream(var ResultStream: OutStream; EraseFileAfterCompletion: Boolean)17-29
GetSheetsNameListFromStream(FileStream: InStream; var TempNameValueBufferOut: Record "Name/Value Buffer" temporary): Boolean17-29
protected ParseCellValue(Value: Text; FormatString: Text)new in 20
ReadSheetContinous(SheetName: Text; CloseBookOnCompletion: Boolean; ColumnList: List of [Integer]; RowList: List of [Integer]; MaxRowNo: Integer)new in 21
CreateValidationRule(Range: Code[20]; SheetName: Text[250])new in 24