| SetReadDateTimeInUtcDate(NewValue: Boolean) | 17-29 |
| CopySheet(SheetName: Text; ClonedSheetName: Text; ReferenceSheetName: Text; PasteBefore: Boolean) | 17-29 |
| DeleteWorksheet(SheetName: Text) | 17-29 |
| GetSheetsCount(): Integer | 17-29 |
| EnterCellByCellName(CellName: Text; CellValueAsText: Text[250]) | 17-29 |
| SetActiveWriterSheet(SheetName: Text) | 17-29 |
| GetWriterSheetNameByNumber(SheetNo: Integer): Text | 17-29 |
| CreateNewBook(SheetName: Text[250]) | 17-29 |
| CreateBook(FileName: Text; SheetName: Text) | 17-29 |
| GetValueByCellName(CellName: Text): Text | 17-29 |
| GetNextColumnCellName(CellName: Text[30]): Text | 17-29 |
| GetNextRowCellName(CellName: Text[30]): Text | 17-29 |
| OpenBook(FileName: Text; SheetName: Text) | 17-29 |
| OpenBookStream(FileStream: InStream; SheetName: Text): Text | 17-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"): Boolean | 17-29 |
| AddToFormula(Text: Text[30]): Boolean | 17-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): DateTime | 17-29 |
| SaveToStream(var ResultStream: OutStream; EraseFileAfterCompletion: Boolean) | 17-29 |
| GetSheetsNameListFromStream(FileStream: InStream; var TempNameValueBufferOut: Record "Name/Value Buffer" temporary): Boolean | 17-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 |