hexagon logo

PCD2EXCEL Reporting

So the issue I am haveing is when I do a loop of any sort and use PCD2EXCEL the first loop data will be reported, then when I run the 2nd loop both the first and 2nd will be reported so on and so on...

I there a way to have it and export only the most current loop data?

I have tried every way I could think of, even trying to get it to loop without being a loop, but I haven't been able to figure it out.

I guess I should also ask is it even possible?
  • So no one knows if it is even possible to report only the most current iteration of a loop/array?
  • It is not possible using pcd2excel. You would need to write your own script, or try one of the "output to Excel" scripts from the code samples forum. I think there is at least one available for download from the Hexagon website as well.

    Is each loop iteration a complete part measurement?

    Pcd2excel does have an option to output looped dimensions either in measured sequence or together. (Can't recall the exact terminology). If you choose the "together" option and call pcd2excel outside the loop, then you'll have the results for each dimension listed sequentially.
  • Yes each loop is a comlpete part measurement.

    The terms are By Position and By Execution.
    By Position it will list the all the first dimensions then all the second and so on.
    By Execution will list all the dimesions in the first loop then all dimesions in the second and so on.

    As for writeing my own script, I have only been programing PCDMIS since the beggening of the year with no prior expirence in any other type of programing. So it will be a somewhat long and difficult process of trying to teach myself.

    So I will first try to find something that will work befor I go down that road. Thank you for pointing me in a direction that might help me out.