Difference between revisions of "Excel Output format"
From ArcoWiki
| Line 1: | Line 1: | ||
| + | == Introduction == | ||
It was added the ability to create an output in Excel format.<br /> | It was added the ability to create an output in Excel format.<br /> | ||
The input format (for the template) and the output format (the produced report) are compatible with any version of Excel 12 (Office 2007) or higher versions.<br /> | The input format (for the template) and the output format (the produced report) are compatible with any version of Excel 12 (Office 2007) or higher versions.<br /> | ||
| + | == Measured Features Values == | ||
The template report will fill the information coming from ARCO locating the various values in the cells that carry one of the below listed names: | The template report will fill the information coming from ARCO locating the various values in the cells that carry one of the below listed names: | ||
*“ID”: It represents an auto-incremented value that is assigned to each row produced in output | *“ID”: It represents an auto-incremented value that is assigned to each row produced in output | ||
| Line 22: | Line 24: | ||
*“APPLIEDTO”: the element to which is applied the tolerance | *“APPLIEDTO”: the element to which is applied the tolerance | ||
| + | == Worksheet Formatting == | ||
Some extra cells names shall be used when the worksheet requires some auto formatting rules: | Some extra cells names shall be used when the worksheet requires some auto formatting rules: | ||
*"TODUPLICATE": the cells contained in this range will be duplicated on the next COLUMN on the RIGHT in order to add extra columns to the sheet automatically | *"TODUPLICATE": the cells contained in this range will be duplicated on the next COLUMN on the RIGHT in order to add extra columns to the sheet automatically | ||
| Line 27: | Line 30: | ||
*"FOOTER": the cells contained in this range will NOT be duplicated and must be place at the bottom of the worksheet. (This feature is available from Version 3.6.712) | *"FOOTER": the cells contained in this range will NOT be duplicated and must be place at the bottom of the worksheet. (This feature is available from Version 3.6.712) | ||
| − | + | == Adding QIS variable == | |
| − | When in the [[DMIS]] program are created QIS variable, the same can be sent to EXCEL by simply creating a cell name called an the QIS variable name. | + | When in the [[DMIS]] program are created QIS [[variable]], the same can be sent to EXCEL by simply creating a cell name called an the QIS variable name. |
Revision as of 10:33, 15 May 2019
Introduction
It was added the ability to create an output in Excel format.
The input format (for the template) and the output format (the produced report) are compatible with any version of Excel 12 (Office 2007) or higher versions.
Measured Features Values
The template report will fill the information coming from ARCO locating the various values in the cells that carry one of the below listed names:
- “ID”: It represents an auto-incremented value that is assigned to each row produced in output
- “TYPE”: It represents the type of the measured object (CIRCLE, POINT, DISTANCE, etc.)
- “NAME”: It represents the name of the measured object
- “ACTUAL”: It represents the actual value of the measured object
- “NOMINAL”: It represents the nominal value of the measured object
- “DEVIATION”: It represents the deviation of the measured object
- “LOWERTOLERANCE”: It represents the lower limit of the tolerance of the measured object
- “UPPERTOLERANCE”: It represents the upper limit of the tolerance of the measured object
- “OUTOFTOLERANCE”: it represents the amount out of tolerance of the measured object if present
- “DESCRIPTION”: to be implemented
- “OUTPUTTYPE”: the characteristic sent to output
- “CRITICITY”: to be implemented
- “MODIFIER”: tolerance modifier (if present)
- “INNEROUTER”: two possible values "INNER/OUTER" based on the value of the feature
- “DATUM”: the description of datum
- “FULLDESCRIPTION”: to be implemented
- “PROJECTION”: the projection axis
- “APPLIEDTO”: the element to which is applied the tolerance
Worksheet Formatting
Some extra cells names shall be used when the worksheet requires some auto formatting rules:
- "TODUPLICATE": the cells contained in this range will be duplicated on the next COLUMN on the RIGHT in order to add extra columns to the sheet automatically
- "OUTPUTBLOCK": the cells contained in this range will be duplicated on the next ROW on the BOTTOM in order to add extra rows to the sheet automatically
- "FOOTER": the cells contained in this range will NOT be duplicated and must be place at the bottom of the worksheet. (This feature is available from Version 3.6.712)
Adding QIS variable
When in the DMIS program are created QIS variable, the same can be sent to EXCEL by simply creating a cell name called an the QIS variable name.
