User Tools

Site Tools


en:infra-convert:user:exceltemp

This is an old revision of the document!


User manual infra CONVERT > More

Create and customize Excel templates


infra CONVERT allows you to export the contents of a test plan directly into a Microsoft Excel workbook. All you need is an excel template file (.XLT) formatted as described below and Microsoft Excel on the computer on which the export is performed. Using the template, infra CONVERT creates an Excel file (.XLSX, more file formats coming soon) with the test plan parameters you specify.


The supplied test report templates are installed by default in the location opposite.

%ProgramData%/ELIAS GmbH/infra-Convert/ExcelReports

Excel templates can be set up and formatted according to your wishes. You can customize the templates provided or create new templates. Place the templates in the folder named ExcelReports above. When exporting test plans, these templates are available, see Functions > Export > Export test plan > Step 2d.

Important Only one worksheet of infra CONVERT can be filled. The position of the sheet in the workbook is irrelevant, but it must be active respectively visible when the template file is saved.

infra CONVERT writes the inspection characteristics line by line, this means among themselves. Name the first cell in the column to be filled with a value with one of the variables from the table below. How to define names in Excel is described in Microsoft Office Help here: Defining and Using Names in Formulas.

Important Each name can only be assigned once.


Various variables are available to describe the inspection characteristics with their properties.

Name Description Reference
StampText Stamp inscription More > Terms > Stamp/stamps
CharacteristicId Unique GUID for the feature
(Available as of program version 1.3.4.1)
Requirement Complete requirement, individually formattable for each feature class. Administrator's Manual > Configuration and Import > Parameter file “CharacteristicClasses” > Formatting the export variable "Requirement"
Value Value
(Available as of program version 1.3.4.1)
User interface > Function window > Characteristic properties
NominalValue Value of the nominal value* More > Terms > Measurement (sizes-)
UpperTolerance Upper Tolerance* More > Terms > Measurement (sizes-)
LowerTolerance Lower Tolerance* More > Terms > Measurement (sizes-)
UpperLimit Upper limit value/maximum value, calculated from the nominal value and lower tolerance / upper deviation limit when exporting*
(Available as of program version 1.3.4.1)
LowerLimit Lower limit value/minimum value, calculated from the nominal value and upper tolerance / lower deviation limit when exporting*
(Available as of program version 1.3.4.1)
CharacteristicType Characteristic type (variabele, attributive) More > Terms > Characteristic (test-, quality-)
CharacteristicTypeId Characteristic type ID (1 = Variabele; 0 = Attributive)
(Available as of program version 1.3.4.1)
More > Terms > Class (characteristic-)
Class Characteristic class More > Terms > Class (characteristic-)
CharacteristicClassId ID (“ELIAS-ID”) der Merkmalklasse
(Available as of program version 1.3.4.1)
More > Terms > Class (characteristic-)
Fit Tolerance class (specifiction of fits) More > Terms > Tolerance table
Comment Comment User interface > Function window > Characteristic properties
ToleranceTable Tlolerance table More > Terms > Toleranztabelle
ToleranceTableColumn Tolerance class in Tolerance table (column) More > Terms > Toleranztabelle
DrawingQuadrant Field division More > Terms > Drawing sheet
SpecialCategory Category More > Terms > Category (characteristic-)
SpecialCategoryId Category ID
(Available as of program version 1.3.4.1)
More > Kategorie (Merkmal-)
Tags Label/Tag More > Terms > Label
DrawingSheet File name of the drawing sheet including the file ending
(Available as of program version 1.3.4.1)
PositionX X-coordinate of the stamp in pixel
(Available as of program version 1.3.4.1)
PositionY Y-coordinate of the stamp in pixel
(Available as of program version 1.3.4.1)
TargetX X-coordinate of the reference point (target point, origin point) of the stamp in pixel
(Available as of program version 1.3.4.1)
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)
Radius Size of the stamp, indicated as radius in pixel
(Available as of program version 1.3.4.1)
CharacteristicGraphic File name of the stamp graphic including the file ending
(Available as of program version 1.3.4.1)

* 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 VALUE function for this.


Go to previous page
Export drawing from the CAD system > Siemens PLM > Solid Edge 2019

Go to next page
More > Create test plans from a collective drawing

en/infra-convert/user/exceltemp.1560521249.txt.gz · Last modified: 2019/06/14 16:07 by me