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:18] 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 67: | Line 67: | ||
^ 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) | | |