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/05/24 14:49] me |
en:infra-convert:user:exceltemp [2019/09/06 13:39] me |
||
---|---|---|---|
Line 33: | Line 33: | ||
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 > [[en:infra-convert:user:functions:cplanexport#arbeitsablauf|Export test plan]] > Step 2d. | 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 > [[en:infra-convert:user:functions:cplanexport#arbeitsablauf|Export test plan]] > Step 2d. | ||
+ | |||
+ | > **Important** Only one worksheet of #@IC_HTML@# 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. | ||
#@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]]. | ||
+ | |||
+ | > **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 63: | 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) | | |