RationalDMIS 7.1 变量编辑Excel 2020
RationalDMIS 7.1 Excel模板制作 2020
将元素属性输出到 NeptuneExcel
将元素拖放到变量数据区;
(1)将圆的理论X、Y、D值输出到变量
将理论圆拖放到实数节点,会弹出参数选择;勾选希望定义的参数,然后确认,会在元素数据区将这些参数定义为变量,如果自学习打开,会记录如下语句:
(2)将圆的实际X、Y、D值输出到变量
将实际圆拖放到实数节点,会弹出参数选择;勾选希望定义的参数,然后确认,会在元素数据区将这些参数定义为变量,如果自学习打开,会记录如下语句:
用鼠标在NeptuneExcel中选中要输入到的单元格,在变量数据区右键“写到Excel",可以选择“按行”、“按列”、“按选中单元格”的方式来输出,如果自学习打开,会记录如下类似的语句:
WRITE/DID(DIRECTEXCELDEV), CIR1_X:11:3
WRITE/DID(DIRECTEXCELDEV), CIR1_Y:12:3
WRITE/DID(DIRECTEXCELDEV), CIR1_D:13:3
生成的自学习如下:
DECL/COMMON,REAL,CIR1_X
CIR1_X = OBTAIN/F(CIR1),4
DECL/COMMON,REAL,CIR1_Y
CIR1_Y = OBTAIN/F(CIR1),5
DECL/COMMON,REAL,CIR1_D
CIR1_D = OBTAIN/F(CIR1),10
DECL/COMMON,REAL,CIR1_X_1
CIR1_X_1 = OBTAIN/FA(CIR1),4
DECL/COMMON,REAL,CIR1_Y_1
CIR1_Y_1 = OBTAIN/FA(CIR1),5
DECL/COMMON,REAL,CIR1_D_1
CIR1_D_1 = OBTAIN/FA(CIR1),10
DID(DIRECTEXCELDEV) = DEVICE/STOR, 'C:\PROGRAM FILES (X86)\RATIONALDMIS\OUTPUT\零部件检验报告.XLSX'
OPEN/DID(DIRECTEXCELDEV), DIRECT, OUTPUT, APPEND
WRITE/DID(DIRECTEXCELDEV), CIR1_X:11:3
WRITE/DID(DIRECTEXCELDEV), CIR1_Y:12:3
WRITE/DID(DIRECTEXCELDEV), CIR1_D:13:3
WRITE/DID(DIRECTEXCELDEV), CIR1_X_1:11:4
WRITE/DID(DIRECTEXCELDEV), CIR1_Y_1:12:4
WRITE/DID(DIRECTEXCELDEV), CIR1_D_1:13:4
CLOSE/DID(DIRECTEXCELDEV)