Codeunit "Config. Excel Exchange"

ID 8618
Namespace: System.IO

Methods

ExportExcelFromConfig

procedure ExportExcelFromConfig(var ConfigLine: Record "Config. Line"): Text

Parameters

Name Type Description
ConfigLine Table System.IO."Config. Line"

Returns

Type Description
Text

ExportExcelFromPackage

procedure ExportExcelFromPackage(ConfigPackage: Record "Config. Package"): Boolean

Parameters

Name Type Description
ConfigPackage Table System.IO."Config. Package"

Returns

Type Description
Boolean

ExportExcelFromTables

procedure ExportExcelFromTables(var ConfigPackageTable: Record "Config. Package Table"): Boolean

Parameters

Name Type Description
ConfigPackageTable Table System.IO."Config. Package Table"

Returns

Type Description
Boolean

ExportExcelTemplateFromTables

procedure ExportExcelTemplateFromTables(var ConfigPackageTable: Record "Config. Package Table"): Boolean

Parameters

Name Type Description
ConfigPackageTable Table System.IO."Config. Package Table"

Returns

Type Description
Boolean

ExportExcel

procedure ExportExcel(var FileName: Text, var ConfigPackageTable: Record "Config. Package Table", ExportFromWksht: Boolean, SkipData: Boolean): Boolean

Parameters

Name Type Description
FileName Text
ConfigPackageTable Table System.IO."Config. Package Table"
ExportFromWksht Boolean
SkipData Boolean

Returns

Type Description
Boolean

ImportExcelFromConfig

procedure ImportExcelFromConfig(ConfigLine: Record "Config. Line")

Parameters

Name Type Description
ConfigLine Table System.IO."Config. Line"

ImportExcelFromPackage

procedure ImportExcelFromPackage(): Boolean

Returns

Type Description
Boolean

ImportExcelFromSelectedPackage

procedure ImportExcelFromSelectedPackage(PackageCode: Code[20]): Boolean

Parameters

Name Type Description
PackageCode Code[20]

Returns

Type Description
Boolean

SetSelectedTables

procedure SetSelectedTables(var ConfigPackageTable: Record "Config. Package Table")

Parameters

Name Type Description
ConfigPackageTable Table System.IO."Config. Package Table"

ImportExcel

procedure ImportExcel(var TempBlob: Codeunit "Temp Blob"): Boolean

Parameters

Name Type Description
TempBlob Codeunit System.Utilities."Temp Blob"

Returns

Type Description
Boolean

ClearOpenXmlVariables

procedure ClearOpenXmlVariables()

CreateBook

procedure CreateBook(var TempBlob: Codeunit "Temp Blob")

Parameters

Name Type Description
TempBlob Codeunit System.Utilities."Temp Blob"

SetHideDialog

procedure SetHideDialog(NewHideDialog: Boolean)

Parameters

Name Type Description
NewHideDialog Boolean

SetFileOnServer

procedure SetFileOnServer(NewFileOnServer: Boolean)

Parameters

Name Type Description
NewFileOnServer Boolean

Events

OnBeforeExportExcel

[IntegrationEvent(False,False)]
local procedure OnBeforeExportExcel(var ConfigPackageTable: Record "Config. Package Table")

Parameters

Name Type Description
ConfigPackageTable Table System.IO."Config. Package Table"

OnBeforeBLOBExport

[IntegrationEvent(False,False)]
local procedure OnBeforeBLOBExport(var TempBlob: Codeunit "Temp Blob")

Parameters

Name Type Description
TempBlob Codeunit System.Utilities."Temp Blob"

OnBeforeCreateTableColumnNames

[IntegrationEvent(False,False)]
local procedure OnBeforeCreateTableColumnNames(var ConfigPackageField: Record "Config. Package Field", var ConfigPackageTable: Record "Config. Package Table", var TypeHelper: Codeunit "Type Helper", var ConfigXMLExchange: Codeunit "Config. XML Exchange", var OpenXMLManagement: Codeunit "OpenXML Management", var IsHandled: Boolean, var ColumnNamesRowNo: Integer)

Parameters

Name Type Description
ConfigPackageField Table System.IO."Config. Package Field"
ConfigPackageTable Table System.IO."Config. Package Table"
TypeHelper Codeunit System.Reflection."Type Helper"
ConfigXMLExchange Codeunit System.IO."Config. XML Exchange"
OpenXMLManagement Codeunit System.Xml."OpenXML Management"
IsHandled Boolean
ColumnNamesRowNo Integer

OnBeforeExportExcelTemplateFromTables

[IntegrationEvent(False,False)]
local procedure OnBeforeExportExcelTemplateFromTables(var ConfigPackageTable: Record "Config. Package Table", var Result: Boolean, var IsHandled: Boolean)

Parameters

Name Type Description
ConfigPackageTable Table System.IO."Config. Package Table"
Result Boolean
IsHandled Boolean

OnBeforeGetTableColumnName

[IntegrationEvent(False,False)]
local procedure OnBeforeGetTableColumnName(ConfigPackageField: Record "Config. Package Field", Dimension: Record Dimension, var TableColumnName: Text, var IsHandled: Boolean)

Parameters

Name Type Description
ConfigPackageField Table System.IO."Config. Package Field"
Dimension Table Microsoft.Finance.Dimension.Dimension
TableColumnName Text
IsHandled Boolean

OnCreateTableColumnNamesOnAfterCalcShouldRunIteration

[IntegrationEvent(False,False)]
local procedure OnCreateTableColumnNamesOnAfterCalcShouldRunIteration(var ConfigPackageField: Record "Config. Package Field", var ShouldRunIteration: Boolean)

Parameters

Name Type Description
ConfigPackageField Table System.IO."Config. Package Field"
ShouldRunIteration Boolean

OnCreateTableColumnNamesOnAfterCalcShouldSetCellComment

[IntegrationEvent(False,False)]
local procedure OnCreateTableColumnNamesOnAfterCalcShouldSetCellComment(var ConfigPackageField: Record "Config. Package Field", var ConfigPackageTable: Record "Config. Package Table", var ShouldSetCellComment: Boolean)

Parameters

Name Type Description
ConfigPackageField Table System.IO."Config. Package Field"
ConfigPackageTable Table System.IO."Config. Package Table"
ShouldSetCellComment Boolean

OnExportExcelFromConfigOnBeforeExportExcel

[IntegrationEvent(False,False)]
local procedure OnExportExcelFromConfigOnBeforeExportExcel(var ConfigLine: Record "Config. Line", var ConfigPackageTable: Record "Config. Package Table")

Parameters

Name Type Description
ConfigLine Table System.IO."Config. Line"
ConfigPackageTable Table System.IO."Config. Package Table"

OnImportExcelFile

[IntegrationEvent(False,False)]
local procedure OnImportExcelFile(var TempBlob: Codeunit "Temp Blob", var IsHandled: Boolean)

Parameters

Name Type Description
TempBlob Codeunit System.Utilities."Temp Blob"
IsHandled Boolean

OnIsImportFromExcelConfirmedOnAfterReadFromExcel

[IntegrationEvent(False,False)]
local procedure OnIsImportFromExcelConfirmedOnAfterReadFromExcel(var Result: Boolean, var IsHandled: Boolean)

Parameters

Name Type Description
Result Boolean
IsHandled Boolean

OnAddAndInitializeTableDefinitionPartOnBeforeGetDataTable

[IntegrationEvent(False,False)]
local procedure OnAddAndInitializeTableDefinitionPartOnBeforeGetDataTable(var ConfigPackageTable: Record "Config. Package Table", var DataTableCounter: Integer, var ColumnNameAndRowNo: Code[10], var RowNo: Integer)

Parameters

Name Type Description
ConfigPackageTable Table System.IO."Config. Package Table"
DataTableCounter Integer
ColumnNameAndRowNo Code[10]
RowNo Integer

OnExportExcelOnBeforeWrkShtWriterCreateTableParts

[IntegrationEvent(False,False)]
local procedure OnExportExcelOnBeforeWrkShtWriterCreateTableParts(var ConfigPackageTable: Record "Config. Package Table", var DataTableCounter: Integer)

Parameters

Name Type Description
ConfigPackageTable Table System.IO."Config. Package Table"
DataTableCounter Integer

OnReadWorksheetDataOnAfterPackageCodeRead

[IntegrationEvent(False,False)]
local procedure OnReadWorksheetDataOnAfterPackageCodeRead(CellValueText: Text, var FirstDataRow: Integer)

Parameters

Name Type Description
CellValueText Text
FirstDataRow Integer

See also