Transferring report data into an excel document

[ThePudds]

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!

[louisd]

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.

[Kp61dude!]

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!!!

[Disal]

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

[Kp61dude!]

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!

[TIMSHARMAN]

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

[ThePudds]

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