hexagon logo
Register Sign in
  • Replies 8 replies
  • Subscribers 221 subscribers
  • Views 369 views
  • Users 0 members are here
Options
Related

PC-DMIS not scripting into Excel Properly.

Aaron Neal
Good day!

So, when attempting to script out the results of a program into Excel, I am having an issue regarding the GDT results. For some reason, the results for these inspection points will only populate the first column of my excel sheet. I have other dimensions that are working fine. All other dimensions are coming in fine, and I have the scripting set to append the results from PC-DMIS so I can run an entire job and look at the results when it is done. For some reason though, the GDT results keep populating in the first column of the Excel sheet and write over the previous results, meaning if I run ten parts, I will have the results for all the inspection points in nice, neat columns and rows; however, the GDT results look like I only have one results and the rest of the columns are blank (I have a picture what my excel sheet looks like).

I added pictures of the Settings I have selected to attempt to get the script out. Here is the actual script from the program --> Script.txt

I hope someone understands what I am trying to do and can help. Thank you.




Attached Files
Parents
  • Hi, I've not played much with pulling GD&T/Geotol results in scripts, but what is the usage of this syntax in brackets? Just to help me better understand, I noticed GD&T is the only thing in brackets in your script. 
    xlSheet.Cells(RCount, 4).Value = Cmd.GetText(ID, 0) & "." & "GDT [Ref:" & sPuffer & "]" ' id


    Could you also expand the cell that has the GD&T text data or paste the current cell values shown? It could help backtrack the error and troubleshoot.
Reply
  • Hi, I've not played much with pulling GD&T/Geotol results in scripts, but what is the usage of this syntax in brackets? Just to help me better understand, I noticed GD&T is the only thing in brackets in your script. 
    xlSheet.Cells(RCount, 4).Value = Cmd.GetText(ID, 0) & "." & "GDT [Ref:" & sPuffer & "]" ' id


    Could you also expand the cell that has the GD&T text data or paste the current cell values shown? It could help backtrack the error and troubleshoot.
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement