en:infra-convert:user:exceltemp
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
en:infra-convert:user:exceltemp [2019/06/14 16:06] me |
en:infra-convert:user:exceltemp [2019/10/02 13:23] me |
||
|---|---|---|---|
| Line 13: | Line 13: | ||
| #@IC_HTML@# 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, #@IC_HTML@# creates an Excel file (.XLSX, more file formats coming soon) with the test plan parameters you specify. | #@IC_HTML@# 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, #@IC_HTML@# creates an Excel file (.XLSX, more file formats coming soon) with the test plan parameters you specify. | ||
| - | {{ :en:infra-convert:user:interface:excel-export_workflow.png?direct&300 |}} | + | {{ :en:infra-convert:user:interface:excel-export_workflow.png?nolink&300 |}} |
| \\ | \\ | ||
| Line 38: | Line 38: | ||
| #@IC_HTML@# 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: [[https://support.office.com/en-us/article/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64|Defining and Using Names in Formulas]]. | #@IC_HTML@# 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: [[https://support.office.com/en-us/article/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64|Defining and Using Names in Formulas]]. | ||
| - | > **Wichtig** Es kann jeder Name nur einmal vergeben werden. | + | > **Important** Each name can only be assigned once. |
| {{ :en:infra-convert:user:interface:excel-pruefbericht_erstellen.png?direct&800 |}} | {{ :en:infra-convert:user:interface:excel-pruefbericht_erstellen.png?direct&800 |}} | ||
| Line 57: | Line 57: | ||
| ^ 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) | | | ^ 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) | | | ^ 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) | | | ||
| + | ^ NominalUnit | Unit of measurement | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]]\\ (Available from program version 1.3.9.7) | | ||
| + | ^ ToleranceUnit | Unit of the tolerance limits | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]]\\ (Available from program version 1.3.9.7) | | ||
| ^ CharacteristicType | Characteristic type (variabele, attributive) | More > Terms > [[en:infra-convert:user:terms#en:infra-convert:user:terms#characteristic_test-_quality|Characteristic (test-, quality-)]] | | ^ CharacteristicType | Characteristic type (variabele, attributive) | More > Terms > [[en:infra-convert:user:terms#en:infra-convert:user:terms#characteristic_test-_quality|Characteristic (test-, quality-)]] | | ||
| ^ CharacteristicTypeId | Characteristic type ID (1 = Variabele; 0 = Attributive)\\ (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-)]] | | ^ CharacteristicTypeId | Characteristic type ID (1 = Variabele; 0 = Attributive)\\ (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-)]] | | ||
| Line 67: | Line 69: | ||
| ^ DrawingQuadrant | Field division | More > Terms > [[en:infra-convert:user:terms#drawing_sheet|Drawing sheet]] | | ^ DrawingQuadrant | Field division | More > Terms > [[en:infra-convert:user:terms#drawing_sheet|Drawing sheet]] | | ||
| ^ SpecialCategory | Category | More > Terms > [[en:infra-convert:user:terms#category_characteristic|Category (characteristic-)]] | | ^ SpecialCategory | Category | More > Terms > [[en:infra-convert:user:terms#category_characteristic|Category (characteristic-)]] | | ||
| - | ^ SpecialCategoryId | Category ID\\ (Available as of program version 1.3.4.1) | More > [[en:infra-convert:user:terms#Kategorie (Merkmal-)|Kategorie (Merkmal-)]] | | + | ^ SpecialCategoryGuid | Category GUID\\ (Available as of program version 1.3.9.4) | More > [[en:infra-convert:user:terms#Kategorie (Merkmal-)|Kategorie (Merkmal-)]] | |
| ^ Tags | Label/Tag | More > Terms > [[en:infra-convert:user:terms#label|Label]] | | ^ Tags | Label/Tag | More > Terms > [[en:infra-convert:user:terms#label|Label]] | | ||
| ^ DrawingSheet | File name of the drawing sheet including the file ending\\ (Available as of program version 1.3.4.1) | | | ^ DrawingSheet | File name of the drawing sheet including the file ending\\ (Available as of program version 1.3.4.1) | | | ||
en/infra-convert/user/exceltemp.txt · Last modified: 2023/11/17 13:54 by me
Page Tools
