hexagon logo
Register Sign in
  • Replies 6 replies
  • Subscribers 222 subscribers
  • Views 141 views
  • Users 0 members are here
Options
Related

Excel template append to new sheet

Edgewise
I am creating a new Excel template to use for my company. I have it formatted nicely, but there is one thing I can't figure out.

Rather than appending a new execution to new rows/columns, I would like it to append to an additional sheet (1 sheet per piece). Is there any way to do this in PC-DMIS? Im using 2023. I know it can be done with the Report window print setup method, but I can't figure out how to make it work with a template.
Parents
  • Sorry for the late reply guys, I was fiddling and decided to go a different route. I now have a working excel report that utilizes 2 sheets. the front sheet acts as a cover page and has some pretty formatting that shows balloon#'s, noms, +/-, and the min/max of every dimensions of all parts.. The second sheet it is basically the database for each part ran, it shows time/date for each part and every measured value as well as 3 columns preceding that shows nom, +/-.

    Now I must tackle automating the conditional formatting. Apparently pc-dmis excel templates will not use it.
  • in reply to Edgewise
    Are you using the Excel report forms option in the reporting menu? I'm curious what steps you took for your route.
Reply Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement