hexagon logo

Excel Form Report and Looping

Looping a program for a capability study, reporting out with Excel Form Report. I have it set up for 30 parts.
2020R2.
It keeps reporting the first part rather than each new part. This used to work. What may have changed?
Parents
  • Updating this as I think I have a consistent solution. The key is the placement of the "print" command. I was placing the print command AFTER the Excel Form Report command thinking that it would "delete last instances" and run the next loop with a clean buffer. Apparently this is not how it works. Placing the print command IMMEDIATELY BEFORE the Excel Form Report command seems to remove everything BUT the last loop from the buffer. This has consistently worked for me.
Reply
  • Updating this as I think I have a consistent solution. The key is the placement of the "print" command. I was placing the print command AFTER the Excel Form Report command thinking that it would "delete last instances" and run the next loop with a clean buffer. Apparently this is not how it works. Placing the print command IMMEDIATELY BEFORE the Excel Form Report command seems to remove everything BUT the last loop from the buffer. This has consistently worked for me.
Children
No Data