Transferring report data into an excel document

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Transferring report data into an excel document

    The title of this is the question. How do you do this inside of PC-DMIS? When a report is normally printed, it is printed in PDF. Is there a way i can get a report in excel?

    The reports that we send to the companies we supply is an excel document. It would be a lot easier if i could just copy and paste or be able to send them the data directly from PC-DMIS.

    As of right now, i am spending a lot of time with data entry because i am both the operator and the programmer.

    Thanks in advance guys/gals!

  • #2
    Well, on more recent versions of PC-DMIS there's excel file output within the print command.
    There's also file/writeline code that you can append a CSV file using.
    There's one more method on older versions called PCD2EXCEL, which has been essentially replaced with the excel print command above.

    Comment


    • #3
      Originally posted by ThePudds View Post
      The title of this is the question. How do you do this inside of PC-DMIS? When a report is normally printed, it is printed in PDF. Is there a way i can get a report in excel?

      The reports that we send to the companies we supply is an excel document. It would be a lot easier if i could just copy and paste or be able to send them the data directly from PC-DMIS.

      As of right now, i am spending a lot of time with data entry because i am both the operator and the programmer.

      Thanks in advance guys/gals!
      Easiest, though the rarest accepted by customer, is for you to just type "see Report" and supply CMM report. Boom, finished!!!
      PcDmis 2015.1 SP10 CAD++
      Global 7-10-7 DC800S

      Comment


      • #4
        2019R1
        Insert - Report command - Print command
        F9 and it has an option for Excel output

        Comment


        • #5
          Originally posted by louisd View Post
          Well, on more recent versions of PC-DMIS there's excel file output within the print command.
          There's also file/writeline code that you can append a CSV file using.
          There's one more method on older versions called PCD2EXCEL, which has been essentially replaced with the excel print command above.
          There's also the option of writing scrips, though usually not the route folks take due to the 'steep' learning curve and time it takes to achieve... but once you master it!
          PcDmis 2015.1 SP10 CAD++
          Global 7-10-7 DC800S

          Comment


          • #6
            The way I did this was to write a custom script within Pcdmis the only trouble was the length of time it took, the actual measurement and tolerancing of the program was 1330 lines and the script that was on the end of it added an extra 3016 lines, this exports time, size, probe used, co-ordinates, temperature, type of measurement, geometric tolerance type and size, part number, serial number drawing number etc and uploads it to a custom spread sheet that was written in python by our IT dept so that they could compare cmm data to on machine data

            Comment


            • #7
              Thanks guys! Helped a lot. I have 2016 on one machine and 2019R2 on another.

              Comment

              Related Topics

              Collapse

              Working...
              X