6-Contributor

Question

Custom XLS Report Template

Forum|Forum|2 years ago
August 29, 2023
3 replies
1536 views

I am using Windchill PDMLink Release 12.0 and Datecode with CPS 12.0.2.1

For BOM reports and table exports, one of the options is "Export List to XLS Report" which creates a lightly formatted spreadsheet.
Is it possible to create a custom XLS Report template that would include a "title block"?

Other

16-Pearl

Yes this is possible but you will need a customization for this.

22-Sapphire II

Hi @MM_10260548

Usually you need to create own custom action that does a job what you need.

I did several types of reports based on template excel that the template was saved in the Windchill as a WTDocument.

The action just take the excel template and write data from the report table and saves it to windchill or downloads.

help Wizard Processing describes how to create wizard

And how to add action to the structure menu Customizing Part Structure Browser Actions Toolbar

PetrH

Author

6-Contributor

I was hoping there was a way to extend / customize the existing option to provide selectable templates or even just modify the OOTB template.

22-Sapphire II

Hello @MM_10260548

From my point of view it is easier to create new function then modify OOTB also upgrade will not involve the function.

PetrH

18-Opal

Hello MM_10260548,

You asked some question regarding Windchill, thanks for reaching out, this is Charles from PTC Technical Support in Europe.

fyi XLS gets generated from using Apache POI / HSSF library. And there is unfortunately not support for customization here.

KR,

Charles.