Codeunit 12416 "Excel Management" (RU)

RU country layer · BC29-30 · source at ea08af5e · facts from BC29

An object of the RU localization, not part of W1.

Procedures

• ReadSheet(SheetName: Text)
• GetCellValue(CellName: Text): Text
• OpenBookForUpdate(FileName: Text)
• SetActiveWriterSheet(SheetName: Text)
• SetActiveWriterSheetById(SheetNo: Integer)
• RenameActiveSheet(NewSheetName: Text)
• CloseBook()
• WriteAllToCurrentSheet()
• DownloadBook(FileName: Text)
• CreateBook()
• OpenSheet(SheetName: Text[30])
• OpenSheetByNumber(SheetNo: Integer)
• FillCell(CellName: Text; CellValueAsText: Text)
• FillCellWithTextFormat(CellName: Text[30]; CellValueAsText: Text[1024])
• FillCellsGroup(Name: Text[30]; Value: Text[30]; Len: Integer; Align: Option Right,Left; EmptyValue: Text[1])
• FillCellsGroup2(ExceCellName: Text[30]; HorizCellsQty: Integer; VertCellsQty: Integer; Value: Text[250]; EmptyCellValue: Text[1]; Align: Option Right,Left)
• FillCellsArea(ExceCellName: Text[30]; HorizCellsQty: Integer; VertCellsQty: Integer; VertCellsDelta: Integer; Value: Text[250]; EmptyCellValue: Text[1]; Align: Option Right,Left)
• ErrorExcelProcessing(ErrorMessage: Text[250])
• CopySheet(Source: Text[30]; Before: Text[30]; NewName: Text[30])
• CopyCellRangeTo(Source: Text[30]; DestStart: Text[30]; DestEnd: Text[30])
• CopyRow(RowNo: Integer)
• CopyRowsTo(FirstRowNo: Integer; LastRowNo: Integer; DestRowNo: Integer)
• DeleteSheet(SheetName: Text[30])
• DeleteRows(FirstRowNo: Integer; LastRowNo: Integer)
• GetSheetsCount(): Integer
• GetSheetName(): Text[30]
• SetSheetName(NewSheetName: Text[30])
• ColumnNo2Name(ColumnNo: Integer): Text[10]
• CellName2RowNo(Str: Code[10]): Integer
• CellName2ColumnName(Str: Code[10]): Code[10]
• GetNextColumn(ColName: Code[10]; Step: Integer): Code[10]
• ColNameToInt(ColName: Code[10]): Integer
• ParseSelectionAddress(Address: Text[30]; var FirstColumnName: Code[10]; var LastColumnName: Code[10]; var FirstRowName: Code[10]; var LastRowName: Code[10])
• ParseCellAddress(Address: Text[30]; var ColumnName: Code[10]; var RowName: Code[10])
• GetNextColumnCellName(CellName: Text[30]): Text[30]
• GetNextRowCellName(CellName: Text[30]): Text[30]
• SetColumnSize(CellName: Text[30]; Size: Integer)
• BoldRow(RowNo: Integer)
• MergeCells(StartingCell: Text[30]; EndingCell: Text[30])
• ClearRow(RowNo: Integer)
• SetCellNumberFormat(CellName: Text[30]; NumberFormat: Text[30])
• IsEmptySymbol(ElementCharecter: Text[1]): Boolean
• BLOBImportSilent(var TempBlob: Codeunit "Temp Blob"; ClientFileName: Text)
• SaveWrkBook(FileName: Text)

Triggers

OnRun

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "codeunit", object_name: "Excel Management"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A RU country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.