~~NOTOC~~ > Benutzerhandbuch #@IC_HTML@# > Weiteres ====== Create and customize Excel templates ====== ---- With #@IC_HTML@# you can export inspection plan contents directly to a Microsoft Excel workbook. You can use the supplied Excel test report templates directly or modify them as you wish. However, you can also create your own templates just as easily. In doing so, you can use Excel files that already exist in the company. This page describes how you can create and customize Excel templates. {{ :en:infra-convert:user:interface:elias_excel_report.png?nolink&750 |}} \\ //**__Content__**//  • [[en:infra-convert:user:exceltemp#Fundamentals]]\\  • [[en:infra-convert:user:exceltemp#Structure]]\\  • [[en:infra-convert:user:exceltemp#Export variables]] \\ ==== Fundamentals ==== If the export of an inspection plan (more precisely: an inspection plan version) to Excel is triggered in #@IC_HTML@#, the available Excel templates are suggested for selection. Based on the selected template, an Excel work file is then created, filled with the inspection characteristics and saved in the specified directory.\\  **See** Functions > Export > [[en:infra-convert:user:functions:cplanexport#arbeitsablaufpruefplanversion_exportieren|Export inspection plan]] > Schritt 2d. {{ :de:infra-convert:user:interface:excel-export_workflow.png?nolink&300 |}} **The file formats** The Excel template file can have one of the following formats: * {{ :de:infra-convert:user:interface:excelvorlage.png?nolink&0x50|}}XLTX (without macros, *.xltx) * XLTM (with macros, *.xltm) The following formats can be exported: * {{ :de:infra-convert:user:interface:excel_arbeitsmappe.png?nolink&0x50|}}XLSX (without macros, *.xlsx) * XLSM (with macros, *.xlsm) * XLS (*.xls) \\ **Requirements** Microsoft Excel should be installed on the computer on which the export is performed in order to use all Excel functions.\\  **See** Settings > Settings > Export > „Excel test plan“ group \\ **The template directory** The following directory is used to store the test report templates supplied with #@IC_HTML@# during installation. %ProgramData%/ELIAS GmbH/infra-Convert/ExcelReports {{ :de:infra-convert:user:interface:excel_vorlagenverzeichnis.png?nolink&0x100 |}} Excel template files located in the set template directory - by default this is the directory mentioned above - are suggested for selection during the export process. The template directory can be changed in the "Settings" menu.\\  **See** Settings > Settings > Export > [[en:infra-convert:user:config:export#excel_test_plan_group|„Excel test plan“ group]]\\ \\ ==== Structure ==== **Das Importblatt** Exactly one worksheet in the workbook can be described during the export process. It does not matter where the sheet is located in the workbook, but it must be active when the template file is saved. In addition, the editing protection for this sheet or the editing protection for the workbook must not be activated. References allow you to use the cell contents on other sheets. > **Tip** If you open an Excel template file by double-clicking it from File Explorer, Excel automatically creates a workbook based on the template, for example an XLSX from an XLTX file. Open the template file from Excel, edit the template as such. This way you can save it directly without having to change the file format again. > **Important** The import sheet must be visible when saving. The sheet protection must not be activated. {{ :de:infra-convert:user:interface:excel_datenblatt_im_vordergrund.png?nolink&0x100 |}} \\ **Define names** #@IC_HTML@# writes the inspection characteristics line by line, i.e. one below the other. Another direction is not possible. Name the first cell in the column to be filled with values with an export variable from the [[en:infra-convert:user:exceltemp#exportvariables|subsequent]] table. Each name can be assigned only once. How to define names in Excel is described in Microsoft's Office Help at this point: [[https://support.microsoft.com/en-us/office/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64?ui=en-US&rs=en-US&ad=US|Defining and using names in formulas]]. > **Tip** Particularly suitable for displaying graphic symbols, such as the diameter sign, is the font **Segoe UI Symbol**.\\ > {{ :de:infra-convert:user:interface:excel-schriftarten.png?nolink&300 |}} {{ :en:infra-convert:user:interface:excel-pruefbericht_erstellen_neu.png?nolink&400 |}} \\ ==== Export variables ==== The following variables are available, see also the table. {{ :de:infra-convert:user:interface:excel-pruefbericht_erstellen_parameter_neu.png?nolink&900 |}} \\ |< 100% 20% 40% 40% >| ^ Name ^ Description ^ Reference ^ ^ CharacteristicClassId | ID ("ELIAS-ID") der Merkmalklasse\\ \\ **Note** Available as of program version 1.3.4.1 | More > Terms > [[http://wiki.elias-gmbh.de/doku.php?id=en:infra-convert:user:terms#class_characteristic|Class (characteristic-)]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: CollClass | ^ CharacteristicGraphic | File name of the stamp graphic including the file ending\\ \\ **Note** Available as of program version 1.3.4.1 | User interface > Function window > Features properties > [[en:infra-convert:user:interface:feature#properties|Properties]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColGraphicFile | ^ CharacteristicId | Unique GUID for the feature\\ \\ **Note** Available as of program version 1.3.4.1 | [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: CollD | ^ CharacteristicType | Characteristic type (variable, attributive) | More > Terms > [[en:infra-convert:user:terms#en:infra-convert:user:terms#characteristic_test-_quality|Characteristic (test-, quality-)]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColAttributeType | ^ CharacteristicTypeId | Characteristic type ID (1 = Variable; 0 = Attributive)\\ \\ **Note** Available as of program version 1.3.4.1 | More > Terms > [[http://wiki.elias-gmbh.de/doku.php?id=en:infra-convert:user:terms#class_characteristic|Class (characteristic-)]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColAttributeType | ^ Class | Characteristic class | More > Terms > [[en:infra-convert:user:terms#en:infra-convert:user:terms#class_characteristic|Class (characteristic-)]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColClass | ^ ClassSymbol | Graphic symbol or label | More > Terms > [[en:infra-convert:user:terms#class_characteristic|Class (characteristic-)]] | ^ Comment | Comment | User interface > Function window > [[en:infra-convert:user:interface:feature|Characteristic properties]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColComent | ^ Conditions | Modifiers\\ \\ **Note** Available from program version 2.2.7| User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] > Modifiers\\ Terms > More > [[en:infra-convert:user:terms#specification_operators_and_modifiers_iso_gps|Specification operators and modifiers (ISO GPS)]] | ^ Count | Number of repetitions\\ \\ **Note** Available from program version 2.2.7 | User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] > [[en:infra-convert:user:interface:feature#properties|Properties]] > Count | ^ DrawingQuadrant | Field division | More > Terms > [[en:infra-convert:user:terms#drawing_sheet|Drawing sheet]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColDrawingQuadrant | ^ DrawingSheet | File name of the drawing sheet including the file ending\\ \\ **Note** Available as of program version 1.3.4.1 | [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColGraphicFile | ^ Fit | Tolerance class (specifiction of fits) | More > Terms > [[en:infra-convert:user:terms#tolerance_table|Tolerance table]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColPassung | ^ Label | Characteristic title, as displayed in #@IC_HTML@# | User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#properties|Properties]] > Titel\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColLabel | ^ LowerLimit | Lower limit value/minimum value, calculated from the nominal value and upper tolerance / lower deviation limit when exporting*\\ \\ **Note** Available as of program version 1.3.4.1 | More > More > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] | ^ LowerTolerance | Lower Tolerance* | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColToleranceLow | ^ MinMax | Tag: Limit dimension in one direction (min., max.)\\ \\ **Note** Available from program version 2.2.7 | Settings > Settings > Merkmale > [[en:infra-convert:user:config:features#limit_values_in_one_direction_min_max_group|“Limit values in one direction (min., max.)” group]] | ^ NominalUnit | Unit of measurement\\ \\ **Note** Available from program version 1.3.9.7 | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] | ^ NominalValue | Value of the nominal value* | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColValue | ^ PositionX | X-coordinate of the stamp in pixel\\ \\ **Note** Available as of program version 1.3.4.1 | Functions > Characteristics > [[en:infra-convert:user:functions:balloonspos|Reposition and align stamp]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColPositionX | ^ PositionY | Y-coordinate of the stamp in pixel\\ \\ **Note** Available as of program version 1.3.4.1 | Functions > Characteristics > [[en:infra-convert:user:functions:balloonspos|Reposition and align stamp]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColPositionY | ^ Radius | Size of the stamp, indicated as radius in pixel\\ \\ **Note** Available as of program version 1.3.4.1 | [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColDiameterStamp | ^ Reference | Reference\\ \\ **Note** Available from program version 2.2.7 | User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | ^ Requirement | Complete requirement, individually formattable for each feature class. | Administrator's Manual > Configuration and Import > Parameter file "CharacteristicClasses" > [[en:infra-convert:dev:characteristicclasses#Formatting the export variable "Requirement"|Formatting the export variable "Requirement"]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColLabel | ^ SpecialCategory | Category | More > Terms > [[en:infra-convert:user:terms#category_characteristic|Category (characteristic-)]] | ^ SpecialCategoryGuid | Category GUID\\ \\ **Note** Available as of program version 1.3.9.4 | More > [[en:infra-convert:user:terms#Kategorie (Merkmal-)|Kategorie (Merkmal-)]] | ^ StampText | Stamp inscription | More > Terms > [[en:infra-convert:user:terms#stamp_stamps|Stamp/stamps]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColStampText | ^ Tags | Label/Tag | More > Terms > [[en:infra-convert:user:terms#label|Label]] | ^ TargetX | X-coordinate of the reference point (target point, origin point) of the stamp in pixel\\ \\ **Note** Available as of program version 1.3.4.1 | Functions > Characteristics > [[en:infra-convert:user:functions:balloonspos|Reposition and align stamp]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColDestinationPositionX | ^ TargetY | Y-coordinate of the reference point (target point, origin point) of the stamp in pixel\\ (Available as of program version 1.3.4.1) | Functions > Characteristics > [[en:infra-convert:user:functions:balloonspos|Reposition and align stamp]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColestinationPositionY | ^ ToleranceTable | Tlolerance table | More > Terms > [[en:infra-convert:user:terms#Toleranztabelle|Toleranztabelle]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColToleranceTable | ^ ToleranceTableColumn | Tolerance class in Tolerance table (column) | More > Terms > [[en:infra-convert:user:terms#Toleranztabelle|Toleranztabelle]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColToleranceTable | ^ ToleranceUnit | Unit of the tolerance limits\\ \\ **Note** Available from program version 1.3.9.7 | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] | ^ UpperLimit | Upper limit value/maximum value, calculated from the nominal value and lower tolerance / upper deviation limit when exporting*\\ \\ **Note** Available as of program version 1.3.4.1 | More > More > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] | ^ UpperTolerance | Upper Tolerance* | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColToleranceHigh | ^ Value | Value\\ \\ **Note** Available as of program version 1.3.4.1 | User interface > Function window > [[en:infra-convert:user:interface:feature|Characteristic properties]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColText | * [**Note** The restriction described in the following no longer applies from programme version 2.5.3. From this version onwards, numerical values are no longer exported as text but as numbers.] Nominal and tolerance values are output as a text string to match the representation in the specification on the drawing. If you want to continue calculating with the numeric values, it may be useful to convert the strings into numbers. You can use the Excel [[https://support.office.com/en-gb/article/wert-funktion-257d0108-07dc-437d-ae1c-bc2d3953d8c2|VALUE]] function for this. ---- **Go to previous page**\\ Export drawing from the CAD system > Siemens PLM > [[en:infra-convert:user:cadexp:solid_edge_2019|Solid Edge 2019]] **Go to next page**\\ More > [[en:infra-convert:user:collectdrw|Create test plans from a collective drawing]]