How to get "Drawing Number" from PiWeb to Excel xlt file when created?

[[Ri...]]

I am trying to pass the Drawing Number from PiWeb to Excel when it is created, I know I can add "Drawing No." to the "Input Parameter" dialog box, but it has to be a variable and that box doesn't allow formulas.

Any assistance is appreciated.

Edited October 30

[[Ky...]]

Hey Richard,

 

So, how are you getting the value into PiWeb? If you are just worried about setting up a formula for the drawingno, you can use PCM in the pre/post settings (if you have the license somewhere) or put it in a formula for the comment of a characteristic or in a text element. The command would be setRecordHead("drawingno",VAL), where VALis whatever you calculate the drawing number to be.

[[Ri...]]

Unfortunately, I am not PiWeb smart, I hardly understand it.

This template was most likely created by Zeiss about ten years ago (Calypso v2017).

A little digging and I found a variable tied to u_pPartNumb.

setRecordHead("drawingno",PN)

This put the value on the Excel sheet.

Thank you.

[[Ky...]]

Ah, okay. Looks like the part number might be a custom header field. If you're okay with what you have now, that's fine. Otherwise, this document covers how to add that "u_pPartNumb" or whatever to the ReportINI and add it to the excel file.

https://portal.zeiss.com/knowledge-base?id=1664567